is it mandatory to select all the column in a view then what
columns should be selected
- 2 Answers
- 5587 Views
- I also Faced
- E-Mail Answers
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 the best sql course?
What is the difference between nvl function, ifnull function, and isnull function?
How do I pipe the output of one isql to another?
how many ways we can we find the current date using mysql? : Sql dba
what are all the different normalizations? : Sql dba
Is sql procedural language?
What is a field in a database?
How you improve the performance of sql*loader? : aql loader
Explain the select statement in sql?
Which constraints we can use while creating database in sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is a recursive stored procedure?
What are instead of triggers?
Explain the difference between triggers and constraints?
Does a join table need a primary key?
