What are the advantages of VIEW?

Answer Posted / 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.

Is This Answer Correct ?    38 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between row level and statement level trigger?

722


How do you rank data in sql?

680


Can there be more than one function with a similar name in a pl/sql block?

746


What is a database trigger?

790


which types of join is used in sql widely? : Sql dba

713






What is sorting in sql?

673


What are triggers and its uses?

786


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

700


How to make a copy values from one column to another in sql?

767


Why is sql important?

759


What is a full join?

706


What is 19 null in sql?

703


what is oracle database ? : Sql dba

736


What does the file extension accdb stand for?

707


What are all the different normalizations?

744