Insert into table1 b. select * from table2, b (select count (1) the from CNT table1where num=00010 and rownum<2) where a a. CNT=0;
Like a SQL is what mean?

CodePudding user response:

From the statement:

If a table in the table1, there is no num=00010 records, data in table2, full insertion into the table1,

CodePudding user response:

In a written, see if you can read it,
Insert into table1 select * from b. table2 b where the exists (select 0 CNT from table1 where num=00010).

CodePudding user response:

refer to the second floor AHUA1001 response:

in a writing, see if you can read it,
Insert into table1 select * from b. table2 b where the exists (select 0 CNT from table1 where num=00010).

Seems to be not the exists,,