Interested to Buy Any Domain ? << Click Here >> for more details...
is it mandatory to select all the column in a view then what
columns should be selected
- 2 Answers
- 6100 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 a record in pl/sql?
How do you write an index?
what is a view? : Sql dba
State few characteristics of pl/sql?
Explain the insert into statements in sql?
what is sp_pkeys? : Transact sql
What does closing a cursor do?
How do you declare a constant?
Why are cursors used?
Are null values same as that of zero or a blank space?
what are different types of keys in sql?
What will you get by the cursor attribute sql%rowcount?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
Enlist the data types that can be used in pl/sql?
What is pl sql and why it is used for?
