Message-Id: <10667.120781@fatcity.com> From: Venkat_Kalepalli Date: Wed, 1 Nov 2000 15:25:09 +0530 Subject: 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_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@bni.co.id] > Reply To: ORACLE-L@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@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@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 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