What are the return values of functions SQLCODE and SQLERRM ?
Answers were Sorted based on User's Feedback
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 |
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 |
How do I view a table in sql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
define sql delete statement ? : Sql dba
What can you do with pl sql?
What is the best sql course?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
how to select unique records from a table? : Sql dba
how are mysql timestamps seen to a user? : Sql dba
Show the cursor attributes of pl/sql.
what are the join types in tsql? : Transact sql
How do you write a complex sql query?
what is a cursor? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)