What is the difference between execution of triggers and stored procedures?
No Answer is Posted For this Question
Be the First to Post Answer
What is trigger point?
How to connect a sql*plus session to an oracle server?
Is it possible to create the following trigger: before or after update trigger for each row?
Why do we need databases?
HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)
What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.
Can delete statement be rollbacked?
what will be the output: select 1 from emp union all select 2 from emp;
Explain the two type of Cursors ?
What are the possible values that can be stored in a boolean data field?
Difference between global and parameter variables?
What type of join is sql join?