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 -> Re: getting ORA-01858 when using INSERT INTO SELECT ... (a non-numeric character was found where a numeric was expected)

Re: getting ORA-01858 when using INSERT INTO SELECT ... (a non-numeric character was found where a numeric was expected)

From: Michael G. Schneider <mgs_at_mgs-software.de>
Date: Sat, 1 Dec 2001 18:24:18 +0100
Message-ID: <9ub316$842$02$1@news.t-online.com>

"Jens Kisters" <j.kisters_at_rosomm-partner.de> schrieb im Newsbeitrag news:9ub2bh$sob$03$2_at_news.t-online.com...

> i have two identical tables.

No, you don't.

> SQL> desc backup_scores;
> WEEK NOT NULL DATE
> NICK NOT NULL
VARCHAR2(30)
> SQL> desc scores;
> NICK NOT NULL
VARCHAR2(30)
> WEEK NOT NULL DATE
Michael G. Schneider Received on Sat Dec 01 2001 - 11:24:18 CST

This message: [ Message body ]
Next message: Bob Hairgrove: "Re: Update based on order"
Previous message: Jens Kisters: "getting ORA-01858 when using INSERT INTO SELECT ... (a non-numeric character was found where a numeric was expected)"
In reply to: Jens Kisters: "getting ORA-01858 when using INSERT INTO SELECT ... (a non-numeric character was found where a numeric was expected)"
Next in thread: Phil Singer: "Re: getting ORA-01858 when using INSERT INTO SELECT ... (a non-numeric character was found where a numeric was expected)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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