Talk about views

Answer Posted / sunitha

View is a logical representation of subset of data.
there are simple,complex and materialized views.
View does't take any space in database.
view are used for security purpose.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explian rowid, rownum?

539


What is online transaction processing (oltp)?

587


What is primary key and foreign key with example?

475


What is the difference between joins?

508


What are the different types of a subquery?

499






Is sql considered coding?

538


Why do we need sharding?

495


Explain the significance of the & and && operators in pl sql.

548


Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

1696


What's the difference between a primary key and a clustered index?

490


What is a sql driver?

505


Difference between table function and pipelined function?

562


What is oracle pl sql developer?

504


What is a record in pl/sql?

515


Can you call pl/sql package functions from within a fast formula?

542