SQL Tutorial with Examples

Pl/sql code have Cursors that will fetch table and columns that you want to compare and it will Iterate through all tables in the local d...

This query will let us know the corresponding Sales Order number associated with a given serial number installed in Installed Base. -...

Re-usable SQL Queries useful in day-to-day scenario. COMMON QUERIES *************** SELECT instance_name FROM v$instance; ...

The query that uses partition OVER PARTITION BY analytic function The below example shows the cumulative salary within a departement ...

The query looks for any special characters in column field (specially useful for password field) and reports it.   SELECT DISTINCT emp...

To kill the inactive users login in Oracle from any schema in a database.If any unwanted transactions were kept withput roll back it will...

Table_Finder is a procedure to find all the tables that are queried in a particular package or procedure. It takes Package name or procedur...