how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  

---

What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,

---

How do I access sql anywhere database?

0 Answers  

---

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

Mention what is the plv (pl/vision) package offers?

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,

---

<<labele>> declare a=10 b=20, begin some statements declare a=30 c=40 end; what is the A value in nested block?

1 Answers   ITC Infotech,

---

Why is pl sql used?

0 Answers  

---

What is a unique key and primary key and foreign key?

0 Answers  

---

How do I view a procedure in sql?

0 Answers  

---

What is cte?

0 Answers  

---