Re: joining word/ lines in a file
-- Jared Still <[EMAIL PROTECTED]> > If isn't perfect. An 'and' at the end of the line will be joined with > the beginning of the next line, which is not right. Don't strip the newlines, replace them with white space: perl -e 'undef $/; ($a=) =~ s/\n+/ /g; print $a' \ [file [file...]] [) =~ s/\n+/ /g;s/ +/ /g;print $a' ... will convert nearly anything you can give it into a nice, clean, single line. If you want to get things neater than this see the examples in Parse::RecDescent. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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: joining word/ lines in a file
Hey this is a not a trick question, without buying the books listed below is there a way using the std awk, sed, tr *nix utilities. Suhen > Flex, Bison & some programming will probably do the trick. > There is a nice O'Reilly book dealing with Lex & Yacc wnd even > nicer book dealing with the C programming language. > The Good Book is: Brian Kernighan and Dennis Ritchie: The C Programming > Language. > You should get the King James (ANSII) edition. > > > > On 2002.05.28 23:58 Suhen Pather wrote: > > List, slightly off topic but > > > > Unix OS > > > > I need to join lines/ words in a file. > > So that it must be in a readable Oracle format. > > > > They are seperated by a newline. > > > > Here is a snippet of what the file looks like. > > > > FILE1 > > > > delete from JDAPROD.HBI_LOST_SALES where SKU_TECHNICAL_KEY = 1410 and > > STORE_TECH > > NICAL_KEY = 276 and STORE_NO = 315 and STORE_NAME = 'Glenfield SB 315 > > ' and SKU = '1516803' and SKU_NAME = 'WMERE ORGAN > > ISER Black ' and DEPT = '052' and DEPT_N > > AME = 'Travel Bags' and CLASS = '05211 > > ' and CLASS_NAME = 'Travel Bags' a > > nd FORMAT_EXISTS = 'Y' and STOCK_ON_HAND = 2 and STOCK_IN_WAREHOUSE = > > 433 > > and RE > > QUESTED_UNITS = 0 and ALLOCATED_UNITS = 0 and UNIT_SALES_CURRENT_DAY = > > 0 and > > UNI > > T_SALES_LAST_7_DAYS = 0 and UNIT_SALES_LAST_6_WEEKS = 2 and > > ON_HAND_COST = > > 41.23 > > 7 and ON_HAND_RETL = 167.333 and GROUP_NO = '05 ' and GROUP_NAME = ' > > Travel' and EST_STOCK = 0 and INTRANSIT = 2 and DATE_RUN = > > TO_DATE('27MAY2002 > > 00:00:00', 'DDMON HH24:MI:SS') and ON_ORDER = 150; > > > > I am trying using sed but cant seem to work it out. > > > > Any Ideas? > > > > Regards > > Suhen > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Suhen Pather > > 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). > > > > -- > Mladen Gogala > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mladen Gogala > 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: Suhen Pather 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: joining word/ lines in a file
-- Suhen Pather <[EMAIL PROTECTED]> > Hey this is a not a trick question, without buying the books > listed below is there a way using the std awk, sed, tr *nix > utilities. Perl is going to be the simplest since it has a regex for whitespace and you can easily change the input record specifier (undef $/ for slurp mode). -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Lembark 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).
Mid level Oracle DBA position Available in 1800flowers.com
Hi, Sorry to be posting this mail here, There is a mid level Oracle dba Full Time position available here in 1800Flowers.com,If any one of u are interested please send me your resume,I can forward it to my Director or if you can mail it directly mail it to [EMAIL PROTECTED] We are pure OLTP and sun shop, stress is given more on performance tuning,24x7 and should be willing to carry pager all the time. Please do let us know ur expected salary as well when u are sending ur resume. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani 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).
get_file_name built-in of forms for web
Hi Friends Did someone succeed to implement the get_file_name built-in of forms using a javabean with the wrapper class as suggested by Oracle at Metalink (Note:74140.1) ? When I try to compile it, I've got the following error : MyDialog.java:4: Public class FDialog must be defined in a file called "FDialog.java". public class FDialog extends Canvas { ^ 1 error The java source that I tried to compile is given here below : Bookmark Fixed font Go to End Doc ID: Note:74140.1 Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 16-SEP-1999 Last Revision Date: 05-DEC-2001 PURPOSE === The get_file_name built-in of forms is currently not implemented for Web. You could create a Javabean and use it to implement this functionality for WebForms. Attached below are the source code of JavaBean & the Wrapper Class for the Bean. CREATING JAVABEAN = The Bean uses the following methods and Classes --- PropertyChangeSupport for the file_name property. java.awt.FileDialog class is used to show the File Dialog. firePropertyChange method is called to pass a PropertyChange event to all classes which are registered as listeners to this class. addPropertyChangeListener is used by other classes to register themself as PropertyChangeListener for this class. --- import java.awt.*; import java.beans.*; public class FDialog extends Canvas { private String file_name ; private PropertyChangeSupport pcs; public FDialog() { file_name = ""; pcs = new PropertyChangeSupport(this); } public void set_file_name() { Frame frame = new Frame("Sample"); java.awt.FileDialog OpenDlg = new FileDialog(frame, "Open ", java.awt.FileDialog.LOAD); OpenDlg.setFile("*.*"); OpenDlg.show(); String old_file_name = file_name; file_name=OpenDlg.getDirectory() + OpenDlg.getFile(); pcs.firePropertyChange("file_name", old_file_name, file_name); } public void addPropertyChangeListener(PropertyChangeListener pcl) { pcs.addPropertyChangeListener(pcl); } public void removePropertyChangeListener(PropertyChangeListener pcl) { pcs.removePropertyChangeListener(pcl); } } - Thanks for your help -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ALEMU Abiy 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: what if recovery catalog is lost?
Ruth, Do you know if it's possible to make backup of recovery catalog using export/import? Regards, Alexandre - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, May 28, 2002 6:08 PM > I have put my recovery catalog database in archivelog mode. I do a cold > backup of the database and the archivelogs each Friday. This way I won't > lose it. > > Ruth > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, May 28, 2002 4:58 AM > > > > Hi, > > > > That strange, but this has never come to my mind before. > > Ideally, the recovery catalog should be on other than production server > (and > > it always was for me). And recovery catalog's database should be copied as > > well. Perhaps, using production database for recovery catalog. > > What if recovery catalog and production database crash at the same time > and > > there is no way to recovery database with recovery catalog? > > I need the functionality of RMAN with recovery catalog, but I don't have > > separate server :( so I'm going to place it on the same server, but > > different database. I'm going to backup both databases symbiothically > using > > each other as recovery catalog. > > If something goes wrong and server crashes with both databases, I will > have > > backup copies but no catalog. > > > > >>Recovery scenarios:<< > > > > --1. I could create empty recovery catalog and collect all information > again > > with CATALOG comand, but this works only when target database is open. > > Right? > > > > --2. Another possibility is to use RESYNC CATALOG FROM BACKUP CONTROL FILE > > should work fine, doesn't it? The only problem is that last structural > > changes are not available. > > > > --3. I'm not sure about third scenario - recovery target database without > > recovery catalog with backups taken while recovere catalog existed. > > > > I'm going to test this cases before set it up in production and I'd like > to > > know about you experience in that area. > > > > Thanks in advance. > > > > Alexandre > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Alexandre Gorbatchev > > 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: Ruth Gramolini > 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: Alexandre Gorbatchev 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: joining word/ lines in a file
Thanks Steven, Jared for the ideas. Regards Suhen > -- Suhen Pather <[EMAIL PROTECTED]> > > > Hey this is a not a trick question, without buying the books > > listed below is there a way using the std awk, sed, tr *nix > > utilities. > > Perl is going to be the simplest since it has a regex for > whitespace and you can easily change the input record > specifier (undef $/ for slurp mode). > > -- > Steven Lembark 2930 W. Palmer > Workhorse Computing Chicago, IL 60647 > +1 800 762 1582 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Steven Lembark > 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: Suhen Pather 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).