Can we create index on views?

Answer Posted / mkjmkumar

We can Define a Synonym on View.

Is This Answer Correct ?    86 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the numeric comparison operations?

626


How do you tell what your machine name is and what is its IP address?

1506


What is dual table oracle?

517


How to loop through data rows in the implicit cursor?

537


What is partitioned table in Oracle?

624






Can we call procedure inside function in oracle?

598


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

598


Can I create users through internet explorer in oracle 10g?

561


What is max rowid in oracle?

551


How a tablespace is related to data files?

574


Can a formula column referred to columns in higher group ?

2081


What happens if recursive calls get out of control?

539


Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

924


What is meant by joins?

611


How to upsert (update or insert into a table)?

529