Re: Perl Question - Split using | - Resolved
Wonderful! Thanks for all who responded. I always count on you guys. --- Andy Duncan <[EMAIL PROTECTED]> wrote: > Hi Celine, > > > After seeing the e-mails about "Perl for > Oracle-DBAs", > > I presume, my question wouldn't be completely > > inappropriate for this list. > > So if you Oracle Gurus, can help me with this Perl > > problem, I would greatly appreciate it. > > I have a problem with "split" when my delimiter > is "|". > > I know that if I escape the pipe, split should > work, > > that is only when it is a literal like split(/\|/, > "abc|def|123) > > > > But when my delimiter is to be dynamically read > from a > > file, I have it in a variable. Then this > escaping > > stuff doesn't work.. > > eg: > > my $HeaderAttributes = "abc|defgh|123"; > > print "$HeaderAttributes\n"; > > my $Delimiter = "\|"; > > (@Fields) = split(/$Delimiter/, > $HeaderAttributes); > > print "Delimiter = $Delimiter Field[0] = > > $Fields[0]\n"; > > > > prints > > a > > instead of > > abc. > > > > Does somebody have a solution to this. > > You might want to try and use the quotemeta > function, to create a regex > variable, which backslashes all alphanumerics within > string variables, eg: > > my $HeaderAttributes = "abc|defgh|123"; > print "$HeaderAttributes\n"; > my $Delimiter = "|"; > my $regex = quotemeta($Delimiter); > (@Fields) = split(/$regex/, $HeaderAttributes); > print "Delimiter = $Delimiter Field[0] = > $Fields[0]\n"; > > At this end, this produced: > > abc|defgh|123 > Delimiter = | Field[0] = abc > > In a reckless bid towards on-topic status, I can > only say that there's much > more of this kind of thing in Appendix C of "Perl > for Oracle DBAs", 'The > Essential Guide to Regular Expressions'! :-) > > HTH! :) > > Rgds, > AndyD > > __ > Do You Yahoo!? > Sign up for SBC Yahoo! Dial - First Month Free > http://sbc.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Andy Duncan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Celine John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Perl Question - Split using |
After seeing the e-mails about "Perl for Oracle-DBAs", I presume, my question wouldn't be completely inappropriate for this list. So if you Oracle Gurus, can help me with this Perl problem, I would greatly appreciate it. I have a problem with "split" when my delimiter is "|". I know that if I escape the pipe, split should work, that is only when it is a literal like split(/\|/, "abc|def|123) But when my delimiter is to be dynamically read from a file, I have it in a variable. Then this escaping stuff doesn't work.. eg: my $HeaderAttributes = "abc|defgh|123"; print "$HeaderAttributes\n"; my $Delimiter = "\|"; (@Fields) = split(/$Delimiter/, $HeaderAttributes); print "Delimiter = $Delimiter Field[0] = $Fields[0]\n"; prints a instead of abc. Does somebody have a solution to this. Thanks much. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Celine John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Date fields store as varchar2???
Hello, Our DB has a GMT time zone, while our data warehouse has EST. For our application, some guys here insist that we store dates as varchar2 to avoid all the problems associated with data in the two databases. Though personally I want the dates to be stored in oracle date datatype, I would like to know more about how date fields behave in different processes... like 1) Snapshots - if the date in the data WH is going to be refreshed via a snapshot, what will the value be. 2) Export/Import 3) SQLLoader I depend on this list to give me some expert advice on this. Thanks much. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Celine John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ftp from unix session to your local harddrive-How?
Sorry, I guess the description fo my question was quite vague. But what I really wanted is pretty much spelt out in the Subject line. In the meanwhile, thanks to Kirti, I will check out samba. Here is my problem:- When I am on-call on weekends etc. I connect remotely using ssh to get to my Unix server at work. Now if I want to download some files from my Unix session to my PC harddrive, I expected to be able to open a ftp session from my unix session to my PC so that when I do a get/put it would allow me to transfer files to and from my C: drive to my unix server at work. ( opening a ftp session from my dos prompt from home, gives my an "authorization error on the server" which is not surprising. Hence the need to do the other way round.) I hope I am making myself clear. --- "Deshpande, Kirti" <[EMAIL PROTECTED]> wrote: > Use samba. http://www.samba.org/samba/samba.html > > - Kirti > > > -Original Message- > Sent: Monday, February 25, 2002 1:28 PM > To: Multiple recipients of list ORACLE-L > > > Can please, somebody tell me how I can connect to > my > local harddrive from my unix session? > > Awaiting your valued responses, > Thank You. > > __ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Celine John > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Gogala, Mladen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Celine John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ftp from unix session to your local harddrive-How?
Can please, somebody tell me how I can connect to my local harddrive from my unix session? Awaiting your valued responses, Thank You. __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Celine John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-01630
Hi DBAs, I get the following message: ORA-01630: max # extents () reached in temp segment in tablespace when I am trying to create a snapshot as follows... create snapshot SNAP_A storage (initial 30M next 15 pctincrease 0) tablespace TS_A refresh complete with primary key as SELECT * FROM abc.tbl_a@prod There are about 3 million rows in the table. Can somebody tell me what I need to look at and what should I do? Is it the users default tablespace which in my case is TEMP, that is running out of space? Thanks so much. __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Celine John INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).