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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is query cache in mysql? : Sql dba

990


What is difference between stored procedure and trigger?

1057


what is the difference between delete and truncate commands? : Sql dba

995


how to select unique records from a table? : Sql dba

1053


Why query optimization is needed?

861


Sql technical questions

1200


Can a commit statement be executed as part of a trigger?

995


What is the purpose of a secondary key?

899


Explain normalization and what are the advantages of it?

890


Which normal form is best?

895


What are the two virtual tables available at the time of database trigger execution?

1156


Is sqlite good enough for production?

948


Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

953


Can we insert data in view?

888


What is sqlerrd?

921