Can you state two factual statements about SQL packages that are - ProProfs Discuss
Advertisement

Can you state two factual statements about SQL packages that are true?

Asked by Alice, Last updated: Apr 06, 2024

+ Answer
Request
Question menu
Vote up Vote down

1 Answer

John Smith

John Smith

John Smith
John Smith

Answered Sep 09, 2016

The contents of packages can be shared by many applications.-2. you can achieve information hiding by making package constructs private.-explanation actually theses are some of the advantages of the package, sharing the package among applications and hide the logic of the procedures and function that are inside the package by declaring them in the package header and write the code of these procedures and functions inside the package body. incorrect answers: a: packages can not be nested b: parameters cant be passed to a package; parameters can be passed to procedures and functions only. c: by the first time you call a procedure, function, or reference a global variable within the package, the whole package will be loaded into the memory and stay there, so when ever you need to reference any of the packages constructs again you will find it in the memory.
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.