What is trigger and stored procedure in sql?


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

Post New Answer

More SQL PLSQL Interview Questions

How to call the function and Procedure in trigger?

3 Answers   IBM,


Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,


How can I get the number of records affected by a stored procedure?

0 Answers  


how is exception handling handled in mysql? : Sql dba

0 Answers  


What is the maximum rows in csv?

0 Answers  


How do I kill a query in postgresql?

0 Answers  


What is a temporal table?

0 Answers  


What is the largest value that can be stored in a byte data field?

0 Answers  


How do I view a procedure in sql?

0 Answers  


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  


what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?

3 Answers   3i Infotech,


What is lookup table in sql?

0 Answers  


Categories