Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

Give me some examples of predefined exceptions.

Question Posted / nashiinformaticssolutions

Answers were Sorted based on User's Feedback



Give me some examples of predefined exceptions...

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.

Is This Answer Correct ?    0 Yes 0 No

Give me some examples of predefined exceptions...

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.

Is This Answer Correct ?    0 Yes 0 No

Give me some examples of predefined exceptions...

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

What are the built in functions of sql?

0 Answers  

what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,

What is trigger price?

0 Answers  

Can we use view in stored procedure?

0 Answers  

What are the advantages of stored procedure?

0 Answers  

What is the difference between sql and isql*plus?

0 Answers  

what are the 'mysql' command line options? : Sql dba

0 Answers  

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

What is Collation Sensitivity ? What are the various type ?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories