What are the blocks in stored procedure?
Answer Posted / eshwer
Declaration block
Execution block
Exception block
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is sql between inclusive?
What is a natural join sql?
What are the popular database management systems in the it industry?
Can I join the same table twice?
How do you optimize a stored procedure query?
Can we rename a column in the output of sql query?
What are predefined functions in sql?
How to get help at the sql prompt?
What is secondary key?
Why having clause is used in sql?
What is primary key and unique key?
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 does count (*) do in sql?
What is cold data?
What is indexing oracle sql?