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

what's the difference between a primary key and a unique key? : Sql dba

0 Answers  

What are pl/sql packages?

0 Answers  

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

What does truncate mean in sql?

0 Answers  

What is the difference between clustered and non-clustered index in sql?

0 Answers  




how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,

Is truncate ddl or dml?

0 Answers  

what is global variable in package

3 Answers   Polaris,

hi sql gurus, here is my question 4 u. i wanna use triggers for sending reminder mail to all users who are registered to the site. if any one knws the code plz send me ans here : chayabs3@gmail.com thnx advance

1 Answers  

How to load data with sql*loader?

0 Answers  

describe mysql connection using mysql binary. : Sql dba

0 Answers  

Why does sql need a server?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories