Hello,
I would like to train some functions like ASCII, DECODE, or some convert functions.
When it is a very little test I can use a new Command Window and enter f.e. SELECT ASCII('c') FROM dual; to get the answer.
But how can I do it, when I want to test some loops with DBMS_OUPUT.Put_line or some a bit complicated expression?
Can I enter a code block with BEGIN...END?
How do you test a stand-alone function with outputs in a scrap?
Thanks a lot in advance for your help
frenchcancan