Database Administration (MOSC)

MOSC Banner

ORA-01858 when INSERT

edited Jul 10, 2014 2:47AM in Database Administration (MOSC) 6 commentsAnswered ✓

Hi all,

in 12 C on Win 2008

This INSERT works :

INSERT INTO Ticker (TSTAMP) VALUES ('02/04/11');

But when try to run following I have

INSERT INTO Ticker  VALUES('ACME',TO_DATE('02-Apr-11','dd/mm/yy'),17);

ORA-01858 -  "a non-numeric character was found where a numeric was expected"

Thanks for help.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center