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
Explian rowid, rownum?
What is online transaction processing (oltp)?
What is primary key and foreign key with example?
What is the difference between joins?
What are the different types of a subquery?
Is sql considered coding?
Why do we need sharding?
Explain the significance of the & and && operators in pl sql.
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
What's the difference between a primary key and a clustered index?
What is a sql driver?
Difference between table function and pipelined function?
What is oracle pl sql developer?
What is a record in pl/sql?
Can you call pl/sql package functions from within a fast formula?