Answer / gogu s k

For security and audit related events and to record changes
done to database, triggers are best.

For applying business rules and performing dml operations
procedures are ideal.

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

Which type of cursor is used to execute the dml statement?

0 Answers  

---

What are the pre requisites?

1 Answers  

---

What are sql triggers used for?

0 Answers  

---

What is right join sql?

0 Answers  

---

How many joins in sql?

0 Answers  

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

What is the primary key?

0 Answers  

---

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

---

What are the ways on commenting in a pl/sql code?

0 Answers  

---

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

---

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,

---