is it mandatory to select all the column in a view then what
columns should be selected
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 difference between cursor and trigger?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is string join?
What is duration in sql profiler trace?
How do I edit a stored procedure?
How do you update sql?
What is the left table in sql?
Is left join same as join?
What are the sql commands?
How to Declare Fixed Length String Value In PL SQL
What is sql injection owasp?
What is a data manipulation language?
can sql servers linked to other servers like oracle? : Sql dba
Which data type is a composite type?
What is cursor status?