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
- 6171 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 sql procedures and functions?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is clause in sql?
How do I audit the sql sent to the server?
what are sequences
Which one is better sql or oracle?
Why do we need cursors in pl sql?
What is string data type in sql?
What happens when a trigger is associated to a view?
How do I find sql profiler?
How do I find duplicates in a single column in sql?
how to get a list of indexes of an existing table? : Sql dba
Explain the difference between sql and mysql.
What is error ora-01000: maximum open cursors exceeded
What is crud stand for?
