Are sql views compiled?



Are sql views compiled?..

Answer / kiran r

NO SQL VIEWS ARE NOT GONNA COMPILED AS APROCEDURE

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Can procedure in a package be overloaded?

1 Answers   HCL,


I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,


define sql update statement ? : Sql dba

0 Answers  


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  


What is lexical units in pl sql?

0 Answers  






Is subquery faster than join?

0 Answers  


Is it possible to include an insert statement on the same table to which the trigger is assigned?

0 Answers  


Explain the two type of Cursors ?

8 Answers   Hi Caliber IT,


wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,


write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,


Name the operator which is used in the query for pattern matching?

0 Answers  


What is relationship? How many types of relationship are there?

0 Answers  


Categories