What is procedure and function?

0 Answers  

---

What is the advantage of index in sql?

0 Answers  

---

What is union and union all keyword in sql and what are their differences?

0 Answers  

---

Can a trigger call a stored procedure?

0 Answers  

---

Can delete statement be rollbacked?

0 Answers  

---

How do you update a value in sql?

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 the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

what is sub-query? : Transact sql

0 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

---

What are functions in sql?

0 Answers  

---