| Other SQL PLSQL Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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
surendra | | 2 |
| What is INSTEAD OF trigger ? | TCS | 9 |
| Types of joins ? | Digital-GlobalSoft | 3 |
| How packaged procedures and functions are called from the
following? | | 2 |
| How can i insert data inro a table with 3 columns using
FORALL? | Oracle | 2 |
| What is the difference between SQL table and the PLSQL
table? | Mastek | 1 |
| How to delete same emp id in sql query for exmaple in emp
table emp id, empname, emp address. for example emp id =5,
repeated in two times in rows same id how to delete same
empid please any one of the write query send in my id | CGCI | 7 |
| What are advantages of Stored Procedures? | Satyam | 3 |
| what is a sub query?how will you calculate working days in
a month using sub query? | InteQ | 4 |
| What is Highwatermark? | Thermotech | 3 |
| what is global variable in package | | 2 |
| i have doubt that any one tell ref cursor comes in sql
pl/sql? pls clarify? | | 2 |
| Write one update command to update seqno field of a table
on the basis of row number. | HCL | 3 |
| Delete duplicate records in the emp table. | | 5 |
| I have one Excel file with 1,50,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
I need PLSQL Procedure or used by SQL PLUS
| Polaris | 2 |
| Begin
For j in 4403201000 .. 4403202000
Loop
If mod (j, 100) = 0 then
Dbms_output.put_line (j);
End if;
End loop;
End;
what will be the output of this question | TCS | 4 |
| What is an Exception ? What are types of Exception ? | | 2 |
| Is it possible to use Transaction control Statements such a
ROLLBACK or COMMIT in Database Trigger ? Why ? | | 3 |
| define primary key & secondary key?
| | 1 |
| how to connect oracle in unix prompt? | Polaris | 3 |
| |
| For more SQL PLSQL Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
