MO
с connect by работает действительно, а с union all нет
SQL> CREATE SEQUENCE t1_seq;
Sequence created.
SQL> CREATE TABLE t1 (
2 id NUMBER DEFAULT t1_seq.NEXTVAL primary key,
3 description VARCHAR2(30)
4 );
Table created.
SQL> insert into t1(description)
2 select * from (select 'desc' FROM DUAL union all select 'sesc' from dual);
2 rows created.
SQL> select * from t1;
ID DESCRIPTION
---------- -------------------------------------
1 desc
2 sesc
2 rows selected.
