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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Selecting values from Tables with columns of VARCHAR type

Re: Selecting values from Tables with columns of VARCHAR type

From: jAnO! <j.j.groot_at_kpn.com>
Date: 26 Jun 2001 07:18:19 GMT
Message-ID: <01c0fe10$2d2efd80$142b15ac@TONTW0102131521>

Tom Klinger <admin_at_the-piper.net> schreef in artikel <3b373d96$1_at_news.i-one.at>...
> Hi!
>
> Normally not a problem, but for me currently a mysterium.
>
> I have a couple of tables which contain columns with a VARCHAR(2000)
 field.
> Now, selecting from it gives me a number.
> Can anyone help how the heck I can select something from there? From the
> database definition of the vendor a string should be stored there.
>
> Thanks for every help in advance.
>
> Tom
>

Your string is a number...
 selecting goes like this:
select varchar(2000)column from your table; ;-) Received on Tue Jun 26 2001 - 02:18:19 CDT

Original text of this message

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