Explain the savepoint statement.
No Answer is Posted For this Question
Be the First to Post Answer
What is sqlerrm?
What is the difference between sum and count in sql?
how can i read write files from pl/sql
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
what is a table in a database ? : Sql dba
How does index help in query performance?
What is the example of procedure?
Explain commit, rollback and savepoint.
Could you please provide oca (oracle 10g) dumps for my certification ?
Can we use the cursor's to create the collection in PL/SQL?
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 unique key constraint? : Sql dba