Interested to Buy Any Domain ? << Click Here >> for more details...
what is a view?
- 7 Answers
- 9956 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 |
How to test null values?
Is there a function to split a string in plsql?
defination of bitmap index
State any two functions of oracle?
What is difference between cartesian join and cross join?
what are pseudocolumns?
Can a primary key contain more than one columns?
Explain temporal data types in oracle
Can you drop an index associated with a unique or primary key constraint?
How to define a procedure inside another procedure?
what is reindexing?
How to find the duplicate rows count from employees table in oracle?
Oracle General 
