Hi Guys, I have cleared the fundamental 1 Paper today with 98.33%( 59/60.) I've send mail to all groups peoples who have cleared the papers...for thier...
Hi ila, Congrats!!! man...u did the god job.i appricate ur thoughts.even i have the plan to do this paper.can u sen the list of questions to following mail...
Hi ila, Congrats!!! of clearing the paper. i have the plan to do this paper.can u sen the list of questions to following mail id..? naresh_thanvi@... ...
Hello, I am using sql*load to load my table. I want to only load a record if it's length is less than 100. I have a tried a no: of options. One that almost...
Hi , U can try with pl/sql script using file io package.. it may help.. ... __________________________________ Do you Yahoo!? Protect your identity with...
Hello, I am using sql*load to load my table. I want to only load a record if it's length is less than 100. I have a tried a no: of options. One that almost...
Hi, I am handling the responsibility of designing a strategy of Migrating Data from Oracle 8.0 to Oracle 9i Release 2.0.The conditions that apply for this are...
Friends, I need to improve the speed of this query, and don't know how. I apologize if this isn't the proper group; please point me in the right direction if...
Dear all We are developing Oracle 9i based ERP system,this is actually intranet based application.We have around 600 users will be connecting this application...
Hi Hassan, I don't think it is good idea to create 600 db users and maintain it. It will be nightmare to the dba to add and delete and keep track of new...
Varughese M
varughesem@...
Jan 13, 2004 3:39 pm
409
Dear varughesem, this is good concept yar. hassan pls go varu's option. rgds pren Varughese M <varughesem@...> wrote: Hi Hassan, I don't think it is good...
Dear varughesem, this giid concept yar. pls go varu is option. rgds pren Varughese M <varughesem@...> wrote: Hi Hassan, I don't think it is good idea to...
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 ...