| Other SQL PLSQL Interview Questions |
|| Asked @
|Q1.all the depts which has more then 10 empls? Q2.all the
dept which does not have any emply? Q3 all the emp which
does not have any dept? Q4 get all the emply detais with
the dept details it dept is exit otherwise any emp details?
Q5 how to debugg the dynamic sql and packages?
For j in 4403201000 .. 4403202000
If mod (j, 100) = 0 then
what will be the output of this question
|a. Can you delete data from a View.
b. If Yes, can you delete it if there are multiple tables
c. If No, can you delete if there is single source table
which is joining.
|How to get the 3rd column(i.e all the data along with the
column name)in a table?
|Difference between SUBSTR and INSTR?
|function can return multiple value?how give give sample coding
|What is referential integrity ?
|What is Overloading of procedures ?
|What is NOCOPY?
|1> how are u debugging in plsql ?
2> how to connect oracle database from unix. is there ne
way other than using sqlplus ?
|what is the difference between granting and creating a view?
|why use cursors?
|For more SQL PLSQL Interview Questions Click Here |