what is a view?
- 7 Answers
- 8808 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rad
view is a stored query and does not store any table data.
| Is This Answer Correct ? | 2 Yes | 0 No |
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.)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / senthil kumar
View is the virtual table. It is DML statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
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
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
View is used to viewing the data and not for manipulating
it.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manjunath k
a view consists of a stored query accessible as a virtual
table composed of the result set of a query.
| Is This Answer Correct ? | 0 Yes | 0 No |
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;
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain the different normalization forms?
What is a Segment ?
What are the advantages of oracle?
What is Redo Log Buffer in Oracle?
What are temporal data types in oracle?
Why do we need oracle client?
What is ADDM Advisor in Oracle?
9. Display the client name and order date for all orders using the JOIN . . . USING method.
What is dynamic proxy?
Can we call procedure inside function in oracle?
What is a sub query? What are its various types?
what is difference between cartesian join & cross join even they give same result?
Oracle General 
