Cycle to import the same SQL statement, or is it? How to implement, had better have the code, thank you

CodePudding user response:

Table name is contained in the age sex address four classes

CodePudding user response:

What kind of? Is listed, the select level from dual connect by level & lt;=10000; Need what columns definition

CodePudding user response:

The create table t (c1 int, c2 varchar2 (10));

The begin
For I in 1.. 10000 loop
Insert into t values (1, "aa");
End loop;
end;

CodePudding user response:

If you need to import the data table name is A
Then give A table manually write A data,
Then an INSERT INTO A SELECT * FROM A;
Didn't do a, you will get twice as much data,
If some fields need to be rewritten, can to replace * with corresponding values,

CodePudding user response:

Insert into a select name, age, sex, address the from b;