Hi am new to PLSQL & facing problems in writing code like in
SP, Functions, so any one having some SP coding with in
depth explanation please share with me my Email ID
suvarnaatsuvarna@rediffmail.com Or taking tanning on this
please do contact me


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

How to read/write files from pl/sql?

0 Answers  


What is union and union all keyword in sql?

0 Answers  


What is a database? Explain

0 Answers  


4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,


Define the select into statement.

0 Answers  


Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,


What is assignment operator in pl sql?

0 Answers  


What is sql mysql pl sql oracle?

0 Answers  


what is a database lock ? : Sql dba

0 Answers  


What is the importance of sqlcode and sqlerrm?

0 Answers  


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

0 Answers  


What is Primary Key?

4 Answers   Ramco,


Categories