Re: Unix - script
Try out the following. wget ftp://user:password@host IP/full path of File/Directory Example :- wget ftp://oracle:[EMAIL PROTECTED]//home/superman/myfile.txt Get back in case of any clarification. Bye Sundar Thomas, Kevin wrote: Roland,Try this by setting up environment variables at the top of your script:SERVER1= 10.10.10.10USER1= 'xxx'PWD1= 'xxx'SERVER2= 10.10.10.20USER1= 'yyy'PWD2= ''Then have this:ftp -i -n EOFopen $SERVER1user $USER1 $PWD1cd scriptsget filecloseEOFYou can then have a section like the one below if you want to copy to adifferent serverother than the one you are running this script from:ftp -i -n EOFopen $SERVER2user $USER2 $PWD2cd scriptsput filecloseEOFBoth of these can be included in the one shell script.Hope that helps.Kev.'In Windows no one can hear you scream'__Kevin ThomasTechnical AnalystDeregulation ServicesCalanais Ltd.(2nd Floor East - Weirs Building)Tel: 0141 568 2377Fax: 0141 568 2366http://www.calanais.com-Original Message-Sent: 09 January 2002 07:16To: Multiple recipients of list ORACLE-LHallo,I would like to have an example of a unix script, which does the following:copy some files from directory /prod/sas/data located at "hardy".(which isa computer)to the other database hakon. Is it possible to do this. Please help mequick.Thanks in advanceRoland S
Re: SQL LOADER
Hi, I am trying to assign a default value for a column from my sequence and i am unable to do that. How do you give it in the control file? Thanks in advance. Regards Sundar Mercadante, Thomas F wrote: IA, like this: ( col1 char , col_seq test_seq.nextval ) where test_seq is a sequence HTH Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, December 19, 2001 6:50 AM To: Multiple recipients of list ORACLE-L using sql loader it is possible to populate fields with a sequnce e.g INTO TABLE dept (deptno sequence(2, 3), but i want to use my own sequence , i.e my_seq.nextval how is this done? reagards IA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sundar 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).
DBMS_JOB Help
Dear All, Can anyone tell me how to find out currently running jobs initiated thru DBMS_JOB package? Thanks Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar 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).
DBMS_JOB Help
Hi All, Can Anyone tell me how to stop a background job initiated through a DBMS_JOB package when it is no longer required? Thanks in advance. Regards Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar 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: sqlplus formatting question
Hi, You can try the following :- SELECT REPLACE(FIELD NAME, 'SEARCH CHAR', 'REPLACE CHAR') FROM TABLE NAME Say for example Select Replace(ename, ' ', '_') from emp Bye Sundar John Dunn wrote: I want to display a varchar2 field that contains spaces between words i.e MY NAME, but replace the spaces with underscores on the report i.e MY_NAME How can I do this in sqlplus? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Rangachari Sundar 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).
urgent..! ANSI Standard SQL for Outer Join (ORACLE SQL SERVER)
Dear All, Can anyone of you help me for the following. I want to give a generalized SQL syntax for Outer Join for both oracle SQL server. Can I use ANSI Syntax say for example select empno, ename from emp join dept on emp.deptno = dept.deptno (Something like this) Bye Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar 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: sql help --urgent
Hi, Select a, decode(sign(a), -1, 0, a-1) from Table Name For summing up : sum(decode(sign(a), -1, 0, a-1)) Hope this helps Bye Sundar Ravindra Basavaraja wrote: I have a table with a number column(Col A).I want to display A-1.There could be some negative values in this A-1 column.But I want to display 0 whereever negative value appears.I can use the ROUND(A-1) but this will round the other positive value to the next positve integer which I don't want to happen. select a,a-1,round(a-1) from t; AA-1 ROUND(A-1) - -- -- 3 2 2 1 0 0 .6-.4 0 .8-.2 0 6 5 5 3.52.5 3 .69 -.31 0 2.71.7 2 sum 10.29--this value is the sum of all the negative and positive numbers I want the o/p to be like this.The decimal numbers should not be rounded off to the next number. select a,a-1,round(a-1) from t; AA-1 MY REQUIREMENT - -- -- 3 2 2 1 0 0 .6-.4 0 .8-.2 0 6 5 5 3.52.5 2.5 .69 -.31 0 2.71.7 1.7 Sum 11.2(My REQUIREMENT) My requirement is to compute the sum of the columns for exact value i.e I want the sum of only the positive numbers(negative numbers should not be counted for the sum that's why I want to display 0 for negative value as the sum function adds all the positive and negative numbers) How can I do this Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja 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: Rangachari Sundar 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).
How set Date format Globally
Hi, I have a requirement. Everytime when i make a session to the database i want the Date Format to beas follows '-mm-dd hh:mi:ss' The existing default format is 'dd-mon-' and so I tried the following steps. ALTER SESSION set NLS_DATE_FORMAT='-mm-dd hh:mi:ss' and put that in the login.sql it worked fine for my every client session. How can I set it globally so that everytime when I make a session to database from any client It should be '-mm-dd hh:mi:ss'. Regards Sundar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rangachari Sundar 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).
[Fwd: How set Date format Globally]
Hi, I have a requirement. Everytime when i make a session to the database i want the Date Format to beas follows '-mm-dd hh:mi:ss' The existing default format is 'dd-mon-' and so I tried the following steps. ALTER SESSION set NLS_DATE_FORMAT='-mm-dd hh:mi:ss' and put that in the login.sql it worked fine for my every client session. How can I set it globally so that everytime when I make a session to database from any client It should be '-mm-dd hh:mi:ss'. Regards Sundar
Re:
Hi, I have given that in Init.ora and also have tried DBMS_SESSIOM.set_nls both not working... can anybody know the solution. Regards Sundar Greg Solomon wrote: My boss tells me that two major projects have come out of Berkeley in the last 50 years. One was BSD; the other was LSD ... go figure. -Original Message- Sent: Tuesday, 10 July 2001 19:46 To: Multiple recipients of list ORACLE-L Registry, services? OH wait must be an NT thing, sorry, i was having an acid flashback that unix was going down the tubes. Sorry, joe Coed-naked Database Administration Find 'em fragmented, leave 'em coalesced. [EMAIL PROTECTED] 07/10/01 01:26PM Hello, I need to recreate a database, basically make a complete copy of one of the existing databases on a new server. My networking people already copied all datafiles, control file, log files, init file, etc to the target server. They also reproduced operating system directory structure. What I need to do is to make the second part of the task work, create the database, services, etc and make it run. I have not done it before and if I was doing it I would probably do export/import type of thing but the higher ups would like to have it done this way. One of the people has an idea suggesting just recreating the registry setting by exporting it from the existing machine to the new one. The other option is to reinstall Oracle but I am not sure how to make it to accept existing physical components(datafiles, control file, etc). If someone has a suggestion I would greatly appreciate it. Thank you in advance. Lyuda Hoska -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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 your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Greg Solomon 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: Rangachari Sundar 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: Linux profile - a little offtopic
hi, In linux it is bash shell and you have to change you bash_profile of oracle and not the .profile file. check that out Csillag Zsolt wrote: Hi, Since I'd like to install Oracle for Linux, I need to change the profile for user 'oracle'. I edited the .profile file located in /home/oracle folder but it seems to me that this isn't the file that Linux loads at startup. T.I.A. Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt 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: Rangachari Sundar 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).
Work around for PL/SQL code
Hi, Let me introduce myself. I am Rangachari Sundar from Chennai India. I have the workaround for the requirement you have posted and here it is vPOSTAL_NO := lpad(replace(trim(recCursor.POSTAL_NO), ' ', ''), 7, '0') ; Trim is not available prior to oracle 8 so if your version is prior to 8 you can change that to LTRIM(RTRIM(recCursor.POSTAL_NO)) Bye Sundar [EMAIL PROTECTED] wrote: How can I change this pl/sql code. I want this to happen: I have for instance this blank 5 5 blank 55 which means 55 55 (the spaces ar ethe blanks.) and I want it to be like this: 00 How can I change this code to let this happen: vPOSTAL_NO:= lpad(nvl(recCursor.POSTAL_NO,'0'),7,'0'); Thanks to all who canhelp me. Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Rangachari Sundar 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).