Answer / tulsi

Raise_application_error is a procedure of package
DBMS_STANDARD which allows to issue an user_defined error
messages from stored sub-program or database trigger.

Is join and inner join the same?

0 Answers  

---

What is natural join in sql?

0 Answers  

---

how a reference cursor works?what all adnvantages are gained with it..specify the situation?

4 Answers   TCS,

---

Explain the structure of pl/sql in brief.

0 Answers  

---

Can a view be mutating? If yes, then how?

0 Answers  

---

---

What is a trigger ?

11 Answers   Accenture, BirlaSoft,

---

What is cross join sql?

0 Answers  

---

What is the command used to fetch first 5 characters of the string?

0 Answers  

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

What is the difference between cluster and non-cluster index?

0 Answers  

---

What is a trigger in sql?

0 Answers  

---

Write one update command to update seqno field of a table on the basis of row number.

4 Answers   HCL,

---