<< < 19 20 21 22 23 24   Sort: Date

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, 2902👍, 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, 2899👍, 0💬

Whats is location of access_log file ?
Whats is location of access_log file ? access_log file by default is located in $IAS_ORACLE_HOME/ Apache/Apache/logs. Location of this file is defined in httpd.conf by patameter CustomLog or TransferLog
2011-11-23, 2898👍, 0💬

When do you use WHERE clause and when do you use HAVING clause?
When do you use WHERE clause and when do you use HAVING clause? The WHERE condition lets you restrict the rows selected to those that satisfy one or more conditions. Use the HAVING clause to restrict the groups of returned rows to those groups for which the specified condition is TRUE.
2011-12-06, 2893👍, 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, 2885👍, 0💬

What is use of a cursor variable? How it is defined?
What is use of a cursor variable? How it is defined? Cursor variable is used to mark a work area where Oracle stores a multi-row query output for processing. It is like a pointer in C or Pascal. Because it is a TYPE, it is defined as TYPE REF CURSOR RETURN ;
2011-11-01, 2860👍, 0💬

What is Location of Jserv configuration files ?
What is Location of Jserv configuration files ? Jserv configuration files are located in $IAS_ORACLE_HOME /Apache/Jserv/etc .
2011-11-24, 2825👍, 0💬

How can you licence a product after installation ?
How can you licence a product after installation ? You can use ad utility adlicmgr to licence product in Oracle application.
2011-11-10, 2824👍, 0💬

There is a % sign in one field of a column. What will be the query to find it?
There is a % sign in one field of a column. What will be the query to find it? SELECT column_name FROM table_name WHERE column_name LIKE ‘%\%%’ ESCAPE ‘\’;
2011-12-06, 2806👍, 0💬

When you apply C driver patch does it require database to be Up and Why ?
When you apply C driver patch does it require database to be Up and Why ? Yes , database and db listener should be Up when you apply any driver patch in application. even if driver is not updating any database object connection is required to validate application and other schema and to upload patch...
2011-12-02, 2797👍, 0💬

<< < 19 20 21 22 23 24   Sort: Date