Interested to Buy Any Domain ? << Click Here >> for more details...
how to create a primary key with out creating an index?
- 9 Answers
- 20865 Views
- TCS, I also Faced
- E-Mail Answers
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
What is the benefit of foreign key?
What is the difference between the conventional and direct path loader? : aql loader
Why join is faster than subquery?
How many aggregate functions are available there in sql?
discuss about myisam index statistics collection. : Sql dba
What is a dynamic query?
Is pl sql a scripting language?
What are views in sql?
What is the difference between partition and index?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is the unique index?
What is the use of sql trace?
Does db2 use sql?
what is not null constraint? : Sql dba
