Select No,Name,to_char(Sal,'$9999.99') amount from emp;

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

Question Posted / suresh kumar somayajula

6 Answers
8520 Views
Target, I also Faced
E-Mail Answers

Answer Posted / suresh kumar somayajula

Select No,Name,to_char(Sal,'$9999.99') amount from emp;

Is This Answer Correct ?

0 Yes

12 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is clustered index a primary key?

959

What are crud methods?

1044

What are the advantages of pl sql over sql?

1033

What is consistency?

1135

What is delimiter in pl sql?

1067

what are all the different types of indexes? : Sql dba

1062

How do I save the results of sql query in a file?

986

Why plvtab is considered as the easiest way to access the pl/sql table?

1227

Explain alias in sql?

1056

How many primary keys can a table have?

1020

how to start mysql server? : Sql dba

1212

Why is %isopen always false for an implicit cursor?

1120

Can two tables have same primary key?

986

what are the different type of sql's statements ? : Sql dba

930

What is multiple columns?

1080