/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 vote130 views1 answer
Liquibase alter column type / length
SQL
0 vote115 views2 answers
Add colum in sql
SQL
1 vote121 views5 answers
Postgresql difference between two dates in days
SQL
-2 votes169 views1 answer
Trunc in sql
SQL
4 votes125 views1 answer
Id increment ms sql server
SQL
6 votes129 views2 answers
Where clause in sql
SQL
31 votes120 views3 answers
Sql count(*)
SQL
0 vote121 views1 answer
SQL Server Enterprise
SQL
1 vote111 views3 answers
Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails
SQL
3 votes120 views2 answers
Truncate all tables
SQL

Share