Answer Posted / subhajit guha
View in sql called the virtual table.Physically it has no
existance, so that it don't occupy the space.It retrives
the data from original table at runtime.
Views are stored in ORACLE system catalog.
Basically, in realtime environment views are used to
protect the main table for operation.Besides for security
purpose view must be used.i.e. one user can hide the main
tale from other user for creating view.
On basic of creation of view, it is divied into two pars....
1. Simple view: In that case columns for same table(single
table) are fetched for creating a view.
Syntax: SQL>create view <view_name> as select <column
name1.column name2....> from table where <condition>;
2. Complex view: Columns are fetched from different tables
on basis of operation would perform.Generally for join
operation it is used.
Syntax: SQL>create view <view_name> as select <col1..coln
from table 1>,<col 1..col n for table 2>....< .. for table
n> from table 1,..,table n where <condition>;
On basis of operations on view ... it is divided inti two
parts:
1. Read only view, 2. Updatable view
** incase of updatable view insertion,deletion and updation
can be done...... aggregation,rowid,rownum and any group
function cann't be performed.
** incase of read only view, only view canbe read, no DML
operations cann't be perfomed.
to drop a view ..... we use:
SQL>drop view <view_name>;
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain how are indexes update?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Which is faster join or subquery in oracle?
What is a procedure in oracle?
Why do you use stored procedures and state some of its disadvantages?
What do you mean by cdb and pdb in oracle 12c?
How to do clean up if create database failed?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to estimate disk space needed for an export job?
What happens if recursive calls get out of control?
What is Undo Management Advisor in Oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to call a stored function in oracle?
How to compare dates in oracle sql?
Can multiple cursors being opened at the same time?