Can i use Commit inside the Trigger? Suppose i use commit
what will be happy (it's complied /executed/work)
- 6 Answers
- 12705 Views
- I also Faced
- E-Mail Answers
Answer Posted / saravanakumar
you can commit trigger if the declaration part contains
autonomus transaction
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Why triggers are used?
What are the different ddl commands in sql?
What are the two types of cursors in pl sql?
Does sql*plus have a pl/sql engine?
What is the purpose of a sql?
What is primary key in db?
How to use boolean type in select statement?
how to enter binary numbers in sql statements? : Sql dba
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is file based approach?
How does a covering index work?
How do I run pl sql in sql developer?
how to use regular expression in pattern match conditions? : Sql dba
How do you delete duplicates in sql query using rowid?
how to convert dates to character strings? : Sql dba
