no.view is nothing but virtual table.a view is like a instance variable for

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

Question Posted / sundeep

2 Answers
6092 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

Please Help Members By Posting Answers For Below Questions

What is a native sql query?

1066

What is java sql driver?

1112

What does joining a thread mean?

1019

How do I use google cloud in sql?

1084

What is a null value?

1136

Explain what is sql*plus?

1138

What is substitution variable?

1048

What does select top 1 do in sql?

1088

What are inner outer left and right joins in sql?

1011

What is difference sql and mysql?

979

Is pl sql still used?

973

Sql technical questions

1273

What is memory optimized table?

1039

What is an intersect?

1100

How many types of sql are there?

986