SQL Language (MOSC)

MOSC Banner

Unable to insert data

Dears,

I have two tables as below. When I try to insert data of 'WEBDATA_MARINE_TIDE_STG_SOURCE' to 'WEBDATA_MARINE_TIDE_STG_DEST' getting below error

SQL> desc WEBDATA_MARINE_TIDE_STG_SOURCE

 Name                                                       Null?  Type

 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------

 Total_rainfall_observed                                                  VARCHAR2(10)


SQL> desc WEBDATA_MARINE_TIDE_STG_DEST

 Name                                                       Null?  Type

 ----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------

 RAIN_TOTAL                                                         NUMBER


SQL> insert into WEBDATA_MARINE_TIDE_STG_DEST select "Total_rainfall_observed" from WEBDATA_MARINE_TIDE_STG_source;

 insert into WEBDATA_MARINE_TIDE_STG_DEST select "Total_rainfall_observed" from WEBDATA_MARINE_TIDE_STG_source

                         *

ERROR at line 1:

ORA-01722: invalid number

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