If a procedure within a package is invalidated whether the
entire package will be invalid and has to be recompiled
again?
- 2 Answers
- 8226 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
Yes, the total package body will become invalid and has to
be recompiled again
| Is This Answer Correct ? | 24 Yes | 2 No |
Post New Answer View All Answers
What is procedure in pl sql?
Is pl sql a scripting language?
how can we find the number of rows in a table using mysql? : Sql dba
Can %notfound return null after a fetch?
Why partition by is used in sql?
Can we create view in stored procedure?
How many clustered indexes can you have?
Why commit is not used in triggers?
What is difference between group by and partition by?
What is dml and ddl?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Why are cursors used?
What is query syntax?
Can we use views in stored procedure?
What is optimistic concurrency control? : Transact sql
