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 are the differences among rownum, rank and dense_rank? : Sql dba

981


how to see the create table statement of an existing table? : Sql dba

946


which operator is used in query for pattern matching? : Sql dba

947


how to concatenate two character strings? : Sql dba

1030


how can we know the number of days between two given dates using mysql? : Sql dba

991


Explian rowid, rownum?

956


What is t-sql? : Transact sql

926


what is timestamp in mysql? : Sql dba

1002


Explain the advantages and disadvantages of stored procedure?

1076


What is Difference Between Unique and Primary Key Constraints?

1058


What is data abstraction in sql?

965


How does postgresql compare to "nosql"?

981


what is a database? : Sql dba

1098


Which query operators in sql is used for pattern matching?

902


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1072