Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Find All Tables In An Oracle Database By Column Name

I work with very large Oracle enterprise databases all the time. Consistently, I find myself trying to sift through schemas in the database to find relationships between tables. When tables aren’t named appropriately and you have a lot of them, this can be a long and painful process if you do it manually.

Lucky for us, there is a convenient way to search for the tables you’re looking for based on column information.

Read More

Aggregate SQL Data From Multiple Rows Into A Single Row

Recently I found myself needing to aggregate my multiple row SQL data into a single row. This was because the parent data was more useful to me than the multiple row’d data, but I still needed to include it because it was still an essential part of my report. The data looked something like the following:

firstnamelastnamedepartment
NicRaboyEngineering
MariaCamposEmergency Room
NicRaboyOperations
NicRaboyDesign
Read More

Get The Most Recent Record In A Table By Date And User

I often find myself working with legacy database tables that don’t have primary keys or auto increment keys. In addition to this, I always find myself needing to get the latest record for a particular set of data in my database. It is never as easy as just calling a max in the where clause. A subquery is often needed to get the most recent record in a table.

Read More

Search

Follow Us

The Polyglot Developer

Subscribe

Subscribe to the newsletter for monthly tips and tricks on subjects such as mobile, web, and game development.

The Polyglot Developer

Support This Site