What are the types pl/sql code blocks?

0 Answers  

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---

what is the difference between trigger and constraint?

3 Answers   HSBC,

---

How do you sort in sql?

0 Answers  

---

What is the use of nvl function?

0 Answers  

---

What are the components of a PL/SQL block ?

3 Answers  

---

What is magic table?

6 Answers  

---

How many clustered indexes can be created on a table?

0 Answers  

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

how can stop the sequence with mention the max value and with out mention the max value

1 Answers   Zensar,

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

Which are the most commonly used sql joins?

1 Answers  

---