.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

<< < 1 2 3 4 5 6 7 8 9 10 … > >>   Sort: Rank

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, 3286👍, 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, 3136👍, 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, 3189👍, 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, 3134👍, 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, 3235👍, 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, 3312👍, 0💬

Can the default values be assigned to actual parameters?
Can the default values be assigned to actual parameters? Yes. In such case you don’t need to specify any value and the actual parameter will take the default value provided in the function definition. 2011-10-20, 3018👍, 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, 3451👍, 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, 3210👍, 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, 3412👍, 0💬

Where would I find .rf9 file, and what it dose ?
Where would I find .rf9 file, and what it dose ? These files are used during restart of patch in case of patch failure because of some reason. 2011-10-18, 3573👍, 0💬

Where is Concurrent Manager log file location
Where is Concurrent Manager log file location By default standard location is $APPLCSF/$APPLLOG , in some cases it can go to $FND_TOP/log as well. 2011-10-18, 3206👍, 0💬

What is US directory in $AD_TOP or under various product TOP's .
What is US directory in $AD_TOP or under various product TOP's . US directory is defauly language directory in Oracle Applications. If you have multiple languages Installed in your Applications then you will see other languages directories besides US, that directory will contain reports, fmx and oth... 2011-10-11, 3477👍, 0💬

What is main concurrent Manager types.
What is main concurrent Manager types. # ICM - Internal Concurrent Manager which manages concurrent Managers # Standard Managers - Which Manage processesing of requests. # CRM - Conflict Resolution Managers , resolve conflicts in case of incompatibility. 2011-10-11, 3269👍, 0💬

Whats is difference between two env files in &lt;CONTEXT>.env and APPS&lt;CONTEXT>.env under $APPL_TOP ?
Whats is difference between two env files in &lt;CONTEXT>.env and APPS&lt;CONTEXT>.env under $APPL_TOP ? APPS&lt;CONTEXT>.env is main environment file which inturn calls other environment files like &lt;CONTEXT>.env under $APPL_TOP, &lt;CONTEXT>.env under 806 ORACLE_HOME and cust... 2011-10-04, 3568👍, 0💬

How to check if Oracle application 11i System is Rapid Clone enabled ?
How to check if Oracle application 11i System is Rapid Clone enabled ? For syetem to be Rapid Clone enabled , it should be Autoconfig enabled (Check above How to confirm if application 11i is Autoconfig enabled). You should have Rapid Clone Patches applied , Rapid Clone is part of Rapid Install Prod... 2011-10-04, 3269👍, 0💬

How to check if application 11i System is Autoconfig enabled ?
How to check if application 11i System is Autoconfig enabled ? Under $AD_TOP/bin check for file adcfginfo.sh and if this exists use adcfginfo.sh contextfile=&lt;CONTEXT> show=enabled If this file is not there , look for any configuration file under APPL_TOP if system is Autoconfig enabled then y... 2011-09-27, 3309👍, 0💬

What are ORACLE PRECOMPILERS?
What are ORACLE PRECOMPILERS? A precompiler is a tool that allows programmers to embed SQL statements in high-level source programs like C, C++, COBOL, etc. The precompiler accepts the source program as input, translates the embedded SQL statements into standard Oracle runtime library calls, and gen... 2011-09-20, 3558👍, 0💬

What is OCI. What are its uses?
What is OCI. What are its uses? OCI is Oracle Call Interface. When applications developers demand the most powerful interface to the Oracle Database Server, they call upon the Oracle Call Interface (OCI). OCI provides the most comprehensive access to all of the Oracle Database functionality. The new... 2011-09-20, 3541👍, 0💬

What are between database triggers and form triggers?
What are between database triggers and form triggers? Database triggers are fired whenever any database action like INSERT, UPATE, DELETE, LOGON LOGOFF etc occurs. Form triggers on the other hand are fired in response to any event that takes place while working with the forms, say like navigating fr... 2011-09-13, 3415👍, 0💬

What is an UTL_FILE? What are different procedures and functions associated with it?
What is an UTL_FILE? What are different procedures and functions associated with it? The UTL_FILE package lets your PL/SQL programs read and write operating system (OS) text files. It provides a restricted version of standard OS stream file input/output (I/O). Subprogram -Description FOPEN function-... 2011-09-13, 3678👍, 0💬

Can you use a commit statement within a database trigger?
Can you use a commit statement within a database trigger? Yes, if you are using autonomous transactions in the Database triggers. 2011-09-05, 3295👍, 0💬

What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function?
What is the maximum buffer size that can be specified using the DBMS_OUTPUT.ENABLE function? 1000000 2011-09-05, 3893👍, 0💬

What is different between TRUNCATE and DELETE?
What is different between TRUNCATE and DELETE? The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data removed by TRUNCATE. Truncate is a DDL statement whereas ... 2011-08-30, 3605👍, 0💬

<< < 1 2 3 4 5 6 7 8 9 10 … > >>   Sort: Rank

.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