| Other SQL PLSQL Interview Questions |
|| Asked @
|Where the Pre_defined_exceptions are stored ?
|function can return value ,procedure also return value through
out parameter then what is the difference?
|which will fire first ? Trigger or Constraint
|what is meant by DML?
|What is Data Concarency and Consistency?
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..
|How do you assign Construct the where clause without
concatenating Field,value pairs?
|What is a join?Explain the different types of joins?
|how to select alphabets in a one column , for this the
table name is PA_TASKS and column name is TASK_NUMBER, In
TASK_NUMBER the data like this
1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For
this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE,
Its some urgent requirement ,thanks in advance
|what is ref cursor in pl/sql?
|what is data integrity
|1. what is the exact use of hint in sql.
2. How we can avoid index scan in sql even though index is
there in the table.
|For more SQL PLSQL Interview Questions Click Here |