how instead of triger is helpful for mutating tables errors
handlling ?
- 2 Answers
- 10007 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / mahesh
create a view (simple view) on mutating table
write a tigger on view (define similar to table)
Know try to do dml operations on table
it will not show the mutating error
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain the purpose of %type and %rowtype data types with the example?
Are dml statements autocommit?
What can sql server reporting services do?
What is raid? How does it help storage of databases?
Is null operator in sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is acid property in a database?
How do I sort a table in sql?
What does over partition by mean in sql?
What is oracle sql developer?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
How do I save a stored procedure?
What is exception? What are the types of exceptions?
What is difference between rank () row_number () and dense_rank () in sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
