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

Why we use stored procedure instead of query?

1047


What does bitemporal mean?

1112


What is a rank in sql?

1003


What is the difference between instead of trigger and after trigger?

1064


How does cross join work in sql?

1073


What are inner outer left and right joins in sql?

1056


Can we use insert statement in function?

1045


What is the largest value that can be stored in a byte data field?

1056


what is a composite key ? : Sql dba

1099


What is the difference between python and sql?

1051


What is the sql case statement?

1051


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

1082


What is nosql vs sql?

1225


Is left join inner or outer?

1055


Explain the uses of database trigger.

1175