is it mandatory to select all the column in a view then what
columns should be selected
- 2 Answers
- 5403 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
How to avoid duplicate records in a query?
Which is faster truncate or drop?
What are sql ddl commands?
Which are sql * plus commands?
What is sql server and ase?
What is rowid in sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
How to change the order of columns in Oracle SQL Plus ?
Are stored procedures compiled?
Why we use cross join?
What is a delimiter in sas?
Can we use joins in subquery?
What is sql trigger example?
Define the select into statement.
How many times can we commit in a loop?
