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 schema in sql?

0 Answers  

What is set serveroutput on in pl sql?

0 Answers  

how to use case expression? : Sql dba

0 Answers  

In testing where do we use sql language and how it helps in testing?

2 Answers  

How many levels can subqueries be nested in a FROM clause?

7 Answers  




How do you optimize a stored procedure in sql?

0 Answers  

How can I see all tables in sql?

0 Answers  

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

how to enter binary numbers in sql statements? : Sql dba

0 Answers  

how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

how many tables will create when we create table, what are they? : Sql dba

0 Answers  

What is auto increment in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories