Answer Posted / hafiz
Yes we can create index on a view becuase the view may be
creates on subquery also and then the retrival of records
may be complex and therefore there must be an index on that
perticular column.
| Is This Answer Correct ? | 16 Yes | 17 No |
Post New Answer View All Answers
How do I call oracle stored procedures that take no parameters?
How to export data with a field delimiter?
What are the advantages of oracle 12c?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to delete a column in an existing table?
How to add another datafile to a tablespace?
How to get the Installed Oracle Version Information ?
What is a subquery?
What is oracle update statement with inner join ?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is the use of aggregate functions in oracle?
What happens to the current transaction if a ddl statement is executed?
What is concurrency in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the uses of Database Trigger ?
