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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What are the return values of functions SQLCODE and SQLERRM ?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are the return values of functions SQLCODE and SQLERRM ?..

Answer / tulsi

SQLCODE returns the latest code of the error that has
occured.
SQLERRM returns the relevant error message of the SQLCODE.

Is This Answer Correct ?    16 Yes 0 No

What are the return values of functions SQLCODE and SQLERRM ?..

Answer / pervez

Hi Tulsi,
Sqlerrm returns error number as well as error message of
last error occured.

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

What is an inner join sql?

0 Answers  

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  

Can you do multiple joins in sql?

0 Answers  

What is sqlerrm?

0 Answers  

how to use in conditions? : Sql dba

0 Answers  

How much does sqlite cost?

0 Answers  

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

Do foreign keys improve performance?

0 Answers  

What are pl/sql exceptions? Tell me any three.

1 Answers  

Is delete faster than truncate?

0 Answers  

What are local and global variables and their differences?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories