What are the advantages of VIEW?

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

Is This Answer Correct ?    17 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sqlerrd?

699


What is aggregate function in sql?

736


What is online transaction processing (oltp)?

749


What is faster join or subquery?

711


What is 19 null in sql?

703






What is vector point function?

770


Does user triggers have entry for trigger with compilation errors?

792


what is the difference between truncate and delete statement? : Transact sql

777


Can we create a trigger on view?

668


What does data normalization mean?

718


Explain alias in sql?

769


How do I remove sql plus from windows 10?

765


Can we call stored procedure in function?

706


What is the command used to fetch first 5 characters of the string?

1096


What is a recursive join sql?

806