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 Histogram?

0 Answers   NIIT,

What are the three forms of normalization?

0 Answers  

What is the use of <> sql?

0 Answers  

what is the forward decleration in packages?

1 Answers  

How do I find duplicates in a single column in sql?

0 Answers  




When sql appeared?

0 Answers  

Is and as keyword in pl sql?

0 Answers  

Can there be 2 primary keys in a table?

0 Answers  

What is autocommit sql?

0 Answers  

Can you sum a count in sql?

0 Answers  

What is the difference between truncate and drop statements?

0 Answers  

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

For more SQL PLSQL Interview Questions Click Here
Categories