Print text in Oracle SQL Developer SQL Worksheet window
OraclePrintingOracle SqldeveloperOracle Problem Overview
I am using Oracle SQL (in SQLDeveloper, using the SQL Worksheet). I would like to print a statement before my select, such as
PRINT 'Querying Table1';
SELECT * from Table1;
What do I use to Print / show text output? It's not Print, because that gives me the error: Bind Variable Table1
is NOT DECLARED. DBMS_OUTPUT.PUT_LINE is an unknown command. (Obviously, I'm an inexperienced SQLDeveloper and Oracle user. There must be some synonym for Print, but I'm having trouble finding help on it without knowing what it is.)
Oracle Solutions
Solution 1 - Oracle
for simple comments:
set serveroutput on format wrapped;
begin
DBMS_OUTPUT.put_line('simple comment');
end;
/
-- do something
begin
DBMS_OUTPUT.put_line('second simple comment');
end;
/
you should get:
anonymous block completed
simple comment
anonymous block completed
second simple comment
if you want to print out the results of variables, here's another example:
set serveroutput on format wrapped;
declare
a_comment VARCHAR2(200) :='first comment';
begin
DBMS_OUTPUT.put_line(a_comment);
end;
/
-- do something
declare
a_comment VARCHAR2(200) :='comment';
begin
DBMS_OUTPUT.put_line(a_comment || 2);
end;
your output should be:
anonymous block completed
first comment
anonymous block completed
comment2
Solution 2 - Oracle
PROMPT text to print
Note: must use Run as Script (F5) not Run Statement (Ctl + Enter)
Solution 3 - Oracle
You could set echo to on:
set echo on
REM Querying table
select * from dual;
In SQLDeveloper, hit F5 to run as a script.
Solution 4 - Oracle
The main answer left out a step for new installs where one has to open up the dbms output window.
Then the script I used:
dbms_output.put_line('Start');
Another script:
set serveroutput on format wrapped;
begin
DBMS_OUTPUT.put_line('jabberwocky');
end;
Solution 5 - Oracle
You could put your text in a select statement such as...
SELECT 'Querying Table1' FROM dual;
Solution 6 - Oracle
For me, I could only get it to work with
set serveroutput on format word_wrapped;
The wraped and WRAPPED just threw errors: SQLPLUS command failed - not enough arguments
Solution 7 - Oracle
If I ommit begin - end it is error. So for me this is working (nothing else needed):
set serveroutput on;
begin
DBMS_OUTPUT.PUT_LINE('testing');
end;
Solution 8 - Oracle
If you don't want all of your SQL statements to be echoed, but you only want to see the easily identifiable results of your script, do it this way:
> set echo on > > REM MyFirstTable > > set echo off > > delete from MyFirstTable; > > set echo on > > REM MySecondTable > > set echo off > > delete from MySecondTable;
The output from the above example will look something like this:
> -REM MyFirstTable > > 13 rows deleted. > > -REM MySecondTable > > 27 rows deleted.