Answer Posted / rajadurai r
There are 20 pre-defined exceptions.
When an exception is raised,normal execution of your PL/SQL
block or subprograms stops and control transfers to its
exception-handling part.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is bitemporal narrowing?
What does stand for in sql?
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
What are triggers in sql?
What are crud methods?
How is a PL/SQL code compiled?
Explain what is a view?
Can a table contain multiple foreign key’s?
How does a covering index work?
How to call shell script from pl sql procedure?
What is clustered and nonclustered index in sql?
What is group by in sql?
What are synonyms in sql?
What is the source code of a program?
what is the difference between rownum pseudo column and row_number() function? : Sql dba