What is partition in sql query?
No Answer is Posted For this Question
Be the First to Post Answer
What is sap sql anywhere?
How is pl sql different from sql?
difference between oracle 8i and oracle 9i
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Why we use cross join?
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;
wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure
What is a join?
Does inner join return duplicate rows?
Can we insert data into view?
Does sql*plus have a pl/sql engine?
what is denormalization. : Sql dba