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

-1 vote287 views1 answer
Search all database tables for a value sqlserver
SQL
1 vote297 views1 answer
Mysql how to truncate table with foreign keys
SQL
3 votes311 views5 answers
Duplicate table sql
SQL
1 vote285 views1 answer
Operator does not exist: integer = text
SQL
24 votes270 views5 answers
Sql reset auto increment
SQL
0 vote276 views1 answer
Select only one row sql
SQL
29 votes286 views5 answers
Mysql show table structure
SQL
2 votes274 views2 answers
Laravel query builder toSql
SQL
0 vote283 views1 answer
Mariadb number format
SQL
3 votes335 views1 answer
Mysql group_concat distinct
SQL