Are sql views compiled?
Answer / kiran r
NO SQL VIEWS ARE NOT GONNA COMPILED AS APROCEDURE
Is This Answer Correct ? | 0 Yes | 0 No |
Can procedure in a package be overloaded?
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.
define sql update statement ? : Sql dba
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is lexical units in pl sql?
Is subquery faster than join?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Explain the two type of Cursors ?
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.
Name the operator which is used in the query for pattern matching?
What is relationship? How many types of relationship are there?