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

Home -> Community -> Usenet -> c.d.o.misc -> HELP: Assigning a high-length VARCHAR2 to a low-length one

HELP: Assigning a high-length VARCHAR2 to a low-length one

From: Peder <peder.pedersen_at_fillmbyen.com>
Date: Tue, 18 Jan 2000 11:05:48 +0100
Message-ID: <861dsa$o2p$1@news1.tele.dk>


Hello,

    Could anyone please help me with a small problem:

I need to assign v1 to v2, where v1 is VARCHAR2 with a greater length than v2. Is this possible? An error is raised when I attempt.

If this is not possible, is there a way to extract the n leading characters of a VARCHAR2 string?

Thanks in advance,

Peder Received on Tue Jan 18 2000 - 04:05:48 CST

Original text of this message

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