Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> select problem

select problem

From: Venkat_Kalepalli <Venkat_Kalepalli_at_satyam.com>
Date: Wed, 1 Nov 2000 15:25:09 +0530
Message-Id: <10667.120781@fatcity.com>


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_01C043E9.DDA9DCB0
Content-Type: text/plain

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

> ----------
> From: Nosie[SMTP:tekait11_at_bni.co.id]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, November 01, 2000 10:30 AM
> To: Multiple recipients of list ORACLE-L
> Subject: OOT: Salary in Singapore
>
> Dear All,
>
> Firstly, I am sorry for crossposting this and slightly off-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
> --
> 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_01C043E9.DDA9DCB0
Content-Type: text/html
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=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">
<TITLE>select problem</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">Hi to all,</FONT> </P>

<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">I am facing a = problem while selecting a column of table.&nbsp; The data type of = column&nbsp; 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.&nbsp;&nbsp;&nbsp;&nbsp; Any clue is highly appreciated. = </FONT></P>

<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">&nbsp;oerr ora = 1489</FONT>
<BR><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">01489, 00000, = &quot;result of string concatenation is too long&quot;</FONT>

<BR><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">// *Cause: String =
concatenation result is more than the maximum size.</FONT>
<BR><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">// *Action: Make =
sure that the result is less than the maximum size.</FONT>
</P>
<BR>

<P><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"Arial">I am working Oracle = verson of 7.3.4.0.0.</FONT>
</P>

<P><FONT COLOR=3D"#008000" SIZE=3D4 FACE=3D"MS Sans = Serif">Venkat</FONT>

<BR><FONT COLOR=3D"#008000" SIZE=3D4 FACE=3D"MS Sans Serif">Oracle =
DBA.</FONT>
<BR><FONT COLOR=3D"#800080" SIZE=3D2 FACE=3D"MS Sans Serif">Ph:7846101- =
Extn: 5648</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans =

Serif">Nosie[SMTP:tekait11_at_bni.co.id]</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Reply To:</FONT></B> = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D1 FACE=3D"MS Sans = Serif">ORACLE-L_at_fatcity.com</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Sent:</FONT></B> &nbsp; = <FONT SIZE=3D1 FACE=3D"MS Sans Serif">Wednesday, November 01, 2000 = 10:30 AM</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">To:</FONT></B> = &nbsp;&nbsp;&nbsp; <FONT SIZE=3D1 FACE=3D"MS Sans Serif">Multiple = recipients of list ORACLE-L</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">Subject:</FONT></B> = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D1 FACE=3D"MS Sans = Serif">OOT: Salary in Singapore</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Dear All,</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Firstly, I am sorry for crossposting = this and slightly off-the-topic.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">I get an offer for a position in = Singapore.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">I need a fair assessment from you who = work or ever worked in Singapore. How</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">much is the average monthly salary = for a DBA (or other similar position)? Is</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">S$ 2500 enough for living cost? too = low? How about S$3000?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks so much for all your opinion. I = am looking forward to hear from</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">you.....soon.</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Sincerely,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Y. Nosie.</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L = FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A></FONT></U>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Nosie</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =
tekait11_at_bni.co.id</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network = Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) = 538-5051</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, = California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=
-----------</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">To REMOVE yourself from this mailing = list, send an E-Mail message</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">the message BODY, include a line = containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">(or the name of mailing list you want = to be removed from).&nbsp; You may</FONT> Received on Wed Nov 01 2000 - 03:55:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US