what is the difference between table and veiw?

Answer Posted / prasanna

Table will display the all columns,The table will be stored
in database. where as View is a virtual table that will not
stored in the database.The columns will be hiden while
giving the report to the users.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to estimate disk space needed for an export job?

558


What are privileges and grants?

568


How to add a new column to an existing table in oracle?

584


How to use fetch statement in a loop?

549


What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

608






What are named parameters?

608


How to synchronize 2 schema's objects?

1686


How to commit the current transaction in oracle?

576


How to get execution statistics reports on query statements?

567


How to connect asp pages to oracle servers?

571


What is the relation of a user account and a schema in oracle?

583


Where is the export dump file located?

567


How to rollback the current transaction in oracle?

538


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1782


Which dictionary tables and/or views would you look at to diagnose a locking issue?

1484