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.

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

What is sql trigger example?

0 Answers  

---

Does user triggers have entry for trigger with compilation errors?

0 Answers  

---

What is an alias command?

0 Answers  

---

Difference between global and parameter variables?

0 Answers   TCS,

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---

What are %type and %rowtype for?

0 Answers  

---

What are the events on which a database trigger can be based?

0 Answers  

---

how many values can the set function of mysql take? : Sql dba

0 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

explain the delete statements in sql

0 Answers  

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

---