DB Tables & Queries
**Query to fetch the Nth highest value of a column from table select * from (select Emp_name, Salary, ROW_NUMBER() OVER (ORDER BY salary DESC) as Row_num from Employees_table ) table1 where Row_num = n; **Query to check oracle applications version through back end select * from product_component_version; select release_name from apps.fnd_product_groups; SELECT * FROM apps.ad_bugs WHERE months_between (sysdate,CREATION_DATE)< 6 SELECT * FROM apps.ad_applied_patches WHERE MONTHS_BETWEEN(SYSDATE,CREATION_DATE)<6 select bug_number,creation_date from ad_bugs where bug_number='7579700'; select * from v$version where sid = '127'; select * from V$Container; SELECT * FROM DBA_DML_LOCKS; **Query to get the table names and schema owner from the database SELECT table_name, owner FROM dba_tables WHERE table_name LIKE 'XX_XX%'Order by owner **Query to get the custom views ...