Re: INSERT INTO SELECT * column error in SQL code
> SQL won't parse row data into the sixteen columns
SQL has no psychic abilities, has to be told exactly what each column value is.
In your dta string it appears tht each column value is delimited by a semicolon. If that's so and if there are multiple such strings, you might find it convenient to use Load Data Infile to import the data, see the manual page for that cmd.
Edited 1 time(s). Last edit at 11/24/2018 07:18PM by Peter Brawley.
Subject
Written By
Posted
November 24, 2018 04:34PM
Re: INSERT INTO SELECT * column error in SQL code
November 24, 2018 07:18PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.