It created the sequence (though it did not store it in the table script) and created the trigger, but when I try to add a new row to the table (either manually or using an insert script) I get this error:
ORA-04098: trigger is invalid and failed re-validation
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Why doesn't the Oracle optimizer use my index?
Querying too much data
Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table.
So, the obvious side…
Subquery in Oracle:
Sub queries are one of advance queries in oracle.
Types of advance queries:
• Sub Queries
• Hierarchical Queries
• Set Operators
Sub queries are know as the query called from another query or another subquery. It can …