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


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

Post New Answer

More SQL PLSQL Interview Questions

What is scalar function?

0 Answers  


Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  


Why truncate is faster than delete?

0 Answers  


Mention what plvcmt and plvrb does in pl/sql?

0 Answers  


What is auto increment?

0 Answers  






What are advantages of Stored Procedures?

3 Answers   Satyam,


Can we write create command in the plsql block?if possible how?

2 Answers  


Is big data nosql?

0 Answers  


Differentiate between pl/sql and sql?

0 Answers  


Name the tables where characteristics of Package, procedure and functions are stored ?

3 Answers  


i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,


What is procedure explain with example?

0 Answers  


Categories