when a procedure /package is getting invalidated?
Answer Posted / rajesh
while the user don't have the sufficient privilege to
execute the procedure/package.or else while the owner of
the procedure/package alters the name of the
procedure/package it becomes invalidated....
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
What is the command used to fetch first 5 characters of the string?
What is java sql package?
how to add a new column to an existing table in mysql? : Sql dba
Differentiate between sga and pga.
what is datawarehouse? : Sql dba
differentiate between float and double. : Sql dba
How can a function retun more than one value in oracle with proper example?
Why do you partition data?
How do I run sql?
What is normalization in a database?
What is sql*plus?
What is memory optimized?
What is posting?
What are all the different normalization?