What is difference between a formal and an actual parameter?

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > Oracle

✍: Guest

The formal parameters are the names that are declared in the parameter list of the header of a module. The actual parameters are the values or expressions placed in the parameter list of the actual call to the module.

2011-10-21, 2737👍, 0💬

Can a function take OUT parameters. If not why?
Can a function take OUT parameters. If not why? yes, IN, OUT or IN OUT. 2011-10-20, 3045👍, 0💬

Does rapid clone takes care of Updating Global oraInventory or you have to register manually in Global OraInventory after clone
Does rapid clone takes care of Updating Global oraInventory or you have to register manually in Global OraInventory after clone ? Rapid Clone will automatically Update Global oraInventory during configuration phase. You don't have to do any thing manually for Global oraInventory. 2011-10-25, 2935👍, 0💬

What is Multi Node System ?
What is Multi Node System ? Multi Node System in Oracle Applications 11i means you have Applications 11i Component on more than one system. Typical example is Database, Concurrent Manager on one machine and forms, Web Server on second machine is example of Two Node System. 2011-10-19, 2784👍, 0💬

Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored and why its used ?
Where is appsweb.cfg or appsweb_$CONTEXT.cfg stored and why its used ? This file is defined by environment variable FORMS60_WEB_CONFIG_FILE This is usually in directory $OA_HTML/bin on forms tier. This file is used by any forms client session. When a user try to access forms , f60webmx picks up this... 2011-10-19, 2780👍, 0💬

What is difference between procedure and function
What is difference between procedure and function A function always returns a value, while a procedure does not. When you call a function you must always assign its value to a variable. 2011-10-25, 2747👍, 0💬

What are different modes of parameters used in functions and procedures?
What are different modes of parameters used in functions and procedures? There are three different modes of parameters: IN, OUT, and IN OUT. IN - The IN parameter allows you to pass values in to the module, but will not pass anything out of the module and back to the calling PL/SQL block. In other w... 2011-10-21, 2741👍, 0💬

What is difference between a formal and an actual parameter?
What is difference between a formal and an actual parameter? The formal parameters are the names that are declared in the parameter list of the header of a module. The actual parameters are the values or expressions placed in the parameter list of the actual call to the module. 2011-10-21, 2738👍, 0💬

Can cursor variables be stored in PL/SQL tables. If answer is yes, explain how? If not why?
Can cursor variables be stored in PL/SQL tables. If answer is yes, explain how? If not why? Yes. Create a cursor type - REF CURSOR and declare a cursor variable of that type. DECLARE /* Create the cursor type. */ TYPE company_curtype IS REF CURSOR RETURN company%ROWTYPE; /* Declare a cursor variable... 2011-10-25, 2720👍, 0💬

Can you clone from multi node system to single node system and vice versa ?
Can you clone from multi node system to single node system and vice versa ? Yes , this is now supported via Rapid Clone, Check if your system has all prereq. patches for Rapid Clone and you are on latest rapid clone patch. 2011-10-25, 2718👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.