how to create a primary key with out creating an index?
Answer Posted / anubha
The above trigger will give error of mutating table as in
this trigger you are doing dml operation on the triggering
table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to get a list of all tables in a database? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what are local and global variables and their differences? : Sql dba
What is trigger in sql and its types?
how to create a new view in mysql? : Sql dba
How do I save a sql query?
List out the acid properties and explain?
what is data control language? : Sql dba
Determine if oracle date is on a weekend?
What is substitution variable in pl sql?
how to drop an existing index in mysql? : Sql dba
What is difference between inner join and cross join?
How much ram can sql express use?
What are all the common sql functions?
What is the difference between inner join and left join?