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;

What is an oracle and why it is used?

1213

---

What is the relationship among database, tablespace and data file?

1037

---

What is the difference between I and G in Oracle?

1149

---

What is a select query statement in oracle?

1027

---

Give the various rollback segment states.

1089

---

Will you be able to store pictures in the database?explain.

1037

---

What is the difference between "as" and "is" in an oracle stored procedure?

1046

---

What is oracle data type?

1007

---

How to turn on or off recycle bin for the instance?

1124

---

How can you use check constraints for self referential integrity?

1017

---

What are the database administrators utilities available?

1096

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1050

---

How many categories of data types?

1043

---

What is materialized view in Oracle?

1114

---

What is set operator oracle?

1034

---