Answer / nashiinformaticssolutions

Predefined exceptions in PL/SQL include:
• NO_DATA_FOUND: Raised when a SELECT statement returns no rows.
• TOO_MANY_ROWS: Raised when a SELECT INTO statement retrieves multiple rows.
• DUP_VAL_ON_INDEX: Raised when attempting to insert a duplicate value into a specific index.
• ZERO_DIVIDE: Raised when dividing by zero.

Answer / glibwaresoftsolutions

Predefined exceptions in PL/SQL include:
• NO_DATA_FOUND: Raised when a SELECT statement returns no rows.
• TOO_MANY_ROWS: Raised when a SELECT INTO statement retrieves multiple rows.
• DUP_VAL_ON_INDEX: Raised when attempting to insert a duplicate value into a specific index.
• ZERO_DIVIDE: Raised when dividing by zero.

Answer / hr@tgksolutions.com

Predefined exceptions in PL/SQL include:
• NO_DATA_FOUND: Raised when a SELECT statement returns no rows.
• TOO_MANY_ROWS: Raised when a SELECT INTO statement retrieves multiple rows.
• DUP_VAL_ON_INDEX: Raised when attempting to insert a duplicate value into a specific index.
• ZERO_DIVIDE: Raised when dividing by zero.

What are the constraints available in sql?

0 Answers  

---

What is trigger in pl sql?

0 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

What is the difference between jpql and sql?

0 Answers  

---

Can sql function call stored procedure?

0 Answers  

---

---

What is pl sql architecture?

0 Answers  

---

What is mutating error?

0 Answers  

---

Define commit?

0 Answers  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

difference between pl/sql table and normal pl/sql table

2 Answers  

---

What is ttitle and btitle?

0 Answers  

---

Why do we use set serveroutput on?

0 Answers  

---