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

package specification-3 procedures
package body-2 procedures will is execute

Question Posted / arpitha2206

Answers were Sorted based on User's Feedback



package specification-3 procedures package body-2 procedures will is execute..

Answer / umesh joshi

Package specification can be compiled without compiling
package body, whereas package body cannot be compile
without specification compilation

Is This Answer Correct ?    21 Yes 0 No

package specification-3 procedures package body-2 procedures will is execute..

Answer / ajexpert

No.
Package body should contain the same number and type of
objects as declared in package specification

Is This Answer Correct ?    11 Yes 11 No

Post New Answer

More SQL PLSQL Interview Questions

Do prepared statements prevent sql injection?

0 Answers  

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

Can you call pl/sql package functions from within a fast formula?

0 Answers  

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers   CTS,

What is database migration?

0 Answers  




What is lookup table in sql?

0 Answers  

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

What is the maximum number of rows in sql table?

0 Answers  

What is extent clause in table space?

1 Answers   TCS,

1. how to use the check option constraints in sql query..? 2.how to add data in a complex query ? 3.is it possible to use commit or rollback or savepoint in triggers...if not why please explain with examples...? 4.what is the difference between meterialized view and normal view..how to create materialized view and how to use it..? 5.what is varray...? what is the advantage of the varray ? please expalin with a simpel example..i want to load into a table (student no and name and his marks..) please give example.. 6.what are the bulk bind exceptions...how to use bulk bind and how to use bulk collect..please explain with example... 7.what is for update of and where current of ...? 8 what is the use of nowait ? 9.please give an example for nocopy in a simple plsql query 10.create an index in a table...tellme how to use the index in a where clause to do performance tunning...

3 Answers   Satyam,

What is the usage of distinct keyword?

0 Answers  

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

For more SQL PLSQL Interview Questions Click Here
Categories