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

The in operator may be used if you know the exact value you want to return for at least one of the columns.

558


what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

617


How do I find duplicates in two columns?

552


How is indexing done in search engines?

531


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

534






How many sql core licenses do I need?

509


what is a trigger? : Sql dba

577


What is gpt format?

507


Can we use view in stored procedure?

510


What is trigger point?

538


Explain scalar functions in sql?

585


What is the use of count (*) in sql?

549


Is natural join same as inner join?

507


What are the query optimization techniques?

535


What is forward declaration in pl sql?

590