SQL Navigator 4 Simple question.
Here it is:
I try to show a simple string in the output window. so i use this:
dbms_output.put_line('Hell
when I run I get an error.
Please help me to find out what to do about this.
or if this not the correct way then how can I show 'hello world" in the output window???
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>Can you explain Server output? what happen if you set it to on and off?
Check https://www.experts-exchange.com/questions/21061102/SQL-PLUS-Server-Output-Buffer.html
Check https://www.experts-exchange.com/questions/21061102/SQL-PLUS-Server-Output-Buffer.html
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank's all for bearing with me.
I'm increasing point to 300 and split the points.
I'm increasing point to 300 and split the points.
ASKER
Please explain:
<<I believe you are writing this in SQL Editor Window.>>
Where else could I wirte the code?
<<You are supposed to be writing the SQL or PL/SQL statements there.>>
isn't
dbms_output.put_line('Hell
is any pl/sql code?
<<you will have to click on 'Server Output' >>
Can you explain Server output? what happen if you set it to on and off?