What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

What is pl sql quora?

0 Answers  

---

what is self join and what is the requirement of self join? : Sql dba

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,

---

Is a view faster than a stored procedure?

0 Answers  

---

---

Does a user_objects view have an entry for a trigger?

0 Answers  

---

Is merge a dml statement?

0 Answers  

---

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

---

What is asqueryable?

0 Answers  

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---

write a query that returns first characters of each word in Oracel/Sql pl sql

5 Answers  

---

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

---