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 are the differences between require and include, include_once and require_once? : Sql dba
what is clause? : Sql dba
What is the difference between local variables and global variables?
What is write ahead logging in sql server?
What is trigger in sql and its types?
what is heap table? : Sql dba
what is the difference between sql and t-sql? : Transact sql
What are basic techniques of indexing?
does sql support programming? : Sql dba
how to drop an existing view in mysql? : Sql dba
What is a dirty read sql?
What are the constraints available in sql?
What are pl/sql cursors?
How do I remove sql plus from windows 10?
What is mutating table error?