adspace


How view is different from a table?

Answer Posted / Avdhesh P.singh

A table stores data in rows and columns, while a view is a virtual table that does not physically store any data. Instead, it represents a select statement that is executed each time the view is referenced. A view can be used to simplify complex queries, provide security by limiting access to certain data, or combine data from multiple tables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle latest version?

1174


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956


How to put more than 1000 values into an oracle in clause?

1115


Design database draw er diagram for a certain scenario ?

4656


How to use values from other tables in update statements using oracle?

1158


How to write a left outer join with the where clause in oracle?

1155


How to start an oracle instance?

1103


How to select all columns of all rows from a table in oracle?

1132