What is the use of %rowtype?

0 Answers  

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---

How do you bind variables in pl sql?

0 Answers  

---

Can I join the same table twice?

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,

---

---

What is sqlite format?

0 Answers  

---

What does (*) mean in sql?

0 Answers  

---

tell us something about heap tables. : Sql dba

0 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---

How do I run sql?

0 Answers  

---

How to select all records from the table?

0 Answers  

---