Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to define a variable of a specific record type?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is a dead lock in oracle?
State the various uses of dbcc command?
What is the usage of save points in oracle database?
What is oracle host variable?
How to list all user accounts in oracle?
Explain cascading triggers.
Explain the difference between sap and oracle?
What is the quickest way to export a table to a flat file?
How to convert character types to numeric types?
Can we convert a date to char in oracle and if so, what would be the syntax?
Give syntax for SQL and ORACLE joins.
How to write a left outer join with the where clause in oracle?
