What is rownum?

0 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

---

What is PL/SQL table ?

6 Answers  

---

what is self-join? : Sql dba

0 Answers  

---

Explain how exception handling is done in advance pl/sql?

0 Answers  

---

What are the advantages of indexing?

0 Answers  

---

Enlist some predefined exceptions?

0 Answers  

---

What is database migration?

0 Answers  

---

Why is the cursor important?

0 Answers  

---

How to run sql statements with oracle sql developer?

0 Answers  

---

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---