1 2 3 4 5 6 7 8 9 10 11 12
|
create table A_Tab_Sauv as
select 1 Id,'a' c1,'a' c2,'a' c3,'a' c4,'a' c5,'a' c6,'a' c7,'a' c8,'a' c9,'a' c10 from dual union
select 2 Id,'b' c1,'b' c2,'b' c3,'b' c4,'b' c5,'b' c6,'b' c7,'b' c8,'b' c9,'b' c10 from dual union
select 3 Id,'c' c1,'c' c2,'c' c3,'c' c4,'c' c5,'c' c6,'c' c7,'c' c8,'c' c9,'c' c10 from dual union
select 4 Id,'d' c1,'d' c2,'d' c3,'d' c4,'d' c5,'d' c6,'d' c7,'d' c8,'d' c9,'d' c10 from dual union
select 5 Id,'e' c1,'e' c2,'e' c3,'e' c4,'e' c5,'e' c6,'e' c7,'e' c8,'e' c9,'e' c10 from dual union
select 6 Id,'f' c1,'f' c2,'f' c3,'f' c4,'f' c5,'f' c6,'f' c7,'f' c8,'f' c9,'f' c10 from dual union
select 7 Id,'g' c1,'g' c2,'g' c3,'g' c4,'g' c5,'g' c6,'g' c7,'g' c8,'g' c9,'g' c10 from dual union
select 8 Id,'h' c1,'h' c2,'h' c3,'h' c4,'h' c5,'h' c6,'h' c7,'h' c8,'h' c9,'h' c10 from dual union
select 9 Id,'i' c1,'i' c2,'i' c3,'i' c4,'i' c5,'i' c6,'i' c7,'i' c8,'i' c9,'i' c10 from dual union
select 10 Id,'j' c1,'j' c2,'j' c3,'j' c4,'j' c5,'j' c6,'j' c7,'j' c8,'j' c9,'j' c10 from dual; |
Partager