Using ORACLE PRECOMPILERS, SQL statements and PL/SQL blocks can be contained inside 3GL programs written in C,C++,COBOL,PASCAL, FORTRAN,PL/1 AND ADA.The Precompilers are known as Pro*C,Pro*Cobol,...This form of PL/SQL is known as embedded pl/sql,the language in which pl/sql is embedded is known as the host language. The prcompiler translates the embedded SQL and pl/sql ststements into calls to the...

RamaKrishna.Yerra,TCS,Hyd,9989018508

• Aug 21st, 2006

Hi !! PRAGMA is one of the Precompiers of Oracle ..Wht it does is similar to Pre compier Directives in C Lang.. Thanks&RegdsRamaKrishna.Yerra,TCS,Hyd,9989018508

Answer Question  Select Best Answer

Hash joing is implemented in CBO and comparatively faster.  Merge joing is comparatively slow because both the row sources are to be sorted before merging.

Sampath

• Oct 22nd, 2005

Hash join occupies lots of memory as it creates hashes

Answer Question  Select Best Answer

Vijay

• Jul 9th, 2005

Yes it possible to insert/update/delete data for CLOB, BLOB, NCLOB columns. Now how to do it.  1. Suppose if you are using JAVA applications to modify the database columns, then you have t...

Answer Question  Select Best Answer

Ashish Dhagat

• Nov 15th, 2005

SRW is a package name, used while creating a report using rdf. it helps to perform action at runtime. for example changing the colour of the col. according to value fetched by the report, Calling...

Answer Question  Select Best Answer

rajamuna

 Profile Answers by rajamuna Questions by rajamuna

• Apr 4th, 2006

SELECT *,ROWNUM r FROM (SELECT COUNT(url_name) hit,url_name FROM URL_DETAILS_TBL WHERE url_name IN (SELECT DISTINCT url_name FROM URL_DETAILS_TBL WHERE TO_DATE(ENTRY_DATE,'MM/DD/YYYY') = '12/13/2005')...

Answer Question  Select Best Answer

manu

• May 18th, 2006

check this link.....http://asktom.oracle.com/pls/ask/f?p=4950:8:16663421538065257584::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:766825833740

Answer Question  Select Best Answer

Debasis

• Aug 12th, 2006

Merge can be called 'UPSERT'. Using merge we can insert records if it was not present in the table earlier , if present It will update the record without appending.....

Answer Question  Select Best Answer

Maria Antony Samy

• Oct 14th, 2006

Very Simple question! But should be explained a lot.Databse data is stored in data_file's of the databse. For every table's data some space from the data_files would be allocated. This space is known ...

Answer Question  Select Best Answer

CD

• Nov 5th, 2007

You may use a functions called 'characters'.Syntax:characters ()

Answer Question  Select Best Answer

sangeeta

• Oct 18th, 2006

The start with .. connect by clause can be used to select data that has a hierarchical relationship (usually some sort of parent->child (boss->employee or thing->parts). It is also being used when an sql execution plan is explained.

Answer Question  Select Best Answer

Musharraf Dabre

• Sep 19th, 2006

 Hi ,    any kind of oracle error ,go to this link::             http://ora-00904.ora-code.com/all.html

Answer Question  Select Best Answer

Write a SQL query to select 10 random records from a table?

Rajasekhar

• Jul 22nd, 2011

SELECT Top 10 * from Emp order by NEWID()

Answer Question  Select Best Answer

How to display data in the table between mth column to nth column in a table in Oracle?

AnithaLetchumi

 Profile Answers by AnithaLetchumi Questions by AnithaLetchumi

• Jul 27th, 2011

Hi, I don't think there exists predefined pseudo column for column number in oracle. I have done a procedure, which creates a view for displaying data from Mth to Nth column in a table. Hope it helps....

Answer Question  Select Best Answer

A cursor variable is associated with different statements at run time, which can hold different values at run time. Static cursors can only be associated with one run time query. A cursor variable is reference type (like a pointer in C).Declaring a cursor variable:TYPE type_name IS REF CURSOR RETURN return_type type_name is the name of the reference type,return_type is a record type indicating the...

NIKHIL

• Oct 12th, 2011

A cursor is just like an pointer variable which processes in the memories. Cursors can be used to process multirecord set. There are two types of cursors implicit and explicit cursors. DECLARE var_r...

Answer Question  Select Best Answer

The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 16th, 2008

No we can not use a scalar data type as return type.The return value of a strongly typed REF CURSOR must be a record which can be defined using the %ROWTYPE and %TYPE attributes or as a record structure.  

Answer Question  Select Best Answer

No, a cursor variable points a row which cannot be stored in a two-dimensional PL/SQL table.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

No you can not store the cursor variable into pl/sql tablebut yes the out put or cursor variable can be stored how:set serveroutput ondeclaretype v_table is table of emp%rowtype index by binary_intege...

Answer Question  Select Best Answer

Yes

swapna

• Mar 28th, 2007

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

Answer Question  Select Best Answer

Drop Procedure procedure_nameDrop Function function_name

kumars77

 Profile Answers by kumars77 Questions by kumars77

• Apr 24th, 2008

Absolutely it will work

Answer Question  Select Best Answer

jahid

• Mar 24th, 2007

You can use view "user_tab_columns". in this view you will get. In this you will get table_name, column_name, datatype and all things..select * from user_tab_columns;

Answer Question  Select Best Answer

SIVA

• May 25th, 2007

We can't?select?next value and current value?from views.

Answer Question  Select Best Answer