Hi, Try as given below like '\_% Thanks STS ... __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design...
It doesn't work. I also tried like '%\\_' doesn't work either. Thanks ... __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free,...
This one works select * from test where instr(col,'_') >0 ; ... work. I also tried ... http://personals.yahoo.com.au - Yahoo! Personals - New people, new...
Varughese M
varughesem@...
Aug 7, 2003 8:17 pm
392
hai, Try this '%\_%' escape '\'; you have to use escape operator. Let me know if it works Suresh __________________________________ Do you Yahoo!? Yahoo!...
It doesn't work either. Thanks wei ... __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software ...
Gi Expersts, Here i configuring Multi master Replication i am following simple schema to be replicate schema name is scott. im useig following scirpts .These...
i have installed oracle 8i, the reinstalled oracle forms developer 6, then i was asked to : Configuration Steps for Oracle Forms installation of 11:44:14...
Anthony ASSI
anthony@...
Sep 2, 2003 1:25 pm
396
Hello , i want to ask about few things about oracle 9i when i am studying the fundamentals 2 , i found some missing pionts FIRST : when my database in archive...
Hi Ahmed, For your first question, the answer is that the replaced file from a previous backup will be of a different version from that of the current files...
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...
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.
