| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Copying some rows from a table having a long datatype column.
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C08BCD.F53DE8A0
Content-Type: text/plain;
charset="windows-1252"
Also if you need selected row you can create a view based on required select statement and use this view in the copy command - did not try this myself but should work.
Alex Hillman
-----Original Message-----
From: Cale, Rick T (Richard) [mailto:RICHARD.T.CALE_at_saic.com]
Sent: Wednesday, January 31, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Copying some rows from a table having a long datatype
column.
Use the COPY command. It will allow you to insert a long from another table.
Rick
> -----Original Message-----
> From: Kumar, Dharminder [SMTP:Dharminder.Kumar_at_bmonesbittburns.com]
> Sent: Wednesday, January 31, 2001 2:32 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Copying some rows from a table having a long datatype
> column.
>
> Hi,
> I have a requirement like mentioned bellow.
>
> Table A
>
> Columns datatype
> col1 number
> col2 long
>
> Table B
> col1 number
> col2 long
>
> I need to put some rows from table A to table B.
> If I use the sqlplus
>
> sqlplus>insert into A select * from B where B.col1 < 50;
> I get the following error.
>
> ORA-00997: illegal use of LONG datatype
>
> Is there any other way to accomplish this goal.
>
> Thanks.
>
> Dharminder Kumar
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kumar, Dharminder
> INET: Dharminder.Kumar_at_bmonesbittburns.com
>
> 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: ListGuru_at_fatcity.com (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: Cale, Rick T (Richard) INET: RICHARD.T.CALE_at_saic.com 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: ListGuru_at_fatcity.com (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). ------_=_NextPart_001_01C08BCD.F53DE8A0 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dwindows-1252"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: Copying some rows from a table having a long datatype = column.</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Also if you need selected row you can create a view = based on required select statement and use this view in the copy = command - did not try this myself but should work.</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Cale, Rick T (Richard) [<A = HREF=3D"mailto:RICHARD.T.CALE_at_saic.com">mailto:RICHARD.T.CALE_at_saic.com</= A>]</FONT> <BR><FONT SIZE=3D2>Sent: Wednesday, January 31, 2001 3:21 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: Copying some rows from a table having a = long datatype</FONT> <BR><FONT SIZE=3D2>column.</FONT> </P> <BR> <P><FONT SIZE=3D2>Use the COPY command. It will allow you to insert a = long from another table.</FONT> </P> <P><FONT SIZE=3D2>Rick</FONT> </P> <P><FONT SIZE=3D2>> -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> From: Kumar, Dharminder = [SMTP:Dharminder.Kumar_at_bmonesbittburns.com]</FONT> <BR><FONT SIZE=3D2>> Sent: Wednesday, January 31, 2001 2:32 = PM</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list = ORACLE-L</FONT> <BR><FONT SIZE=3D2>> Subject: Copying = some rows from a table having a long datatype</FONT> <BR><FONT SIZE=3D2>> column.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Hi,</FONT> <BR><FONT SIZE=3D2>> I have a requirement like mentioned = bellow.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Table A</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Columns = datatype</FONT> <BR><FONT SIZE=3D2>> col1 = number</FONT> <BR><FONT SIZE=3D2>> col2 = long</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Table B</FONT> <BR><FONT SIZE=3D2>> col1 = number</FONT> <BR><FONT SIZE=3D2>> col2 = long</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> I need to put some rows from table A to table = B.</FONT> <BR><FONT SIZE=3D2>> If I use the sqlplus </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> sqlplus>insert into A select * from B where = B.col1 < 50;</FONT> <BR><FONT SIZE=3D2>> I get the following error.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> ORA-00997: illegal use of LONG datatype</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Is there any other way to accomplish this = goal.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Thanks.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Dharminder Kumar</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Author: Kumar, Dharminder</FONT> <BR><FONT SIZE=3D2>> INET: = Dharminder.Kumar_at_bmonesbittburns.com</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Cale, Rick T (Richard)</FONT> <BR><FONT SIZE=3D2> INET: RICHARD.T.CALE_at_saic.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Wed Jan 31 2001 - 15:37:06 CST
 |
 |