Answer Posted / mahesh kumar
we can never create index on view, becasue view doesn't
have physical memory. If we try to create index on view in
oracle, produce error: a view is not appropriate here
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What language does oracle use?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How a tablespace is related to data files?
How to retrieve data from an cursor to a record?
What is connection pool in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is the exact use of Collections?
Is it possible to insert comments into sql statements return in the data model editor ?
Explain the use of constraints option in exp command.
How to test null values?
State some uses of redo log files?
Explain oracle data types with examples?
When do we use group by clause in a sql query?
How to rename an index in oracle?
What is recycle bin in Oracle?