What is the fastest way of accessing a row in a table?
- 5 Answers
- 18466 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / bhisma
The Fastest way to access a row is to use primary key of
the table.
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
Which one is better sql or oracle?
Explain scalar functions in sql?
What is the difference between subquery and correlated query?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Which join is like an inner join?
What is the purpose of normalization?
What does plv msg allows you to do?
what is error ora-03113: end-of-file on communication channel?
Can we use loop in sql?
How many joins can you have in sql?
What is offset and limit in sql?
What is pl/sql language case sensitive?
What is an exception in pl/sql?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What are the types pl/sql code blocks?
