/SQL/DBMS_OUTPUT.PUT_LINE

DBMS_OUTPUT.PUT_LINE

Print in pl sql

dbms_output.put_line("YOUR MESSAGE");

3

DBMS_OUTPUT.PUT_LINE

set serveroutput on

DBMS_OUTPUT.PUT_LINE(v_variable || '-' || v_variable2);

2

Plsql print

-- EXAMPLE
SET SERVEROUTPUT ON;
BEGIN
DBMS_OUTPUT.PUT_LINE('This is printed. '||'This is concatenated and printed too!');
END;
/

0

Similar codes

1 vote134 views1 answer
Return size of tables in mysql
SQL
0 vote125 views1 answer
Date datatype in livesql
SQL
6 votes131 views3 answers
Oracle all dates between two dates
SQL
5 votes147 views1 answer
Oracle columns in all_tables
SQL
0 vote177 views1 answer
Oracle show running job
SQL
10 votes125 views1 answer
Query to find object dependencies in oracle
SQL
3 votes131 views1 answer
Postgresql db owner change
SQL
0 vote131 views1 answer
SQL Server rename foreign key constraint
SQL
2 votes126 views1 answer
Anonymous block plsql
SQL
0 vote127 views1 answer
Mysql drop multiple tables at once
SQL

Share