Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of Views ?
- 3 Answers
- 10211 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The advantages of views are
1)Data abstraction
2)Simple retrieving of data.
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / nishi
- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ven
secutiry of the data for ex: in bank domain some of the
columns data don't want to see others then we can restrict
the columns and create views and share the columns
whichever others can see.
| Is This Answer Correct ? | 2 Yes | 3 No |
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
 What are the oracle DML commands possible through an update strategy?
What are the parameters that we can pass through a stored procedure?
what is the difference between table and veiw?
Explain how you would restore a database using RMAN to Point in Time?
Is oracle an open source?
Explain database link?
What is ceil and floor in oracle?
select trunc(round(156.00,-1),-1) from dual;
does the query needs a hint to access a materialized view?
How to resolve the ORA-39133 error in Oracle?
Describe Referential Integrity ?
Oracle General 
