What are schema-level triggers?
write a query to find 4th max salary
types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.
What is the difference between instead of trigger and after trigger?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
What is sql profiling in oracle?
difference between cursor and procedure in a package
What is a constraint. Types of constraints ?
5 Answers Accenture, BirlaSoft,
What is nvarchar max in sql?
how to decrement dates by 1 in mysql? : Sql dba
What are tuples in sql?
Does truncate require commit?
I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.