How many triggers can be applied on a table?
No Answer is Posted For this Question
Be the First to Post Answer
is it possible to pass an object or table to a procedure as an argument?
Can we insert in view in sql?
What is the difference between join and union.
27 Answers 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global,
What is a mutating table
what are the different index configurations a table can have? : Sql dba
If we update a complex view, is base table will get update ?
2 Answers Ardee Technologies, HCL,
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
How do I view a view in sql?
What are pl/sql exceptions? Tell me any three.
What is bulk collect in pl sql?
How do rank () and dense_rank () differ?
what are %TYPE and %ROWTYPE? what is the difference?
7 Answers ICICI, Saama Tech, Sail,