| Other SQL PLSQL Interview Questions |
|| Asked @
|what is global variable in package
|What are the usage of SAVEPOINTS?
|How can we Get the Updated Rows? ie, There is 100s of Rows i
updated the Rows who have salary 5000. then i want to select
the Updated Rows. How can we achieve it?
|What are the default Oracle triggers??
|What is a REF CURSOR? Compare strong and week ref cursor types.
|how can we replace the particular column value of a resulted
set of executed query? I mean write down a sql query to
chane the particular column's value of a resulted set of
|I m giving Source, Destination and Age. Write a procedure or
function, it will give to u this source to destination
tickets are available or not, if available then check this
person is senior citizen or not,if this person is senior
citizen then give some discount.
PLZ give this answer......
|Can a table have two primary keys?
|What can be a size of a pl/sql block? Is there any limit?
|Please let me know if UNION ALL and Natural Join does the
same operation and are same...
|Interchange the value of a column Gender in a table where
values are Male and Female. So, where the value is Male, it
should changed to Female and Female to Male.
|Talk about views
|For more SQL PLSQL Interview Questions Click Here |