How to create an array in pl/sql?

0 Answers  

---

What is a recursive stored procedure?

0 Answers  

---

What is sql partition function?

0 Answers  

---

What is Overloading of procedures ?

4 Answers   Amdocs,

---

What are the difference between Functions/Stored Procs and Triggers and where are they used.

1 Answers   CGI, TCS,

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

0 Answers  

---

Is join an inner join?

0 Answers  

---

what is the difference between a having clause and a where clause? : Sql dba

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

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 an alias command? : Sql dba

0 Answers  

---

How do I truncate a word?

0 Answers  

---