| Other SQL PLSQL Interview Questions |
|| Asked @
|I have a procedure in a procedure. The inner procedure
contains out parameter. How I can call the inner procedure
in the out procedure and send the inner procedure parameter
value(out parameter value) into out procedure?
|suppose we have values like 1 5 7 in a colum.Now we want
numbers like(2 3 4 6) that exists between 1 5 7.How can we
do this using sql query??
|How to display the contents of a current record fetched in
a reference cursor?
|How One can easily select all even, odd, or Nth rows from a
table using SQL queries?
|what command is used to create a table by copying the
structure of another table including constraints ?
|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 does “select count(*) from tab” result?
|In a package if we have 10 procedures or functions,How to
know which will execute first?
|What is referential integrity ?
|I need a exceptoin in pl/sql block so that if any errors
occur in the block then no exception should errors should
|How will we see framework of a table?
|What are Lexical Parameters.How They are used in Reports 6i
|For more SQL PLSQL Interview Questions Click Here |