What is the fastest way of accessing a row in a table?
Answer Posted / vidit tyagi
The fastest way to acces row is by rowid.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What are basic techniques of indexing?
How to process query result in pl/sql?
what are date and time intervals? : Sql dba
What is sql profiler in oracle?
How do I start sql profiler?
What is difference between hql and sql?
What does cursor do in sql?
Can we use pl sql in mysql?
How do you use a while loop in pl sql?
What is cascade in sql?
Why do we use procedures?
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
explain the delete statements in sql
What is rollback?
How do I order columns in sql?