Can we create index on views?

Answer Posted / tanuj

NO in ORACLE, but YES in SQL. :-)

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a procedure inside another procedure?

751


How do you find current date and time in oracle?

784


What is merge in oracle?

791


What is a named program unit?

785


How to turn on or off recycle bin for the instance?

825


How do I manually uninstall oracle client?

760


State and explain the different types of data models?

715


Can a parameter be passed to a cursor?

802


6. Display the client name and order date for all orders using the traditional method.

2003


What do you mean by group by clause?

774


What is ceil and floor in oracle?

800


Explain oracle instance.

889


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

814


How to shutdown your 10g xe server from command line?

766


Which are the five query types available in oracle?

725