What is replication id?

0 Answers  

---

Does view contain data?

0 Answers  

---

What jobs use sql?

0 Answers  

---

What does pl sql developer do?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

Can u create a primary key with out unique index.

8 Answers  

---

what is the difference between nested subquery and correlated subquery?

0 Answers  

---

How do you write a complex sql query?

0 Answers  

---

How can we debug in PL/SQL?

0 Answers  

---

What are the ways on commenting in a pl/sql code?

0 Answers  

---

What does inner join mean?

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,

---