Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / itishree chhotray
View should be Schema binding,before creating index on view.
We can create Unique Clustered index on view after that we
can create non clustered index but we should have at least
one unique clustered index on view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
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.
How to delete all rows a table in oracle?
What is a subquery?
What is a tns service name?
How to do clean up if create database failed?
Which environment variables are absolutely critical in order to run the OUI?
What is Undo Management Advisor in Oracle?
ABOUT IDENTITY?
various types of hints and their usage
What are the uses of a database trigger?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Hi Can any one tell me what are the API's used in requisition import.
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 ?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
what is dynamic SGA and static SGA
