Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages of Views ?
- 3 Answers
- 10298 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 |
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
How to create id with auto_increment on oracle?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
What is DTS and purpose of DTS ?
waht is referencial integrity?
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
What is the quickest way to fetch the data from a table?
how to tune oracle sql queries pls tell me step by step. urgent pls
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
Can group functions be mixed with non-group selection fields?
what is primary key?
Oracle General 
