Answer / rad

view is a stored query and does not store any table data.

Answer / s. senthil kumar

A view is a virtual table. Every view has a Query attached
to it. (The Query is a SELECT statement that identifies the
columns and rows of the table(s) the view uses.)

Answer / senthil kumar

View is the virtual table. It is DML statement.

Answer / roopesh kumar

A view is a logical db object which is created for data
security, data hiding etc. In database onle views
defination stored.

Syntax: create or replace view name_vw as select col1,
col2, ......... from table1, table2 where ....;

Types: (1) simple view
(2) complex view
(3) read only view
(4) force view
(5) with check option

Answer / guest

View is used to viewing the data and not for manipulating
it.

Answer / manjunath k

a view consists of a stored query accessible as a virtual
table composed of the result set of a query.

Answer / sunil maurya

A view is simply the representation of a SQL statement that
is stored in memory so that it can easily be re-used. For
example, if we frequently issue the following query

SELECT empid FROM emp;

I might well want to make this a view (the reality is that
we would probably never create a view for a statement this
simple but we wanted to use an easy example).

To create a view use the create view command as seen in this
example
CREATE VIEW view_emp
AS
SELECT empid FROM emp;

how to get second highest sal of emp table

6 Answers  

What is a parameter file in oracle?

0 Answers  

What is set operator oracle?

0 Answers  

What is schema?

41 Answers   Bodhi Global Services, Cognizant, HCL,

what is query and types of query

6 Answers   Reliance,

Is it possible to disable the parameter from while running the report ?

1 Answers   Honeywell, Oracle,

What is an Index ?

2 Answers  

after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble

1 Answers  

How to call a stored procedure inside a trigger? Give an example.

1 Answers   Exilant,

How to assign a table row to a record variable?

0 Answers  

If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?

1 Answers  

how to make an oracle object

0 Answers