Answer Posted / o.nagamani
View is a virtual storage of the original table.It is the
one kind of data hiding.
Advantages of View:
1. Restrict Data Access and/or simplify data access.
2. Simplify Data manipulation.
3. Import and Export data.
4. Merge Data.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
what is the difference between functional dependecy and multilevel dependency?
How to use "for" statements in oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
State all possible different index configurations a table can possibly have?
what is Single Byte Overhead...?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
What are the different types of partitions in oracle?
What are the ways tablespaces can be managed and how do they differ?
How to connect to oracle using service name instead of sid?
How to check database size in Oracle?
query optmization techniques and quwry analyser+projects+ppts
How to call a sub procedure?
How to rebuild an index in oracle?
defination of bitmap index
Explain the features of oracle?