Interested to Buy Any Domain ? << Click Here >> for more details...
what is a view?
- 7 Answers
- 9952 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 |
What is a public synonym?
what is the difference between restoring and recovering?
What is an oracle function?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
Is oracle a programming language?
What are the different approaches used by Optimizer in choosing an execution plan ?
a query to select maxmun 3 salaries of employee table
ABOUT IDENTITY?
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
What is analyze command used for?
What are main difference between Stored Procedure and Functions.
what is null value?
Oracle General 
