Interested to Buy Any Domain ? << Click Here >> for more details...
Can a View based on another View ?
- 3 Answers
- 11905 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / revathi
Yes, it is possible.
Ex:
create or replace view my_view_3 as
select mv1.id, mv1.name, mv1.address
from my_view_1 mv1.
mv1 IS A ANOTHER VIEW
| Is This Answer Correct ? | 3 Yes | 0 No |
When do we use group by clause in a sql query?
How to test null values?
How would you optimize a slow SQL query?
What is BBED in Oracle?
How to start a new transaction in oracle?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
Explain a segment?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Whether any commands are used for months calculation? If so, what are they?
Oracle General 
