[prev in list] [next in list] [prev in thread] [next in thread]
List: odtug-sqlplus-l
Subject: RE: sql loader and concatenate fields
From: <Ajay_K_Garg () Dell ! com>
Date: 2004-05-13 12:34:49
Message-ID: F001.005E495E.20040513052427 () fatcity ! com
[Download RAW message or body]
Hi Renato
Go to http://oracle.ittoolbox.com/ and search for "name concatenate sql
loader" ( without the double quotes).
I believe there was a related thread some weeks back, and u shud find
the details there.
hth
Regards
Ajay
-----Original Message-----
Renato Cazzolla
Sent: Thursday, May 13, 2004 6:40 PM
To: Multiple recipients of list ODTUG-SQLPLUS-L
Hi gurus,
I need to load "last name" and "name" into a characters field
but these 2 informations are not contiguously in the input record (fixed
length).
They are from pos. 10 to 25 and from 50 and 75.
Is there a way to "concatenate" the 2 informations into only one
field ?
Thanks in advance.
Renato Cazzolla
MACPLAST S.p.A.
02/950807362
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2734.1600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=201292112-13052004><FONT face=Arial color=#0000ff size=2>Hi
<FONT face="Times New Roman" color=#000000>Renato </FONT></FONT></SPAN></DIV>
<DIV><SPAN class=201292112-13052004><FONT size=2></FONT></SPAN> </DIV>
<DIV><FONT size=2><SPAN class=201292112-13052004>Go to </SPAN><FONT face=Arial
color=#0000ff><A
href="http://oracle.ittoolbox.com/">http://oracle.ittoolbox.com/</A><FONT
face="Times New Roman"><FONT
color=#000000> </FONT></FONT></FONT></FONT><SPAN
class=201292112-13052004><FONT face=Arial color=#0000ff size=2>and search for
"name concatenate sql loader" ( without the double quotes).</FONT></SPAN></DIV>
<DIV><SPAN class=201292112-13052004><FONT face=Arial color=#0000ff size=2>I
believe there was a related thread some weeks back, and u shud find the details
there.</FONT></SPAN></DIV>
<DIV><SPAN class=201292112-13052004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=201292112-13052004><FONT face=Arial color=#0000ff
size=2>hth</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><FONT face=Arial size=2>Regards</FONT></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial><FONT size=2>Ajay <SPAN
class=201292112-13052004><FONT
color=#0000ff> </FONT></SPAN></FONT></FONT></SPAN></P>
<P><SPAN lang=en-us><FONT face=Arial><FONT size=2><SPAN
class=201292112-13052004> </SPAN></FONT></FONT></SPAN></P>
<P> </P>
<P><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
ml-errors@fatcity.com [mailto:ml-errors@fatcity.com] <B>On Behalf Of </B>Renato
Cazzolla<BR><B>Sent:</B> Thursday, May 13, 2004 6:40 PM<BR><B>To:</B> Multiple
recipients of list ODTUG-SQLPLUS-L<BR><B>Subject:</B> sql loader and concatenate
fields<BR><BR></P></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Cumberland size=2>Hi gurus,</FONT></DIV>
<DIV><FONT face=Cumberland size=2>I need to load "last name" and
"name" into a characters field but these 2 informations are not
contiguously in the input record (fixed length). </FONT></DIV>
<DIV><FONT face=Cumberland size=2>They are from pos. 10 to 25 and from 50 and
75.</FONT></DIV>
<DIV><FONT face=Cumberland size=2>Is there a way to "concatenate" the 2
informations into only one field ?</FONT></DIV>
<DIV><FONT face=Cumberland size=2></FONT> </DIV>
<DIV><FONT face=Cumberland size=2>Thanks in advance.</FONT></DIV>
<DIV><FONT face=Cumberland size=2></FONT> </DIV>
<DIV><FONT face=Cumberland size=2>Renato Cazzolla<BR>MACPLAST
S.p.A.<BR>02/950807362</FONT></DIV></BLOCKQUOTE></BODY></HTML>
--
ODTUG Now! 2004, Let Us Show you How! June 20-24, 2004 at the Westin Kierland
Resort, Scottsdale, Arizona. Visit http://www.odtug.com for details.--
Author: <Ajay_K_Garg@Dell.com
INET: Ajay_K_Garg@Dell.com
Fat City Hosting, San Diego, California -- http://www.fatcity.com
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ODTUG-SQLPLUS-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).
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic