What are aggregate functions in sql?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is record data type?
How to use sql statements in pl/sql?
How many triggers can be applied to a table?
Can we use joins in subquery?
Can we insert delete data in view?
what is the difference between a web-garden and a web-farm? : Sql dba
What plvcmt and plvrb does in pl/sql?
What is the need of merge statement?
what is check constraint? : Sql dba
Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance
What are the two types of exceptions.