Answer Posted / vijay patil

-----------table lavel credit debit
select
sum(case when type=credit then isnull(amount,0)end)sum_credit,
sum(case when type=debit then isnull(amount,0) end)sum_debit
from account_table;

OR -----------table lavel credit debit

select type,sum(amount)amt
from account_table
group by type;

OR (at accont lavel credit debit)

select account,type,sum(amount)amt
from account_table
group by account,type;

How can I get column names from a table in oracle?

985

---

When system tablespace is created?

972

---

How does oracle handle read consistency?

1052

---

is there a tool to trace queries, like profiler for sql server?

1078

---

What are the differences between primary key and unique key?

949

---

What is a nested table and how is it different from a normal table?

988

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2130

---

What is the difference between truncate & delete command?

1125

---

How to define default values for formal parameters?

985

---

How to assign data of the deleted row to variables?

1015

---

Where are the settings stored for each instance in oracle?

1063

---

How to select an oracle system id (sid)?

1020

---

Will you be able to store pictures in the database?

1063

---

What is oracle database 10g express edition?

1075

---

How to convert a string to a date in oracle database?

1002

---