Answer Posted / avi007
order of preddfined exceptions is to first catch the
exception in begin end; block
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of primary key?
Can cursors be part of a trigger body?
Is sqlite good enough for production?
What is sql character function?
What is trigger in sql? Explain
How subquery works in sql?
What will you get by the cursor attribute sql%notfound?
Can we use ddl statements in stored procedure?
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
Can we use joins in subquery?
What are string functions in sql?
How to convert comma separated string to array in pl/sql?
What is the default isolation level in sql server? : Transact sql
What is a variable in sql?
Which is better join or subquery?