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 different types of constraints?

1176


What is t sql in sql server?

1071


What are tables and fields in the database?

1107


Is postgresql a server?

1046


Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1002


Can we change the table name in sql?

938


What is dense_rank in sql?

983


what's the difference between a primary key and a unique key? : Sql dba

1043


How is data stored in sql?

1058


How to connect a sql*plus session to an oracle server?

1122


What normalization means?

971


What is microsoft t sql?

942


What are the different dml commands in sql?

1169


How can triggers be used for the table auditing?

1068


What is a design view?

921