.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

How you will avoid your query from using indexes?
How you will avoid your query from using indexes? By changing the order of the columns that are used in the index, in the Where condition, or by concatenating the columns with some constant values. 2011-12-02, 3129👍, 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, 3125👍, 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, 3125👍, 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, 3121👍, 0💬

How to compile an Oracle Reports file ?
How to compile an Oracle Reports file ? Utility adrepgen is used to compile Reports. Synatx is given below adrepgen userid=apps\&lt;psswd> source = $PRODUCT_TOP\srw\filename.rdf dest=$PRODUCT_TOP\srw\filename .rdfstype=rdffile dtype=rdffile logfile=x.log overwrite=yes batch=yes dunit=character 2011-11-08, 3120👍, 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, 3115👍, 0💬

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, 3115👍, 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, 3105👍, 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, 3104👍, 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, 3101👍, 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, 3100👍, 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, 3093👍, 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, 3091👍, 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, 3078👍, 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, 3074👍, 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, 3064👍, 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, 3055👍, 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, 3049👍, 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, 3048👍, 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, 3034👍, 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, 3030👍, 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, 3019👍, 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, 3015👍, 0💬

What happens if you don't give cache size while defining Concurrent Manager ?
What happens if you don't give cache size while defining Concurrent Manager ? Lets first understand what is cache size in Concurrent Manager. When Manager picks request from FND CONCURRENT REQUESTS Queues, it will pick up number of requests defined by cache size in one shot and will work on them bef... 2011-12-13, 3008👍, 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