| Other SQL PLSQL Interview Questions |
|| Asked @
|What are Nested Tables? How will u delete 5 rows from Nested
|what is the difference difference between procedure and
|IF i write before / after insert / update trigger and i do
rollback what will happen?
|i want count no of values in a column i.e
enam eempno phoneno
x 1 (98765,09887,096561,87964579,156678,678900876)
that means if i select phone no from table i want to get
total count of phone numbers i.e 6
|What are the two parts of a procedure ?
|what is the difference between to_char and to_date
|What is the basic difference between a sql and stored
|How can we overcome recursive triggers in SQL?
|how can create data base link for tow servers (scott
schema) give examples plz
|What is difference between Procedures and Functions ?
|wht is the difference between truncat,drop in sqlserver
wht is the difference between function and stored procedure
|How many database objects (trigger, packages, sequence etc)
particular field in a given table.
For ex: I want to know how many database object uses the
the PO_VENDORS table.
What query will give me the result showing the database
name(package, trigger etc),
field_name used (in this case ATTRIBUTE1) and table_name
(in this case
|For more SQL PLSQL Interview Questions Click Here |