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;
exec dbms_output.enable(1000000);
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);
No comments:
Post a Comment