| Other SQL PLSQL Interview Questions |
|| Asked @
|Difference between inline query and stored procedure?
|Its possible to add more than one primary key for the table
|Wat is SGA ?
Can anybody please explain me the flow of the below query.
I am not able to understand how this query works.
This query is for finding the Nth highest salary..
SELECT DISTINCT (a.sal)
FROM EMP A
WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B
If N = 2 then second highest salary will be the o/p.
If N = 3 then third highest salary will be the o/p.
and so on..
|What will happen after commit statement ?
|what is oracle sql,pl/sql with interfaces
|Can a view be updated/inserted/deleted?If Yes under what
|What is Highwatermark?
|What are % TYPE and % ROWTYPE ? What are the advantages of
using these over datatypes?
|Whate is use of MOD function in pl/sql.
|how can create data base link for tow servers (scott
schema) give examples plz
|What are the data types allowed in a table?
|For more SQL PLSQL Interview Questions Click Here |