Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

in a package one procedure is wrong package shows valid or not

Question Posted / arpitha2206

Answers were Sorted based on User's Feedback



in a package one procedure is wrong package shows valid or not..

Answer / rupa

Invalid

Is This Answer Correct ?    3 Yes 0 No

in a package one procedure is wrong package shows valid or not..

Answer / noorulahaq

as the package have 2 parts decl & body, decl part is valid
where as body wll be invalid. It means overall answer is
Invalid.

Is This Answer Correct ?    4 Yes 1 No

in a package one procedure is wrong package shows valid or not..

Answer / sridevi.o

its invalid

Is This Answer Correct ?    3 Yes 0 No

in a package one procedure is wrong package shows valid or not..

Answer / kolipaka

It shows valid, because the entire package will be executed
and it is valid. inside the procedure will show error when
the package reffers to that procedure. like EXEC
PKG_NAME.PROC_NAME.

Is This Answer Correct ?    2 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What is a call statement? Explain with an example.

0 Answers  

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

0 Answers  

What are the disadvantages of file system?

0 Answers  

How do you explain an index number?

0 Answers  

What is indexing oracle sql?

0 Answers  




how to fetch alternate records from a table? : Sql dba

0 Answers  

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

How will you a activate/deactivate integrity constraints?

2 Answers  

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 Answers   Oracle, Wipro,

Does sql full backup truncate logs?

0 Answers  

need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  

What is varchar data type in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories