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

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

5 Answers   Deloitte, Ness Technologies,

what is julian date in oracle

2 Answers  

Is sql a backend?

0 Answers  

How to assign sql query results to pl sql variables?

0 Answers  

What is trigger in sql?

0 Answers  




what is the sql query to display current date? : Sql dba

1 Answers  

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

What is the cause of mutating table error and how can we solve it?

0 Answers  

What are the various levels of constraints?

0 Answers  

How do you declare a user-defined exception?

0 Answers  

Does a join table need a primary key?

0 Answers  

What is the use of procedures?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories