Can we create index on views?

Answer Posted / raju

yes we can... its easy to create.....

Is This Answer Correct ?    6 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the disadvantage of User defind function?

1836


Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2458


What is transaction control statement and how many types of transaction control statement in Oracle?

565


How do we represent comments in oracle?

631


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

1851






What language does oracle use?

601


What is Java Pool in Oracle?

606


What is recycle bin in Oracle?

722


What do you understand by a database object? Can you list a few of them?

612


what is difference between sql plus and sql*plus? (not sql and sql plus).

3351


What is the difference between Delete, Truncate and Drop in Oracle?

606


What is the exact use of Collections?

1682


What happens in oracle commit?

572


How can I introduce multiple conditions in like operator?

558


What is enter substitution variable in oracle?

574