| Other SQL PLSQL Interview Questions |
|| Asked @
|What happens if a procedure that updates a column of table X
is called in a database trigger of the same table ?
|what is definer rights invoke rights?
|Whate is use of MOD function in pl/sql.
|What is the difference between SQL Constraint and PL/SQL
constraint.Pls give all the constraint name.
|What are the cursor attributes used in PL/SQL ?
|What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
|if i perform any operation on views such as insert, delete
etc will my base table get affected?????
|What is Referential Integrity?
|why should required nested tables, Object types, partition
tables and varying arrays. what is the difference between
these are all. give me example with explanation.
|how to eliminate null values in a column i.e
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);
|How can multiply values of a column? OR How can multiply value
of a row of a column using a single query in SQL?
|Can we interchange parameters in procedure while calling
|For more SQL PLSQL Interview Questions Click Here |