Interested to Buy Any Domain ? << Click Here >> for more details...
what is a view?
- 7 Answers
- 9742 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 |
find out the second highest salary?
55 Answers Cognizant, Nucsoft, Oracle, TCS, Wondersoft,
what are the differen between key flexifild and discriptive fiexifild.
sql query to get zero records from a table
what is normalisation?what are its uses?
Where are the settings stored for each instance in oracle?
What are the varoius components of physical database structure of oracle database?
How to compare dates in oracle sql?
How to login to the server without an instance?
Hi Can any one tell me what are the API's used in requisition import.
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Explain table?
What is save point in oracle database?
Oracle General 
