Answer / sreekanth

No, View is a logical table associated with a query.
It will not store any data in it.
Only the query with which the view is created is stored in
the database.

Answer / sekhar

Absolutely, the view contain no data. The basic property of
a view is to extract a set of data columns to display from a
large number. And this is useful in future by jst stating
the view name instead writing the select statement every time.

Answer / gvmahesh

NO,the view is a logical table based on one or more tables
or views.A view in practicality contains no data by
itself.it contains only select statements.

Answer / shail

Hold on!!!!

All the above answers are absolutely true but remember the
fact that if you delete or update any view data then it
will be reflected in the base table.

Answer / ram

hold on..
all above are correct
incase of simple view dml operations are allowed
(simple view mean view creates based on one table)

incase of complex view dml operrations not allowd
(complex view create based on more than 1 table)

one more thing is in oracle
materialized view maintain physical copy of data
(dml operations on base tables not reflect on materialized view)

Answer / suresh

View is a stored select statement,it does not contain any data,and it is a logical table just for the viewing purpose

table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  

What is dialect in sql?

0 Answers  

what is sql and plsql

6 Answers  

How do I run a script in sql developer?

0 Answers  

Are stored procedures faster than queries?

0 Answers  

How do I start sql profiler?

0 Answers  

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers  

Is foreign key mandatory?

0 Answers  

What is the purpose of my sql?

0 Answers  

What is using in sql?

0 Answers  

Which join is default?

0 Answers