What are the return values of functions SQLCODE and SQLERRM ?
Answer Posted / pervez
Hi Tulsi,
Sqlerrm returns error number as well as error message of
last error occured.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the mutating table and constraining table?
How do I save a stored procedure?
what is a cursor? : Sql dba
What is the default isolation level in sql server? : Transact sql
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Is json a nosql?
what is transaction? : Sql dba
How would you convert date into julian date format?
How does join work in sql?
Is sql easier than java?
How do you break a loop in pl sql?
Is big data nosql?
What are packages in pl sql and also explain its advantages?
What is rank () in sql?
Can we call dml statement in function?