Why truncate is used in sql?

0 Answers  

---

How would you pass hints to the sql processor?

0 Answers  

---

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

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 are the different operators available in sql?

0 Answers  

---

---

what is sql optimization

1 Answers   Fidelity,

---

What is the use of triggers?

0 Answers  

---

How to use sql*plus built-in timers?

0 Answers  

---

What is a sql profiler?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

What do we need to check in database testing?

0 Answers  

---

What is difference between inner join and cross join?

0 Answers  

---