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
- 6177 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What is database white box testing and black box testing?
What is procedure in pl sql?
how many triggers are allowed in mysql table? : Sql dba
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
How can I make sql query run faster?
How do I make my sql query run faster?
what are the different functions in sorting an array? : Sql dba
what is the difference between delete and truncate commands? : Sql dba
What is a nested table in word?
What is the difference between rename and alias?
How to come back in normal stage in Mutating Table if mutating table is locked or update data?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
