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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is output spooling in sql*plus?

1020


What are the sql aggregate functions?

1106


How do I write a sql query in pgadmin 4?

962


what are properties of a transaction? : Sql dba

1077


What is db journal file?

1035


How do you know if a relationship is 2nf?

926


Explain constraints in sql?

1028


what is the difference between inner and outer join? Explain with example. : Sql dba

1013


How to run pl sql program in mysql?

998


what is the command used to fetch first 5 characters of the string? : Sql dba

1625


what is not null constraint? : Sql dba

1007


how to drop an existing view in mysql? : Sql dba

1043


what is data integrity? : Sql dba

1020


how to use 'mysql' to run sql statements? : Sql dba

1037


What is the difference between a database and a relational database?

1083