Answer / vinay dixit

please find the advantages as given below :-

a) data security - no need to give permission on the table,
infact a view can be created, having only selected number
of coloums in its definition. So user will only be able to
see those coloums.

b) simplicity - a very complicated query can be saved as a
view defenition. when needed can be called by its view name.

c) removes dependency - Can be very helpful to remove the
dependecny from the underlying tables. Suppose a view is
created by joining several tables. After some time, there
are some changes on the tables, so only defenition of view
can be changed and there is no need to change all the code
where view is used.

d) No space - takes no space ( except materialized view )

Answer / anil_abbireddy

1. data security : complex view can not be modified ie.
base tables cannot be visible.
2. it provides easy way to query data from different data
sources like a single table
3.it is very usefull when developing complex reports basing
on multiple tables.

Answer / pnc

view is a logical presentation of one or more tables. It is
a virtual table. or A view is a data base object to register
the select statement permanently in the data base.

Answer / karunakarreddy.boyapally

1) it reduse the object size
2) hides the complexity of data
3) security purpose also

Answer / kapil syscom

View is simple structure as table in database, it dosen't take extra memory space, and reduces the structural complexity of database whenever we need to fetch the data from more than one table, thus it reduces the cost of joins every time.
Thus these is true that we have to use it for efficiency reasons..

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

What is procedure explain with program?

0 Answers  

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

What is database migration?

0 Answers  

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

How to run sql commands in sql*plus?

0 Answers  

What is the difference between left join and right join?

0 Answers  

Which is faster count (*) or count 1?

0 Answers  

How many triggers can be implemented for a table?

3 Answers   HSBC,

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

what are all different types of collation sensitivity? : Sql dba

0 Answers