Can we create index on views?

Answer Posted / khushin dhulla

yes

Is This Answer Correct ?    14 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

3337


How to pass a cursor variable to a procedure?

548


How to connect ms access to oracle servers?

540


How to create lov dynamically at runtime & attach to text field?

651


Explain coalesce function?

613






Explain a private synonyms?

623


What do database buffers contain?

557


Explain overloading. Can functions be overloaded?

560


List out the types of joins.

583


What is meant by joins? List out the types of joins.

514


How to use subqueries with the exists operator in oracle?

603


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

1842


How to define a specific record type?

605


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

579


How do you store pictures in a database?

548