Paste this into a new question or an answer at dba.stackexchange.com:
<!-- --> > create table foo(id integer); > > <pre> > ✓ > </pre> <!-- --> > select 'a' from dual; > > <pre> > | 'A' | > | :-- | > | a | > </pre> <!-- --> > begin > dbms_output.put_line('Hi'); > dbms_output.put_line('there'); > end; > / > > <pre> 1 rows affected dbms_output: Hi there > </pre> <!-- --> > begin > dbms_output.put_line('more'); > end; > / > > <pre> 1 rows affected dbms_output: more > </pre> *db<>fiddle [here](https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=43277f27527dab8eab96de86823a1ecb)*
back to fiddle