I need to enter multiple values ??in a column type
Insert Into table (field) Values ??(here I have several numbers to insert)
What happens I put all like this
('numbers', 'numbers') and he returned Toot Many Large
How can I vessel this insert of various values ??in a column?
insert
-
- Rank: DBA Júnior
- Posts: 193
- Joined: Thu, 24 Jan 2008 1:56 pm
- Location: SP
Dulima
DBA Oracle Jr
DBA Oracle Jr
I do not know ....
I do not know if it is possible ....
for what I understand you want to insert into a column several values ??.... Masi wants these Fields are in different columns ......
I find it impossible ....
What is the real purpose, maybe I can Help in another way !! 1
I do not know if it is possible ....
for what I understand you want to insert into a column several values ??.... Masi wants these Fields are in different columns ......
I find it impossible ....
What is the real purpose, maybe I can Help in another way !! 1
From what I am seeing you need to give several inserts one for each number that you want ...
For example you can insert all values ??in a vector hence to give a loop in the vector giving the insert in the table.
Now insert several records at one time I do not know.
unless these numbers you want to insert return from a SELECT
Ex:
In this case yes will insert the number of Records that return from SELECT.
For example you can insert all values ??in a vector hence to give a loop in the vector giving the insert in the table.
Now insert several records at one time I do not know.
unless these numbers you want to insert return from a SELECT
Ex:
INSERT INTO TABELA1 (CD_CODIGO) SELECT CD_NUMEROS FROM TABELA2
There is the command
and the select values ??must be required of the same type as the table you will enter. But this is the case you have this data on a table. What happened to me was having to insert 20000 records from a table in Excel.
Here is my solution:
I copied to a txt the values, I created a Java program to read the txt and the values ??of each line formed a simple insert , writing on another TXT. After this is just sending the generated script (the 20000 inserts), I used the toad to run the script, but you can use Sqlloader
http://www.orafaq.com/wiki/SQL*Loader_FAQ at that address explains how to use.
INSERT INTO T1(a1,a2) SELECT a1, a2 FROM T2
and the select values ??must be required of the same type as the table you will enter. But this is the case you have this data on a table. What happened to me was having to insert 20000 records from a table in Excel.
Here is my solution:
I copied to a txt the values, I created a Java program to read the txt and the values ??of each line formed a simple insert , writing on another TXT. After this is just sending the generated script (the 20000 inserts), I used the toad to run the script, but you can use Sqlloader
http://www.orafaq.com/wiki/SQL*Loader_FAQ at that address explains how to use.
-
- Information
-
Who is online
Users browsing this forum: No registered users and 7 guests