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,

---

What is an Oracle view?

1 Answers  

---

what is the scripts in data base?

0 Answers  

---

What are the uses of linked server and explain it in detail?

0 Answers  

---

what are the diffeenes between oracle 9i,oracle 10g

2 Answers  

---

---

Who i will insert 1 lacks record in a Database table

4 Answers   TCS,

---

12 RULES OF RDBMS

1 Answers  

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

0 Answers  

---

what are corelated subqueries

1 Answers   Global Infotech,

---

consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

What is the difference between primary key and unique key and foreign key in oracle?

0 Answers  

---