What are the return values of functions SQLCODE and SQLERRM ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many columns should be in an index?

701


What are the datatypes available in pl/sql ?

787


what are null values? : Sql dba

704


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

777


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

727






What are %type and %rowtype for?

805


What are the differences between implicit and explicit cursors?

697


What is sql and db2?

720


What is compute?

726


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

719


how to convert dates to character strings? : Sql dba

721


Is sql a case sensitive language?

702


what is the difference between inner and outer join? Explain with example. : Sql dba

722


What is the difference between join and natural join?

649


What is a sql statement?

689