.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

<< < … 18 19 20 21 22 23 24 >   Sort: Date

What is the purpose of a cluster?
What is the purpose of a cluster? A cluster provides an optional method of storing table data. A cluster is comprised of a group of tables that share the same data blocks, which are grouped together because they share common columns and are often used together. For example, the EMP and DEPT table sh... 2011-11-22, 3065👍, 0💬

What is a cursor?
What is a cursor? A cursor is a mechanism by which you can assign a name to a “select statement” and manipulate the information within that SQL statement. 2011-11-21, 3065👍, 0💬

How you will start Discoverer in Oracle Applications 11i ?
How you will start Discoverer in Oracle Applications 11i ? In order to start dicoverer you can use script addisctl.sh under $OAD_TOP/admin/scripts/$CONTEX T_NAMEor startall.sh under $ORACLE_HOME/discwb4/util (under Middle/Application Tier) 2011-12-08, 3063👍, 0💬

How do you open and close a cursor variable. Why it is required?
How do you open and close a cursor variable. Why it is required? Using OPEN cursor_name and CLOSE cursor_name commands. The cursor must be opened before using it in order to fetch the result set of the query it is associated with. The cursor needs to be closed so as to release resources earlier than... 2011-10-31, 3062👍, 0💬

What is difference between AD_BUGS and AD_APPLID_PATCHES ?
What is difference between AD_BUGS and AD_APPLID_PATCHES ? AD_BUGS holds information about the various Oracle Applications bugs whose fixes have been applied (ie. patched) in the Oracle Applications installation. AD_APPLIED_PATCHES holds information about the "distinct" Oracle Applications patches t... 2011-11-09, 3057👍, 0💬

Which is more faster - IN or EXISTS?
Which is more faster - IN or EXISTS? Well, the two are processed very differently. Select * from T1 where x in ( select y from T2 ) is typically processed as: select * from t1, ( select distinct y from t2 ) t2 where t1.x = t2.y; The sub query is evaluated, distinct’ed, indexed (or hashed or sorted) ... 2011-12-05, 3053👍, 0💬

Where is DATABASE/PLSSQL cache stored ?
Where is DATABASE/PLSSQL cache stored ? PLSSQL and session cache are stored under $IAS_ORACLE_HOME/ Apache/modplsql/cache directory. 2011-11-26, 3052👍, 0💬

Which two tables created at start of application Patch and drops at end of Patch ?
Which two tables created at start of application Patch and drops at end of Patch ? FND_INSTALLED_PROCESS and AD_DEFFERED_JOBS are the tables that get updated while applying a patch mainly d or unified driver. 2011-11-08, 3052👍, 0💬

Can C driver in application patch create Invalid Object in database ?
Can C driver in application patch create Invalid Object in database ? No , C driver only copies files in File System. Database Object might be invalidated during D driver when these objects are created/dropped/modified. 2011-11-15, 3041👍, 0💬

What is a pseudo column. Give some examples?
What is a pseudo column. Give some examples? Information such as row numbers and row descriptions are automatically stored by Oracle and is directly accessible, ie. not through tables. This information is contained within pseudo columns. These pseudo columns can be retrieved in queries. These pseudo... 2011-11-23, 3039👍, 0💬

Where is applications start/stop scripts stored ?
Where is applications start/stop scripts stored ? applications start/stop scripts are in directory $COMMON_TOP/admin/scripts/$CON TEXT_NAME 2011-11-14, 3021👍, 0💬

What are main configuration files in Web Server (Apache) ?
What are main configuration files in Web Server (Apache) ? Main configuration files in Oracle application Web Server are # httpd.conf, apps.conf, oracle_apache.conf, httpd_pls.conf # jserv.conf, ssp_init.txt, jserv.properties, zone.properties # plsql.conf, wdbsvr.app, plsql.conf 2011-11-14, 3016👍, 0💬

What are various options available with adpatch ?
What are various options available with adpatch ? Various options available with adpatch depending on your AD version are autoconfig, check_exclusive, checkfile, compiledb, compilejsp, copyportion, databaseprtion, generateportion, hotpatch, integrity, maintainmrc, parallel, prereq, validate 2011-10-28, 3014👍, 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, 3009👍, 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, 3009👍, 0💬

What is plssql/database cache ?
What is plssql/database cache ? In order to improve performance mod_pls (Apache component) caches some database content to file. This database/plssql cache is usually of type session and plsql cache # session cache is used to store session information. # plsql cache is used to store plsql cache i.e.... 2011-11-26, 3008👍, 0💬

Where will you find forms configuration details apart from xml file ?
Where will you find forms configuration details apart from xml file ? Forms configuration at time of startup is in script adfrmctl.sh and appsweb_$CONTEXT_NAME.cfg (defined by environment variable FORMS60_WEB_CONFIG_FILE) for forms client connection used each time a user initiates forms connection. 2011-12-07, 3002👍, 0💬

What is a cursor for loop?
What is a cursor for loop? A cursor FOR loop is a loop that is associated with (actually defined by) an explicit cursor or a SELECT statement incorporated directly within the loop boundary. Use the cursor FOR loop whenever (and only if) you need to fetch and process each and every record from a curs... 2011-11-03, 2999👍, 0💬

Where is plssql cache stored in Oracle Applications ?
Where is plssql cache stored in Oracle Applications ? Usually two type of cache session and plssql stored under $IAS_ORACLE_HOME/Apache/modpls ql/cache 2011-12-13, 2991👍, 0💬

What is a OUTER JOIN?
What is a OUTER JOIN? An OUTER JOIN returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition. 2011-12-05, 2987👍, 0💬

How you put Applications 11i in Maintenance mode ?
How you put Applications 11i in Maintenance mode ? Use adadmin to change Maintenance mode is Oracle application. With AD.I you need to enable maintenance mode in order to apply application patch via adpatch utility. If you don't want to put application in maintenance mode you can use adpatch options... 2011-10-27, 2976👍, 0💬

What are things you do to reduce patch timing ?
What are things you do to reduce patch timing ? You can take advantage of following - # Merging patches via admrgpch # Use various adpatch options like nocompiledb or nocompilejsp # Use defaults file # Staged APPL_TOP during upgrades # Increase batch size (Might result into negative ) 2011-10-26, 2967👍, 0💬

Can you apply patch without putting Applications 11i in Maintenance mode ?
Can you apply patch without putting Applications 11i in Maintenance mode ? Yes, use options=hotpatch as mentioned above with adpatch. 2011-10-27, 2963👍, 0💬

What should be the return type for a cursor variable. Can we use a scalar data type as return type?
What should be the return type for a cursor variable. Can we use a scalar data type as return type? The return type of a cursor variable can be %ROWTYPE or record_name%TYPE or a record type or a ref cursor type. A scalar data type like number or varchar can’t be used but a record type may evaluate t... 2011-11-01, 2958👍, 0💬

<< < … 18 19 20 21 22 23 24 >   Sort: Date

.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