| Other SQL PLSQL Interview Questions |
|| Asked @
|Can We write bulk collect statement in triggers?
|Like shown below i have 3 columns(Name,No,Address). The
values in name column i want to modity.
Requirement : Keep only once space between two words
(Fname,Lname) in the Name column.
For this what is the query? Please answer me. Advance
Name No Address Reference
gowri nath -- -- --
|Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
|how u can find the n row from a table?
|what is the difference between pragma exception_init and
|select sal from emp group by sal
|What is Raise_application_error ?
|What is a package ? What are the advantages of packages ?
|if we give update table_name set column_name= default.
what will happen?
its given in pl sql block.what will hapen?
|what is a sub query?how will you calculate working days in
a month using sub query?
|What are the differences between Database Trigger and
Integrity constraints ?
|real time applications of nullif?
|For more SQL PLSQL Interview Questions Click Here |