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 concatenate two text values in oracle?
How to estimate disk space needed for an export job?
What is ADDM Advisor in Oracle?
How to see free space of each tablespace?
Why does for update in oracle 8 cause an ora-01002 error?
How to connect ms access to oracle servers?
Why is oracle used?
What is format trigger?
What are the differences between lov and list item?
How many types of auditing in Oracle?
Can we create trigger on materialized view in oracle?
How to create additional tablespaces for an new database?
What is SQL Tuning Advisor in Oracle?
How to increment dates by 1 in oracle?
How can I introduce multiple conditions in like operator?
