Pl sql

# just don't do it

Print in pl sql

dbms_output.put_line("YOUR MESSAGE");

PL/SQL

DECLARE
TYPE <type_name> IS RECORD
(
<columnl> <datatype>,
);
BEGIN
<execution_section>;
END;

Source: guru99.com

Pl sql example

DECLARE
  CURSOR cursor_person IS
    SELECT person_code FROM people_table;
BEGIN
  FOR RecordIndex IN cursor_person
  LOOP
    DBMS_OUTPUT.PUT_LINE(recordIndex.person_code);
  END LOOP;
END;

Source: en.wikipedia.org

Similar codes

2 votes173 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
0 vote135 views1 answer
VSCode SQL Server Connection error
SQL
0 vote151 views1 answer
Compare two tables to find unmatched records
SQL
5 votes137 views2 answers
Sql number columns
SQL
0 vote139 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
8 votes146 views1 answer
Oracle add auto_increment column to existing table
SQL
12 votes133 views2 answers
Delete all data in neo4j
SQL
0 vote143 views1 answer
Code to move ietms from one table to another myswl
SQL
2 votes186 views1 answer
Show max_allowed_packet mysql
SQL
25 votes158 views4 answers
Metadata
SQL