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 would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1444


How do we get field details of a table?

549


What is the difference between count (*), count (expression), count (distinct expression)?

561


What is tns name?

547


What is a nested table?

633






What is recycle bin in Oracle?

722


What are the set operators union, union all, minus & intersect meant to do?

567


How to use values from other tables in update statements using oracle?

569


What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

527


Why should I use oracle database?

576


Give syntax for SQL and ORACLE joins.

636


How do we display rows from the table without duplicates?

550


What is an oracle table?

558


How to assign data of the deleted row to variables?

582


How to view all columns in an existing table?

552