/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

0 vote201 views2 answers
How to know the character set of an oracle databes
SQL
1 vote314 views1 answer
Alter constraint postgres
SQL
3 votes202 views2 answers
Mysql create timestamp column
SQL
11 votes204 views1 answer
Get ddl materialized view oracle
SQL
5 votes300 views1 answer
Oracle source query
SQL
1 vote201 views1 answer
Postgresql convert text to float
SQL
3 votes201 views1 answer
Select nextval from sequence sql
SQL
0 vote230 views1 answer
Database db connection string format
SQL
0 vote211 views1 answer
Sqlites studio red exclamation mark when poening databse
SQL
0 vote198 views1 answer
Postgresql alter column nullable
SQL

Share