Explain can a view based on another view?

Answer Posted / rajmohan

Yes a view can be based on another view.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

1801


Can multiple columns be used in group by in oracle?

541


Can we create trigger on materialized view in oracle?

563


How to retrieve the count of updated rows?

571


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1358






What is the best way to do multi-row insert in oracle?

561


How to write a query with an inner join in oracle?

560


How to set a transaction to be read only in oracle?

578


What happens if you lost a data file?

578


Why packages are used in oracle?

536


What are the system predefined user roles?

585


How to convert dates to characters in oracle?

577


What do you know about normalization? Explain in detail?

495


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2042


How to convert characters to dates in oracle?

559