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 |
Difference between global and parameter variables?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Which is faster joins or subqueries?
What is equi join in sql?
Can a view be updated/inserted/deleted?If Yes under what conditions?
define join and explain different type of joins? : Sql dba
What are the most important characteristics of pl/sql?
what is inline command?
How you will create Toad Function?
How many types of database triggers can be specified on a table ? What are they ?
There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?
what are the different functions in sorting an array? : 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)