.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

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

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, 2940👍, 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, 2936👍, 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, 2933👍, 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, 2932👍, 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, 2928👍, 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, 2893👍, 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, 2865👍, 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, 2863👍, 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, 2856👍, 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, 2825👍, 0💬

<< < … 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