.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

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, 3247👍, 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, 3245👍, 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, 3241👍, 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, 3235👍, 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, 3226👍, 0💬

Where is HTML Cache stored in Oracle Applications Server ?
Where is HTML Cache stored in Oracle Applications Server ? Oracle HTML Cache is available at $COMMON_TOP/_pages for some previous versions you might find it in $OA_HTML/_pages 2011-12-09, 3225👍, 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, 3224👍, 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, 3218👍, 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, 3215👍, 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, 3207👍, 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, 3194👍, 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, 3191👍, 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, 3190👍, 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, 3189👍, 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, 3184👍, 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, 3182👍, 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, 3163👍, 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, 3141👍, 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, 3141👍, 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, 3134👍, 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, 3119👍, 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, 3116👍, 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, 3112👍, 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, 3106👍, 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