Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

is it mandatory to select all the column in a view then what
columns should be selected

Question Posted / arpitha2206

Answers were Sorted based on User's Feedback



is it mandatory to select all the column in a view then what columns should be selected..

Answer / guest

No, Its not mandatory.

Is This Answer Correct ?    3 Yes 0 No

is it mandatory to select all the column in a view then what columns should be selected..

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

Post New Answer

More SQL PLSQL Interview Questions

Does group by remove duplicates?

0 Answers  

What are dml commands?

0 Answers  

How do I count rows in sql query?

0 Answers  

How you improve the performance of sql*loader? : aql loader

0 Answers  

How to make a copy values from one column to another in sql?

0 Answers  




Is left join faster than inner join?

0 Answers  

Can we use having without group by in sql?

0 Answers  

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

What is field delimiter?

0 Answers  

Can we use ddl statements in stored procedure sql server?

0 Answers  

What are primary key and foreign key and how they work?

0 Answers  

What is difference between mysql and postgresql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories