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

9 votes259 views2 answers
Convert data type in sql
SQL
1 vote260 views2 answers
Sql multiline comment
SQL
2 votes261 views1 answer
Sql ends with string
SQL
0 vote258 views1 answer
Sql server select furst day of current year
SQL
0 vote256 views2 answers
Csv into data postgres
SQL
0 vote254 views1 answer
What is default mysql database password in linux
SQL
0 vote261 views2 answers
Mysql on update current_timestamp
SQL
0 vote252 views3 answers
Sql all columns
SQL
3 votes275 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote264 views1 answer
Enable sql server full text indexing
SQL