Answer Posted / guest
Yes a view can be created based on another view. Like this
views can be created upto 32 levels.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What are the oracle built-in data types?
Explain the use of online redo log files in oracle.
Explain oracle left join with an example?
When system tablespace is created?
How can we delete duplicate rows in a table?
How to create a single index for multiple columns?
what is meant by magic query
How to get the Installed Oracle Version Information ?
Explain compound trigger in oracle?
Explain about achiever in sql?
What happens if the update subquery returns multiple rows?
What is a subquery?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is a package ? What are the advantages of package ?