| Other SQL PLSQL Interview Questions |
|| Asked @
|take one table is t1 and in that column name is f1
f1 column values are
i want display the values asc and desc in a single output.
sample output is
and f1.d is
|what is pragma ?
|How can i insert data inro a table with 3 columns using
|Write a query to genarate target column.Please answer me.
Q10 Quarter to 2010
Q90 Quarter to 1990
Q80 Quarter to 1980
Q74 Quarter to 1974
|Delete the emps whose salaries are lowest sals of their own
|What is difference between triggers and stored procedures.
And advantages of SP over triggers ?
|What is Overloading of procedures ?
|How to write a procedure for displying the data in a TREE
or (PARENT and CHILD ) relationship , for ex: A is the main
project id, for this project B,C,D are sub tasks(sub
project id's) for B the sub tasks are e,f,g and for c is
h ,i ,j and for d is k,l,m
now i need to display the o/p in a TREE fashion
pls help me ,
thanks in advance
|Which clause of an UPDATE statement allows you to affect
only certain rows of a table?
1. The WHERE clause
2. The SET clause
3. The ROWS AFFECTED clause
4. The ORDER BY clause
|What is the basic structure of PL/SQL ?
|Main diff between varray and nested tablea
|Write the order of precedence for validation of a column in
a table ?
|For more SQL PLSQL Interview Questions Click Here |