.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

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, 3115👍, 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, 3113👍, 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, 3112👍, 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, 3093👍, 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, 3075👍, 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, 3037👍, 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, 3017👍, 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, 3009👍, 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, 2991👍, 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, 2984👍, 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