Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How can we implement rollback or commit statement in a trigger?

Question Posted / ramesh

No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

Do ddl statements need commit?

0 Answers  

How many unique keys can a table have?

0 Answers  

Does group by remove duplicates?

0 Answers  




What are the pre requisites?

1 Answers  

What are the blocks in stored procedure?

6 Answers   Microsoft,

what is the functionality of the function htmlentities? : Sql dba

0 Answers  

What is a sql*loader control file?

0 Answers  

Can a select statement fire a trigger?

0 Answers  

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

How do I view a sql database?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories