Can anybody help me to find a way to retrieve large amount of data per batch(100 records at the time). I want maximize the cpu usage. Thank you Ernie ... Do...
Ernie, Using pl/sql bulk feature you can retrieve number of rows together. Let me know if you need more detail, or go to metalink.oracle.com. Rajesh Arora ... ...
Rajesh Arora
arora_rajesh@...
Mar 4, 2004 11:41 pm
413
Dear all I would like to know whether is it possible to create Drill down reports in Oracle 9i Reports?Please let me know Regards Hassan...
I have a column containing large data with carriage return. When I query this column, it will give me several rows for one record because of carriage return....
Try expanding on this, set serveroutput on declare phrase varchar2(32767) := 'inter'||chr(13)||'national'||chr(13)||'lization'; newphrase varchar2(32767) :=...
This query remove a carriage return between two strings, "inter[carriage return]national" and give a single string "international". You may expand this to a...
Or, select replace(column,chr(13),null) from table ... ... This query remove a carriage return between two ... time. Find local movie times and trailers on...
Varughese M
varughesem@...
Mar 27, 2004 2:03 pm
418
Thanks. I did it. ... __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. ...
Thanks, Goddie. I used replace function in my query, but your pl/sql code gave me hint about chr(13). wei ... time. __________________________________ Do you...
hi everyone, I have one problem ie, What is Database(Oracle) testing? How to write test cases for DB Stored procedures (DB Code checking) and data integrity...
I just installed ora 10g on two Win2K machines. On one machine I couldn't bring the Enterprise Manager up. I checked Administrative Tools\Services to see if if...
Dear Group Members, I'v just joined in the group, and seek your help. while starting Logminer with starttime and endtime parameter it gives an error :Fatal...
Hai I am using Oracle Forms 6i on win2000 on local machine where as Unix on my web server Iam getting an error FRM-40815 when am running the form to generate a...
Hi, I want to downlaod the trial copy of 10G software can any one please tell me from where to downlaod . I have try otn.oracle.com,technet.oracle and so may...
Hai Iam getting an error FRM-40815 when am running the form to generate a report on my local server which is on Win 200 OS where as my web server is on Unix ...
Hi , If some has good doc which explain in detail about this AURORA$SERVER$SHUTDOWN trigger please share with me If have searh in the metalink but not getting...
I am using Oracle 9i DS on XP with Oracle 9i DB on Unix. I have a form and am trying to run a report from the form. This is what I have coded: repid =...
you can do it with run_product () also.I think that will sove ur problem. mmmangal@... wrote: I am using Oracle 9i DS on XP with Oracle 9i DB on Unix. I...
Hai Iam getting an error FRM-40815 when am running the form to generate a report on my local server which is on Win 200 OS where as my web server is on Unix ...
Dear Team Members, In one of our operating offices the Oracle 8.1.7 version is running, while in rest of our offices we always use Oracle 8.1.5. Now the...
Ayesha I am sanjay acharya from ahmedabad . My suggestion is set complitibility parameter in initR.ora file of the 8.1.7 which would be comptibility=8.1.5. and...
Hi All, I would like to know any of you implemented java stored procedure sending out TIBCO message. Please email me if you have implemented it Thanks, ...
Varughese M
varughesem@...
Sep 1, 2004 8:52 pm
435
HI ALL, Thanks for the responses, but i have got the solution. It is possible to downgrade the data of 8.1.7 to 8.1.5 by using d080105.sql and several other...
hi Ayesha Could u please tell the detail script of d080105.sql and the other scripts u used for downgrading the data of 8.1.7 to 8.1.5. i will be very thankful...
I create one trigger when i am trying to compile it is giving PLS-00417: unable to resolve "RTN_ORD_RTN_RSV_QTY" as a column while this column exist in table...
I'm implementing an application but I have to make a decision on use stored procedures or prepared statemnts. Do you have any experience and what will be your...
dear user Stored procedure is more useful if you want it in a very frequenlty used module as it stores all module in library cache once loaded in complile form...
The Fall Conference of the Northern California Oracle Users Group will be held on Thursday, November 4, 2004 at Computer History Museum in Mounta View. This...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
