Answer Posted / 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 |
Post New Answer View All Answers
How to create an oracle database?
How to display row numbers with the records?
What is PL/SQL ?
What are the restrictions on external table columns?
How to export your connection information to a file?
How many memory layers are in the oracle shared pool?
What is the data type of dual table?
What do you know about normalization? Explain in detail?
What are the set operators union, union all, minus & intersect meant to do?
Give the various exception types.
 How to use an oracle sequence generator in a mapping?
How do I start tns listener?
What is the fastest query method to fetch data from the table?
What to do if the binary spfile is wrong for the default instance?
How do I reset a sequence in oracle?
