Member Avatar for Azii

Hello,

I am Inserting the data into table1 where c1 is new column and data is from table2.
but c2 data type is varchar2 and c1 datatype is Number format.

`

INSERT INTO table1 (to_number(USER_ID))
SELECT EMP_ID FROM table2
WHERE USER_NAME IN (SELECT UNAME FROM table1);

HereUSER_NAME` column is from table2.

Thank you.

  • 2 Contributors
  • 1 Reply
  • 93 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by zinist
Member Avatar for zinist

Hi,
what error you are getting?
please be more specific with your problem.
Thanks

Edited by zinist
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.