Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of Views ?
- 3 Answers
- 10155 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 |
What is oracle join syntax?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
Explain coalesce function?
What is a snapshot log?
i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.
What is oracle analytical function?
What happens to the current transaction if a ddl statement is executed?
How do we switch from init.ora file to asp file?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What are the execution control statements in oracle?
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
Oracle General 
