Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Why function is used in sql?

0 Answers  

difference between SQL and C

1 Answers   Indus Software Technologies,

What is the trigger in sql?

0 Answers  

How many types of cursors are available in pl/sql?

0 Answers  

How to perform a loop through all tables in pl/sql?

4 Answers   Evosys, MBT,

Is a view faster than a stored procedure?

0 Answers  

What is field delimiter?

0 Answers  

what is explain plan?, given an example...

3 Answers   Polaris,

What are the advantages of the packages

6 Answers   Oracle,

How to use distinct and count in sql query? Explain

0 Answers  

Why cross join is used?

0 Answers  

What is the size of partition table?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories