Answer / 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;

Answer / sanjay

select type,sum(amount)from account table group by type

Answer / kamala k n

select type, sum(amount) over (partiton by sid) from tab

How to enter a new row into a table interactively?

0 Answers  

---

Please explain drop constraint oracle?

0 Answers  

---

How to create index-by table in oracle?

3 Answers  

---

The join defined by the default data link is an outer join yes or no ?

1 Answers   Oracle,

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

0 Answers   ESS,

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

---

What are the advantages of oracle?

0 Answers  

---

What is merge statement used for?

0 Answers  

---

What are the different types of databases?

1 Answers  

---

what is kernel?

2 Answers   Microsoft,

---

What are the built-in functions used for sending Parameters to forms ?

0 Answers   Oracle, TCS,

---

List the various oracle database objects?

0 Answers  

---