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

Explain what is sql?

0 Answers  

Do we need commit after truncate?

0 Answers  

Show how functions and procedures are called in a pl/sql block.

0 Answers  

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

What's the difference between a primary key and a clustered index?

0 Answers  




How packaged procedures and functions are called from the following?

2 Answers  

How would you reference column values before and after you have inserted and deleted triggers?

0 Answers  

What are the steps for performance tuning.

0 Answers  

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

What is the difference between nvl function, ifnull function, and isnull function?

0 Answers  

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

When is a declare statement required?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories