Unregister to multiple columns with multiple names and unregister to multiple columns
-- Oracle syntax
Create table T5 (idnum NUMBER, f1 NUMBER (10, 5), f2 NUMBER (10, 5), f3 NUMBER (10, 5), e1 NUMBER (10, 5), e2 NUMBER (10, 5 ), h1 NUMBER (10, 5), h2 NUMBER (10, 5); insert into T5 (IDNUM, F1, F2, F3, E1, E2, H1, H2) VALUES (1, '10. 2004 ', '5. 009', '7. 330 ', '9. 008 ', '8. 003 ','. 99383 ', '1. 43243 '); insert into T5 (IDNUM, F1, F2, F3, E1, E2, H1, H2) VALUES (2, '4. 2004 ', '6. 009', '9. 330 ', '4. 7008 ', '4. 60333 ', '1. 993 ', '3. 3243 '); insert into T5 (IDNUM, F1, F2, F3, E1, E2, H1, H2) VALUES (3, '10. 2040 ', '52. 6009 ', '67. 330 ', '9. 5008 ', '8. 003 ','. 99383 ', '1. 43243 '); insert into T5 (IDNUM, F1, F2, F3, E1, E2, H1, H2) VALUES (4, '9. 20704 ', '45. 009', '17. 330 ', '29. 008 ',' 5. 003 ',' 3. 9583 ', '1. 243 '); COMMIT; select * from (select IDNUM, F1, F2, F3, E1, E2, H1, H2, null as E3, null as H3 from T5) unregister (F, E, H) for sk in (F1, E1, H1) as 1, (F2, E2, H2) as 2, (F3, E3, H3) as 3) order by IDNUM, SK;