Tag: sql

Paginating Results with the Oracle DB

While the Oracle DB has some very powerful functionality, it also seems to be missing some very basic functionality. Many developers, including myself, have often struggled with paginating results from an Oracle query. Even after Googling, I find...

Read more

Stored Procedure Information In PostgreSQL

All information for procedures and triggers in PostgreSQL is stored in the pg_proc table in the system catalog. Here is how to get some of the more useful information.

While working with a PostgreSQL recently I needed to find all the information on...

Read more