What is mutating error?
No Answer is Posted For this Question
Be the First to Post Answer
Why is there a need for sqlcode and sqlerrm variables?
How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
What is difference between triggers and stored procedures. And advantages of SP over triggers ?
what is julian date in oracle
What are the topics in pl sql?
What is the difference between delete, truncate and drop command?
Explain exception handling in pl/sql?
If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
can i write pl/sql code in a package
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.
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
Mention what pl/sql package consists of?