Types of triggers in Oracle
row level trigger
statement level trigger
Row level trigger
How do you set autocomit off for DDL commands in Oracle server? Is this possible..?
For DDL commands, We cannot do autocommit off. It is modify structure of database object such as table, view and these commands have automatically commit.Set autocommit on/off is used for DML.
by using set autocommit on we can do it
If unique key constraint on date column is created, will it validate the rows that are inserted with sysdate
Yes.Becoz sysdate contains date and time.For example: if u create a table like thiscreate table ex(id number,date1 date defualt sysdate unique);u get table created. After that if u insert rows in that...
yes it will
What are the career options available in Software Testing Industry?
How to Overcome Employment Gap during interview.
Tell me about a skill you recently acquired or improved.
Aptitude Test Preparation Tips
Does a problem make you a better person?
What are the career opportunities available for MCA Graduates?
What is the role of a mechanical engineer in the Software Industry?
Career Options for BCA Graduates
Do you have any questions that you want to ask?
Provide an example of a goal that you successfully attained.
Ask Interview Question?
Have Career Question?
Ask Only Career questions.