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...

Give me some examples of predefined exceptions.

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

what are numeric data types? : Sql dba

1060


How to use sql statements in pl/sql?

1120


How to execute a stored procedure?

1089


What is sql prepared statement?

983


Why we use join in sql?

973


How many unique keys can a table have?

1014


Is id a reserved word in sql?

1145


Define implicit and explicit cursors.

1144


How long does it take to learn pl sql?

1061


What is the difference between a primary key and a unique key?

1054


What is sql and its types?

1187


How many types of relationship are there?

1031


Why self join is used in sql?

976


What is the purpose of the sql select top clause?

1112


Explain what is sql?

1115