How are the index updates?
Answer / nishi
Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain an extent?
How to define a data field as not null?
How to retrieve data from an cursor to a record?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What would you use to improve performance on an insert statement that places millions of rows into that table?
Can we create more than one constraint to column ?
What is an oracle function?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
What is an Oracle Instance?
how to retrieve 1st and last row of table without using group functions??
What is a Data File ?
What is a dead lock in oracle?