What is output spooling in sql*plus?
No Answer is Posted For this Question
Be the First to Post Answer
What is sql and its types?
What is sql and also describe types of sql statements?
use of IN/ANY/ALL
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;
How do you explain an index?
Why is the cursor important?
What is the difference between a primary key and a unique key?
What is bind reference and how can it be created?
Is ms sql traffic encrypted?
How do you use collections in procedure to return the resultset?
What is the least restrictive isolation level? : Transact sql
How do you concatenate in sql?