RE: Connection Problem
Thanks folks (a useful gender-neutral word). Suggestions received were clean up old names files try pinging name and ip address use ip address in names file instead of a name trace. I have 4 Oracles on the machine so I renamed old names files. I then failed to ping by name, but was able to ping by ip address. So I changed the names file to use ip address instead of name. At this point one of those little ironies that makes computing such fun stepped in. Unbeknown to me the server went down so it seemed that the combined knowledge of this list had brought my Oracle system to its knees. However once service was restored all worked. S.J.C. Fox CRH 0161 601 8723 -Original Message- Sent: 27 June 2003 18:49 To: Multiple recipients of list ORACLE-L I access a database from 2 different sites, having a PC at each site. At one site I use NT and have no problems. At the other site I use Win 2000 and usually get an error message when trying to log on ORA-12545 Connect failed because target host or object does not exist Occasionally it lets me on. People at the other site tell me that they can connect ok Anyone know what might be causing the problem? S.J.C. Fox CRH 0161 601 8723 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Connection Problem
spot on, thanks. S.J.C. Fox CRH 0161 601 8723 -Original Message- Sent: 27 June 2003 19:20 To: Multiple recipients of list ORACLE-L A name resolution problem? Symptoms for the site with problems are consistent with not getting consistently consistent service from your name server. Look are your tnsnames.ora and see if it has the name of host there. If so, try putting in the IP address instead. -Original Message- I access a database from 2 different sites, having a PC at each site. At one site I use NT and have no problems. At the other site I use Win 2000 and usually get an error message when trying to log on ORA-12545 Connect failed because target host or object does not exist Occasionally it lets me on. People at the other site tell me that they can connect ok Anyone know what might be causing the problem? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Connection Problem
fair point about lack of info. You guessed correctly about contents of tnsnames file. Many thanks. S.J.C. Fox CRH 0161 601 8723 -Original Message- [mailto:[EMAIL PROTECTED] Sent: 28 June 2003 00:04 To: Multiple recipients of list ORACLE-L Try turning on SQL Net tracing to discover the problem. Turn on tracing on the client PC by adding the appropriate trace parameters to the sqlnet.ora file. This will produce a trace file upon your next connection attempt and you will be able to (hopefully) see what is causing the problem. It is hard for anyone to diagnose a connectivity problem without more information like which version of Oracle, is a Names Server being used?, does the target server's IP address exist in the PC's local host file?, etc. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] ma.slb.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Connection Problem com 06/27/2003 12:49 PM Please respond to ORACLE-L I access a database from 2 different sites, having a PC at each site. At one site I use NT and have no problems. At the other site I use Win 2000 and usually get an error message when trying to log on ORA-12545 Connect failed because target host or object does not exist Occasionally it lets me on. People at the other site tell me that they can connect ok Anyone know what might be causing the problem? S.J.C. Fox CRH 0161 601 8723 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Connection Problem
I access a database from 2 different sites, having a PC at each site. At one site I use NT and have no problems. At the other site I use Win 2000 and usually get an error message when trying to log on ORA-12545 Connect failed because target host or object does not exist Occasionally it lets me on. People at the other site tell me that they can connect ok Anyone know what might be causing the problem? S.J.C. Fox CRH 0161 601 8723 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: FOX, Simon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: how to retrieve numeric values only from a varchar2?
RE: Data Warehouse experts, a simple question for you
Has anyone got that jokey review of a new wonder storage/retrieval format .book ? Simon Fox Room 308, CRH 0161 601 8723 -Original Message- Sent: 22 May 2002 03:58 To: Multiple recipients of list ORACLE-L Mladen, That IS what I do with the documentation CD. But Jack and I were talking about REAL books here, you know, those things that are made of paper, have printing on the pages, words, diagrams all that sort of stuff Rachel --- Gogala, Mladen [EMAIL PROTECTED] wrote: No, no, no and no! You are supposed to eat your documentation CD, preferably with fajitas or spaghetti and lots of Tabasco sauce. There are some versions of habanera sauce which can prepare your mouth to such extent that it becomes impossible to tell oracle documentation CD and a chicken wing apart. Make sure that you have few gallons of water at hand, though. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject: Re: Data Warehouse experts, a simple question for you gee, and here I thought all I had to do was put the book under my pillow and let the words seep in through osmosis :) -- 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). __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon 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).
Telephone Alerts
We have some UNIX batch processes that send us e-mails when they have finished. Does anyone have any experience of sending a SMS message to a mobile phone? Simon Fox Room 221 Furlong House Queens Drive NOTTINGHAM NG2 1AL Phone 0115 957 6536 Fax 0115 957 6548 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___
RE: Telephone Alerts
thanks for this. Will investigate. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 13 May 2002 14:18To: Multiple recipients of list ORACLE-LSubject: Re: Telephone AlertsThis is a standalone package if you don't want to write your own. http://www.bai.de/sendsms/sendsms.shtml.en otherwise use Google and search for SMS and ETSI: This one looked particularly useful: http://www.dreamfabric.com/sms/ Steve ParkerE Mail: [EMAIL PROTECTED] -- "FOX, Simon" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 13/05/2002 14:03 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Telephone AlertsWe have some UNIX batch processes that send us e-mails when they have finished. Does anyone have any experience of sending a SMS message to a mobile phone? Simon Fox Room 221 Furlong House Queens Drive NOTTINGHAM NG2 1AL Phone 0115 957 6536 Fax 0115 957 6548 ___This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received thisemail in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited.If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.___
RE: Telephone Alerts
Thanks for this detailed reply. I shall take this further. -Original Message- Sent: 13 May 2002 14:53 To: Multiple recipients of list ORACLE-L Simon, Many cellphone providers provide a service whereby an email recieved at a specific address is sent on to a mobile phone in the form of a page. Here is the routine that I use to scrape my output logs and send a success or failure page to my cellphone: #!/bin/ksh # shell script to run sql scripts and contact the user with succes or failure # Jack Silvey #---Oracle variable section --- export ORACLE_SID=iron export ORACLE_HOME=/u01/app/oracle/product/8.1.7 #---shell variable section --- SCRIPTPATH=/u01/app/oracle/admin/iron/scripts SQLPATH=$SCRIPTPATH/sql SCRIPTNAME=$SQLPATH/$1 OUTPATH=$SCRIPTPATH/output [EMAIL PROTECTED] SCRIPTOUTPUT=$OUTPATH/$1.out USERNAME=$2 PASS=$3 #---Clean out the output file--- cat /dev/null$SCRIPTOUTPUT #---Run the SQL*Plus script, storing results in a variable--- SQLRESULTS=`sqlplus /nolog @$SCRIPTNAME $SCRIPTOUTPUT $SQLPATH/endsql.sql` #---Check the command-line return code--- SCRIPTERROR=$? #---Check to make sure output doesn't contain SQl*PLUS errors--- cat $SCRIPTOUTPUT|grep SP2- GREPOUTPUT=$? if [[ $GREPOUTPUT -eq 0 ]] then SCRIPTERROR=`expr $SCRIPTERROR + 1` fi #---Check to make sure output doesn't contain Oracle errors--- cat $SCRIPTOUTPUT|grep ORA- GREPOUTPUT=$? if [[ $GREPOUTPUT -eq 0 ]] then SCRIPTERROR=`expr $SCRIPTERROR + 1` fi #---Check to make sure the resulting variable doesn't contain errors--- echo $SQLRESULTS|grep SP2- GREPOUTPUT=$? if [[ $GREPOUTPUT -eq 0 ]] then SCRIPTERROR=`expr $SCRIPTERROR + 1` fi echo $SQLRESULTS|grep ORA- GREPOUTPUT=$? if [[ $GREPOUTPUT -eq 0 ]] then SCRIPTERROR=`expr $SCRIPTERROR + 1` fi --this section pages the dba with success or failure-- if [[ $SCRIPTERROR -ne 0 ]] then echo $1 failed | mailx $CONTACT exit 99 else echo $1 successful | mailx $CONTACT fi hth, Jack Silvey --- FOX, Simon [EMAIL PROTECTED] wrote: We have some UNIX batch processes that send us e-mails when they have finished. Does anyone have any experience of sending a SMS message to a mobile phone? Simon Fox Room 221 Furlong House Queens Drive NOTTINGHAM NG2 1AL Phone 0115 957 6536 Fax 0115 957 6548 ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon 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
RE: How Can I get A sequence Current Value in PROC
.CURRVAL Only works after .NEXTVAL Simon Fox -Original Message- Sent: 26 November 2001 12:50 To: Multiple recipients of list ORACLE-L Hi when writing a program PROC sequenceName.NEXTVAL points to the next value of a sequence, is there anything like sequenceName.SOMETHING that returns current value of sequence. Thanks E. __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ehsan sinavalda 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon 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: financial problems with fatcity.com
As another UK citizen (who would pay from his own pocket) I would prefer an annual sub since the cost of currency conversion can be steep on small sums. Simon Fox Room 205, CRH 01270 533997 -Original Message- Sent: 29 August 2001 19:17 To: Multiple recipients of list ORACLE-L Just had a chat to the boss, and we would happily pay $10 per month for the service, provided that there was an easy way for us to pay for it such as a credit card since we are based in England. Regards Mark -Original Message- Sent: Wednesday, August 29, 2001 16:48 To: Multiple recipients of list ORACLE-L How about Corporate Sponsorship? -Original Message- Sent: Wednesday, August 29, 2001 11:16 AM To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex 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: Haskins, Ed 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: Mark Leith 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon 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: SQLLDR Question
Can you remove the comma between date and time to make it 1 field? Simon Fox Room 205, CRH 01270 533997 -Original Message- Sent: 23 May 2001 22:41 To: Multiple recipients of list ORACLE-L I am trying to load a file that has the fields comma-delimited, variable length. A sample line from the file looks like this: 503,414081660,Success,Auth,AH9042,z,4555,-,-,-,0,05/01/01,14:21 The problem I am having is putting the date and time together. The control file looks like this: load data infile 'cyber_real.dat' append into table rit_cyber_hist when order_id 'Order ID' and order_id '' fields terminated by ',' (order_id, trans_nbr, cyber_status, trans_type, auth_code, avs_code, trans_amt, cic_resp, po_nbr, ship_to_zip, tax_amt, trans_date date(14) mm/dd/yy,hh:mi) It ignores the time portion of the file, I presume because it has a comma before it and it assumes that it is a different field. I can't figure out any way to get this loaded with the trans_date field containing both the date and time. This is on Oracle 8.1.6.0 on Sun Solaris. Any suggestions? Thank you. -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema UK Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon 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 loader query
In a recent mail on a similar topic someone said that in 8i there is a FILLER field in SQL*Loader that allows you to jump over a column. Prior to 8i you are stuck. I have been recommended a brand new book on SQL*Loader. Not yet bought or read it. Jonathan Gennick Sanjay Mishra O'Reilly Associates It is available in the States but not yet in the UK. e.g. Amazon.com Simon Fox Room 205 Rail House Gresty Road CREWE Cheshire CW2 6EA England 01270 533997 -Original Message- Sent: 17 May 2001 09:35 To: Multiple recipients of list ORACLE-L you can use the skip option of the sql loader. in ur case it should be skip=1(if headings are also separated by commas) can have the full help by typing sqlldr help=y at the command prompt. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 1:05 PM Friends, I have the classic case of a comma separated text file which I want to upload and I need to know how can I enforce the following behavior of the SQL Loader: 1. To ignore the first row of the data file (which contains the column titles) 2. Avoid uploading of a column from the middle of the data file Thanks in advance, Pierre -- 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: Saurabh Sharma 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema UK Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon 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: Decode in PL/Sql
Feuerstein recommends replacing with IF statements. Page 517 Oracle PL/SLQ Programming. Simon Fox Room 205 Rail House Gresty Road CREWE Cheshire CW2 6EA England 01270 533997 -Original Message- Sent: 17 May 2001 10:26 To: Multiple recipients of list ORACLE-L Hi Gurus ! Is there any function that can be used in PL/SQL and just works the way as DECODE does in Sql? Thanks in Advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor, Gyula 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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema UK Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: FOX, Simon 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).