Interested to Buy Any Domain ? << Click Here >> for more details...
Define 'view' advantage ?
- 2 Answers
- 11501 Views
- AZTEC, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / deva
view is the window for the data stored in the table(s). It
is the pointer to the data, will not store any data with in it.
more secure to the unauthorized data.
Time complexity reduces when we are accessing the data.
| Is This Answer Correct ? | 4 Yes | 1 No |
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
what is port in oracle? how is it related to database application.
what are the diffeenes between oracle 9i,oracle 10g
What is a connect identifier?
How to download oracle database 10g xe?
How to initialize variables with default values?
How do I call oracle stored procedures that take no parameters?
What is set operator oracle?
What is memory advisor in Oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Explain the family trees and connection by clause
What is Oracle table?
Oracle General 
