Category: SQL

Select Top n Rows in Oracle vs Transact-SQL

by Andy
Posted on January 20, 2018July 29, 2020
in SQL

Select Top n Rows in Oracle (Retrieve only the top n rows in Oracle) [AdSense-A] From time to time you need to return the top n rows in Oracle from a table. For example “I…

by Andy
Posted on September 18, 2014July 29, 2020
in SQL

[AdSense-A] This quick and dirty query can search for a table name in all your stored procedures within a database. There is really nothing special about the query and I am sure most database administrators…