in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit

3 Answers   Polaris,

---

waht is the difference between primary key and super key?

9 Answers  

---

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---

Compare and contrast between sql and sql server and explain its various functions?

0 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers  

---

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

What happens if variable names collide with table/column names?

0 Answers  

---

Hi Can any one tell me what are the API's used in requisition import.

0 Answers  

---

What is the difference between column level constraints and table level constraints?

14 Answers   IBM, TCS,

---

Explain integrity constraint?

0 Answers  

---

How do I learn what codesets are available in oracle?

0 Answers  

---

What is transport network substrate (tns) in oracle?

0 Answers  

---