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
How to read/write files from pl/sql?
What is union and union all keyword in sql?
What is a database? Explain
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;
Define the select into statement.
Query for second maximum salary in each in each department
15 Answers DST Global Solutions, TCS,
What is assignment operator in pl sql?
What is sql mysql pl sql oracle?
what is a database lock ? : Sql dba
What is the importance of sqlcode and sqlerrm?
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
What is Primary Key?