Interested to Buy Any Domain ? << Click Here >> for more details...
What are the return values of functions SQLCODE and SQLERRM ?
- 2 Answers
- 11080 Views
- PreVator, I also Faced
- E-Mail Answers
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 inline query and stored procedure?
Explain the structure of pl/sql in brief.
how many groups of data types? : Sql dba
how to see the create table statement of an existing table? : Sql dba
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
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 ?
Is microsoft sql free?
What does the hierarchical profiler does?
What are the benefits of using PL/SQL packages?
how will be date change into string
what is a constraint? : Sql dba
Explain foreign key in sql?
-
Oracle (3253) - 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)
