SELECT
  CASE
    WHEN level = 1
    THEN '01'
    WHEN level = 2
    THEN '02'
    WHEN level = 3
    THEN '04'
    WHEN level = 4
    THEN '05'
  END TEST
FROM dual
  CONNECT BY level <= 4;

How to increase dbms_output buffer?

 

dbms_output.enable(buffer_size IN INTEGER DEFAULT 20000);
exec dbms_output.enable(1000000);

ODI Creating Projects and Models 03:

https://www.youtube.com/watch?v=kR8zjsT35AU

Topology Dataserver, Physical and Logical Schema creation in ODI www.oditraining.com

https://www.youtube.com/watch?v=ejtgeygPgV4

Creating Master Repository Wizard ::

http://dwteam.in/creating-repositories-in-odi-11-1-1-5/