is it mandatory to select all the column in a view then what
columns should be selected
Answer Posted / sundeep
no.view is nothing but virtual table.a view is like a instance variable for a query.if the query length is long and it used for more than twice then we go for views. In these views we will select the columns which are to be used in a table.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a dirty read sql?
Where is pl sql used?
What is the cause of mutating table error and how can we solve it?
Does sql full backup truncate logs?
how to enter characters as hex numbers? : Sql dba
What is pessimistic concurrency control? : Transact sql
Explain the steps needed to create the scheduled job?
What is join view in sql?
What is sql comments?
What does a pl/sql package consist of?
Which join is like an inner join?
How do you use join?
Is postgresql a server?
What is trigger types in sql?
How can a function retun more than one value in oracle with proper example?