What is type and rowtype in pl sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is referential integrity ?
Is it possible to update views?
what are date and time data types? : Sql dba
What is the maximum number of columns in sql table?
What is the advantage of index in sql?
How do you update a value in sql?
What is the syntax to add a record to a table?
how is exception handling handled in mysql? : Sql dba
what is the functionality of the function htmlentities? : Sql dba
Define join and name different types of joins?
What is the Diff b/w Constraints and Trigeer
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 Suneel Reddy