.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, 3275👍, 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, 3271👍, 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, 3262👍, 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, 3259👍, 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, 3259👍, 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, 3253👍, 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, 3246👍, 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, 3238👍, 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, 3229👍, 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, 3225👍, 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, 3221👍, 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, 3221👍, 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, 3213👍, 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, 3210👍, 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, 3209👍, 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, 3202👍, 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, 3194👍, 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, 3165👍, 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, 3161👍, 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, 3158👍, 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, 3141👍, 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, 3138👍, 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, 3137👍, 0💬

What are different modes of forms in which you can start Forms Server and which one is default ?
What are different modes of forms in which you can start Forms Server and which one is default ? You can start forms server in SOCKET or SERVLET by defualt Forms are configured to start in socket mode. 2011-12-08, 3129👍, 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