What are the advantages of VIEW?

Answer Posted / karunakarreddy.boyapally

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

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

1620


What is scalar and vector?

507


How does stored procedure reduce network traffic?

518


What is type and rowtype in pl sql?

514


Are stored procedures compiled?

507






how to include comments in sql statements? : Sql dba

521


Which operator is used in query for pattern matching?

599


What is foreign key sql?

526


what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

523


Can a view be mutating? If yes, then how?

553


How do I view tables in sql developer?

492


What are all the different normalization?

535


What is bitemporal narrowing?

675


How is pl sql different from sql?

511


How do you write an inner join query?

490