I have the data in the following form:
10334,99.4,4241 14354,99.5,6018 16807,93.9,2279 22042,97.5,70341 22117,96.4,70335 22138,95.7,70332 23869,94.4,135649 23937,97.5,135642 23982,96.6,135638 24055,95.7,135628 24119,98.7,135624 25803,96.5,135597 25852,98.8,135592
I can shape it other way, e.g. make it separated with spaces instead of commas — this output is produced by some Linux shell pipeline, in which last is
I want sqlplus to interpret each line as a separate record to put into temporary table, which I then will be using in a quite simple join within a script.
I expect sqlplus to be able to parse whatever is put into its stdin, is it possible? Or make such data accessible in some other way. There will be typically no more than 30 records. The script must create a table and fill it with such input. How to do that?