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 |
What is left join in postgresql?
Do you understand the meaning of exception handling?
overloading of stored procedure is possible in oracle?
What are system versioned tables?
Are sql database names case sensitive?
What is the use of time stamp in select statement?
what is a sub query?how will you calculate working days in a month using sub query?
What is PL/SQL Records?
What is the diffrence between IN and EXISTS.which one is faster.
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
What are the topics in pl sql?
What is difference between sql and excel?
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)