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
- 6064 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 |
How to convert comma separated string to array in pl/sql?
what is an alias command? : Sql dba
What is sql entity?
what are the differences between char and nchar? : Sql dba
What type of join is sql join?
what is a foreign key ? : Sql dba
What are pl/sql exceptions? Tell me any three.
What is native sql query?
what are date and time data types in mysql? : Sql dba
Explain the uses of control file.
What is rowid in sql?
What is join view in sql?
-
Oracle (3259) - 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)
