Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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

What are two parts of package ?

Question Posted / guest

Answers were Sorted based on User's Feedback



What are two parts of package ?..

Answer / tulsi

The two parts of package are PACKAGE SPECIFICATION &
PACKAGE BODY.

Package Specification contains declarations that are global
to the packages and local to the schema.
Package Body contains actual procedures and local
declaration of the procedures and cursor declarations

Is This Answer Correct ?    16 Yes 2 No

What are two parts of package ?..

Answer / senthil kumars

Package Contains Two Parts.They Are

*Package Spec
*Package Body

Package Spec contains declarations of procedures,functions
Where as Package Body Contains definitions for the
procedures and functions which r declared in the spec. Also
it contains the local variables which r to be used in the
procedure or function

Is This Answer Correct ?    11 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What port does sql server use?

0 Answers  

What is audit logout in sql profiler?

0 Answers  

How to come back in normal stage in Mutating Table if mutating table is locked or update data?

2 Answers  

How many commands are there in sql?

0 Answers  

How to test for null values?

0 Answers  




How do you take the union of two tables in sql?

0 Answers  

what is 'mysqlimport'? : Sql dba

0 Answers  

Explain dml and ddl?

0 Answers  

How to convert lowercase letters to uppercase and uppercase letters to lowercase in a string. (ex, AbcdEfG should convert as aBCDeFg)

3 Answers   TCS,

what is oracle database ? : Sql dba

0 Answers  

Can dml statements be used in pl/sql?

0 Answers  

What is ROWID?

8 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories