what are views?

Answer Posted / harsha vardhan reddy

1.It is a LOGICAL and VIRTUAL object.

2.It is stored select statement.

3.It allows DESCRIBE,DML,SELECT on it.

4.It will not hold data in it.

5.It supports to share "selected rows and columns with
other user"

6.It provides security while sharing.


regards,
harsha518@gmail.com
harsha.vardhan@cmcltd.com

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between sharding and replication?

471


How many types of segments in Oracle?

523


How to create additional tablespaces for an new database?

561


candidate key is subset of super key but not vice-verse explain

1569


What is a oracle database?

594






Explain the difference between a procedure and a function? What do you understand by those terms?

613


What is an oracle database table?

581


Can you have more than one content canvas view attached with a window ?

1811


What is oracle server autotrace in oracle?

601


What is truncate oracle?

523


What is private procedure oracle?

519


Will you be able to store pictures in the database?

629


Explain an extent?

651


What is difference between cartesian join and cross join?

576


Calculate difference between 2 date / times in oracle sql?

557