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

Home -> Community -> Usenet -> c.d.o.server -> Converting from VARCHAR2 to CHAR in a view (7.1)

Converting from VARCHAR2 to CHAR in a view (7.1)

From: Igor Milavec <igor.milavec_at_l-sol.si>
Date: 1998/02/19
Message-ID: <6choce$nmp$1@amon.siol.net>#1/1

Hi.

I'm trying to create a view which converts from a VARCHAR2 column to a CHAR. I tried to use the following:
CREATE VIEW "VContact" AS
SELECT TO_CHAR(Description, 'SSSSS')
FROM "Contact"

however ORACLE 7.1 reports:
ERROR:
ORA-01722: invalid number

no rows selected

when I try to select from this view. Can someone please help me out with this one?

Regards,

              Igor Received on Thu Feb 19 1998 - 00:00:00 CST

Original text of this message

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