What is auto increment in sql?

0 Answers  

---

what is recursive stored procedure? : Sql dba

0 Answers  

---

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

---

What is case function?

0 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

---

trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 Answers   Oracle,

---

What are different joins used in sql?

0 Answers  

---

What is the example of procedure?

0 Answers  

---

What is foreign key sql?

0 Answers  

---

How to connect a sql*plus session to an oracle server?

0 Answers  

---

What is a stored procedure in sql with example?

0 Answers  

---

What is posting?

0 Answers  

---