.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

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, 2958👍, 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, 2955👍, 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, 2945👍, 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, 2945👍, 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, 2937👍, 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, 2901👍, 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, 2879👍, 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, 2873👍, 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, 2872👍, 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, 2836👍, 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