| 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: select problem
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_01C043FB.72233230
Content-Type: text/plain;
charset="iso-8859-1"
how many fields are there in the table? what is total record length ?
I tried with creating small table with 3 fields (2 varchar2(length 2000 and
10 ) and 1 number) and inserting 10 records with 2000 characters and other
fields and it worked
(Oracle8i- 815 on NT - Testing DB)
-----Original Message-----
From: Venkat_Kalepalli [mailto:Venkat_Kalepalli_at_satyam.com]
Sent: Wednesday, November 01, 2000 3:38 PM
To: Multiple recipients of list ORACLE-L
Subject: select problem
Hi to all,
I am facing a problem while selecting a column of table. The data type of column is varchar2(2000). Other than this field I can easily select remaining. If I select this column I am getting the following oracle error. Even If I give select * from table also getting the same error. Any clue is highly appreciated.
oerr ora 1489
01489, 00000, "result of string concatenation is too long"
// *Cause: String concatenation result is more than the maximum size.
// *Action: Make sure that the result is less than the maximum size.
I am working Oracle verson of 7.3.4.0.0.
Venkat
Oracle DBA.
Ph:7846101- Extn: 5648
To: Multiple recipients of list ORACLE-L Subject: OOT: Salary in Singapore Dear All, Firstly, I am sorry for crossposting this and slightlyoff-the-topic.
I get an offer for a position in Singapore. I need a fair assessment from you who work or ever worked in Singapore. How much is the average monthly salary for a DBA (or other similar position)? Is
S$ 2500 enough for living cost? too low? How about S$3000?
Thanks so much for all your opinion. I am looking forward to hear
from
you.....soon.
Sincerely,
Y. Nosie.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>
-- Author: Nosie INET: tekait11_at_bni.co.id 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_01C043FB.72233230 Content-Type: text/html; charset="iso-8859-1"Received on Wed Nov 01 2000 - 06:00:38 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>select problem</TITLE>
<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=050074811-01112000>how
many fields are there in the table? what is total record length ?
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=050074811-01112000>I
tried with creating small table with 3 fields (2 varchar2(length 2000 and 10 ) and 1 number) and inserting 10 records with 2000 characters and other fields and it worked </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=050074811-01112000>(Oracle8i- 815 on NT - Testing DB)</SPAN></FONT></DIV>
<BLOCKQUOTE>
<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Venkat_Kalepalli [mailto:Venkat_Kalepalli_at_satyam.com]<BR><B>Sent:</B> Wednesday, November 01, 2000 3:38 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> select problem<BR><BR></DIV></FONT> <P><FONT color=#800080 face=Arial size=2>Hi to all,</FONT> </P> <P><FONT color=#800080 face=Arial size=2>I am facing a problem while selecting a column of table. The data type of column is varchar2(2000). Other than this field I can easily select remaining. If I select this column I am getting the following oracle error. Even If I give select * from table also getting the same error. Any clue is highly appreciated. </FONT></P> <P><FONT color=#800080 face=Arial size=2> oerr ora 1489</FONT> <BR><FONT color=#800080 face=Arial size=2>01489, 00000, "result of string concatenation is too long"</FONT> <BR><FONT color=#800080 face=Arial size=2>// *Cause: String concatenation result is more than the maximum size.</FONT> <BR><FONT color=#800080 face=Arial size=2>// *Action: Make sure that the result is less than the maximum size.</FONT> </P><BR> <P><FONT color=#800080 face=Arial size=2>I am working Oracle verson of 7.3.4.0.0.</FONT> </P> <P><FONT color=#008000 face="MS Sans Serif" size=4>Venkat</FONT> <BR><FONT color=#008000 face="MS Sans Serif" size=4>Oracle DBA.</FONT> <BR><FONT color=#800080 face="MS Sans Serif" size=2>Ph:7846101- Extn: 5648</FONT> </P> <UL> <P><FONT face="MS Sans Serif" size=1>----------</FONT> <BR><B><FONT face="MS Sans Serif" size=1>From:</FONT></B> <FONT face="MS Sans Serif" size=1>Nosie[SMTP:tekait11_at_bni.co.id]</FONT> <BR><B><FONT face="MS Sans Serif" size=1>Reply To:</FONT></B> <FONT face="MS Sans Serif" size=1>ORACLE-L_at_fatcity.com</FONT> <BR><B><FONT face="MS Sans Serif" size=1>Sent:</FONT></B> <FONT face="MS Sans Serif" size=1>Wednesday, November 01, 2000 10:30 AM</FONT> <BR><B><FONT face="MS Sans Serif" size=1>To:</FONT></B> <FONT face="MS Sans Serif" size=1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT face="MS Sans Serif" size=1>Subject:</FONT></B> <FONT face="MS Sans Serif" size=1>OOT: Salary in Singapore</FONT> </P> <P><FONT face=Arial size=2>Dear All,</FONT> </P> <P><FONT face=Arial size=2>Firstly, I am sorry for crossposting this and slightly off-the-topic.</FONT> </P> <P><FONT face=Arial size=2>I get an offer for a position in Singapore.</FONT> <BR><FONT face=Arial size=2>I need a fair assessment from you who work or ever worked in Singapore. How</FONT> <BR><FONT face=Arial size=2>much is the average monthly salary for a DBA (or other similar position)? Is</FONT> <BR><FONT face=Arial size=2>S$ 2500 enough for living cost? too low? How about S$3000?</FONT> </P> <P><FONT face=Arial size=2>Thanks so much for all your opinion. I am looking forward to hear from</FONT> <BR><FONT face=Arial size=2>you.....soon.</FONT> </P> <P><FONT face=Arial size=2>Sincerely,</FONT> <BR><FONT face=Arial size=2>Y. Nosie.</FONT> </P> <P><FONT face=Arial size=2>-- </FONT><BR><FONT face=Arial size=2>Please see the official ORACLE-L FAQ:</FONT><U> <FONT color=#0000ff face=Arial size=2><A href="http://www.orafaq.com" target=_blank>http://www.orafaq.com</A></FONT></U> <BR><FONT face=Arial size=2>-- </FONT><BR><FONT face=Arial size=2>Author: Nosie</FONT> <BR><FONT face=Arial size=2> INET: tekait11_at_bni.co.id</FONT> </P> <P><FONT face=Arial size=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT face=Arial size=2>San Diego, California -- Public Internet access / Mailing Lists</FONT> <BR><FONT face=Arial size=2>--------------------------------------------------------------------</FONT> <BR><FONT face=Arial size=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT> <BR><FONT face=Arial size=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT> <BR><FONT face=Arial size=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT face=Arial size=2>(or the name of mailing list you want to be removed from). You may</FONT> <BR><FONT face=Arial size=2>also send the HELP command for other information (like
 |
 |