What is the difference between the implicit and explicit cursors?
No Answer is Posted For this Question
Be the First to Post Answer
PL/SQL allocates memory for the variable's at runtime or at compile time
what is blob? : Sql dba
Write the command to remove all players named sachin from the players table.
How can u find column name from a table which have max value in a row.( not max value)
when normalization is required
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;
What is the purpose of normalization?
How many triggers can be implemented for a table?
what is the difference between where clause and having clause? : Sql dba
What is difference between sql and excel?
What are the types of sql commands?
Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?