Printing the value of a variable in SQL Developer

by

You need to turn on dbms_output.
In Oracle SQL Developer:

  1. Show the DBMS Output window (View->DBMS Output).
  2. Press the “+” button at the top of the Dbms Output window and then select an open database connection in the dialog that opens.

In SQL*Plus:

 SET SERVEROUTPUT ON

More Related Contents:

  1. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  2. Place to store PL/SQL block [closed]
  3. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  4. How can I set a custom date time format in Oracle SQL Developer?
  5. Get counts of all tables in a schema
  6. How to export query result to csv in Oracle SQL Developer?
  7. PL/SQL, how to escape single quote in a string?
  8. PL/SQL – Use “List” Variable in Where In Clause
  9. Passing an array of data as an input parameter to an Oracle procedure
  10. Convert comma separated string to array in PL/SQL
  11. UTL_FILE.FOPEN() procedure not accepting path for directory?
  12. Oracle stored procedure with parameters for IN clause
  13. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  14. NLS_NUMERIC_CHARACTERS setting for decimal
  15. Split function in oracle to comma separated values with automatic sequence
  16. check if “it’s a number” function in Oracle
  17. ORA-06508: PL/SQL: could not find program unit being called
  18. How to send email using Oracle 10 g Forms
  19. SQL*Plus how to accept text variable from prompt?
  20. SQL Fiddle Output Error
  21. oracle PL/SQL how to calculate range ip for IPv6 cidr
  22. if (select count(column) from table) > 0 then
  23. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  24. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  25. Oracle: how to INSERT if a row doesn’t exist
  26. Functions vs procedures in Oracle
  27. BEGIN – END block atomic transactions in PL/SQL
  28. automating rollback script oracle
  29. How do I get column datatype in Oracle with PL-SQL with low privileges?
  30. Escaping single quote in PLSQL

Leave a Comment