Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.
- 10 Answers
- 54761 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / deepak
Note:- procedure may or may not return value.function must
return value
Procedure return one or more value & function return only
single value.
Pakages are groups of functions,procedures,sql blocks
goruped together in a single unit.
Package & packagebody are two different thngs. Variable
defined in packages are global & they can use in anywhere
in packagebody. Variable defined in packagebody have
limited scope. & they can used in defined limit only.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
key flexfield structure
i want to know about the javaBean.what is its purpose and how it can use in Forms.
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
how to replace not in with not exist?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks
QUESTION IS THAT DURING UPLOADING DATA IN PROD SERVER,OUR EQUIPMENT TAG NUMBERS ARE NOT MATCHING WITH SAP TAG NUMBERS SO DUE TO THIS WE ARE FACING PROB, BECAUSE WHENEVER ALARM IS COMING FROM SCADA DUE MISMATCH THE NOTIFICATION IS NOT CREATED IT IS GIVING ERROR. PLEASE SUGGEST THE METHOD SO THAT THE TAG NUMBERS OF BOTH (SCADA EQUIPMENT AND SAP EQUIP) SHOULD CONCIDE.OTHERWISE WE HAVE TO GO FOR LONG PROCESS EITHER BY INTERFACE TABLE OR BY EXPORTING ALL DATA AND MAKING RIGHT CHANGES.DO YOU HAVE ANY SHORTCT METHOD PL WRITE ME. THANKS
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
Why more redos are generated when the oracle database is in begin backup mode?
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
what is the link between suppliers and banks in ap module in oracle apps? And also query?
Explain prerequisites and post activities of oracle database installation
How would you determine what sessions are connected and what resources they are waiting for?
