Why stored procedure is better than query?

0 Answers  

---

Can we delete column in sql?

0 Answers  

---

What plvcmt and plvrb does in pl/sql?

0 Answers  

---

State the advatage and disadvantage of Cursor's?

2 Answers  

---

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  

---

---

is mysql query is case sensitive? : Sql dba

0 Answers  

---

i have a customer table. 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_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,

---

What is materialized view. What are different methods of refresh?

0 Answers  

---

How can you fetch first 5 characters of the string?

0 Answers  

---

What is sql stand for?

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

How do you get all records from 2 tables. Which join do you use?

8 Answers   Microsoft,

---