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

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

kiran prajapati

• Aug 6th, 2006

you can use the "rownum" column of the table. likeselect max(rownum) from tableName.select * from tableName where rownum = (fetched rownum)

mukund

• Aug 5th, 2006

I require this for the oracle 

Answer Question  Select Best Answer

dmadhusudhanarao

 Profile Answers by dmadhusudhanarao Questions by dmadhusudhanarao

• Aug 2nd, 2006

see if you want totally restric insert and update create a view with required columns and give it to them. dont forget to readonly while creating the view.

Prakash Pagam

• Jul 24th, 2006

We can do using databasename.tablename

Answer Question  Select Best Answer

Kiran Bondre

• Aug 1st, 2006

The fundamental difference between "WHERE" and "HAVING" is this: "WHERE" selects input rows before groups and aggregates are computed (thus, it controls which rows go into the aggregate...

Anurag Puranik

• Aug 1st, 2006

The WHERE clause is used to restricted only those columns which are not in group while HAVING clause is use to restricted the group functions.

Answer Question  Select Best Answer

Sarfaraz Ahmad Khan

• Jul 18th, 2006

yeah its very simpleuse the syntax like this:spool <somefilename>  (you can give the path also like c:sarfarazxyz.txt)<now your query>and to see that whether the result is actually st...

vssandilya

 Profile Answers by vssandilya Questions by vssandilya

• Jun 12th, 2006

please give an exampe as to how to do it in SQL SERVERFOR EXAMPLE IAM HAVING A TABLE DEPARTMENT1I WANT TO STORE THE CONTENTS OFSELECT * FROM DEPARTMENT1 INTO  C:KK.TXT.

Answer Question  Select Best Answer

Rajesh

• Jun 16th, 2006

253 is not prime, it is divisible by 11 and 23. So the ans. is 251.

Ravi

• Apr 29th, 2006

Hi Guys:Iam unable to follow ur discussion. why is it 251 and not 253. afterall we are finding the maximum (highest in value) prime number less than 255.Please correct me if Iam wrong.Thanks

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

No. A function has to return a value,an OUT parameter cannot return a value.

ashvini

• Apr 24th, 2006

Yes ,function can return a value but it is not a good programming practice

indrajit

• Nov 9th, 2005

Yes. Functions can have OUT parameter.

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

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

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

In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2, the only means of passing a cursor variable to a PL/SQL block is via bind variable or a procedure parameter.

Cost is basically unit of work or resource used involved memory, I/Oand CPU to execute the query.Card( or Base cardinality) - is the number of rows in a base table captured by running statistics on the table. If u have incorrect statistics u will be having problem here.Bytes - represents number of bytes accessed by the query.