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

17 votes340 views4 answers
Postgres list users
SQL
0 vote321 views1 answer
Mysql docker image arjun
SQL
0 vote343 views1 answer
Insert data from stored procedure into table
SQL
0 vote301 views1 answer
Mariadb LOAD DATA INFILE
SQL
13 votes325 views2 answers
Sql count distinct group by
SQL
1 vote312 views1 answer
Stop mysql server mac
SQL
0 vote344 views1 answer
Postgres regex word boundary
SQL
0 vote276 views1 answer
Oracle function select into
SQL
0 vote322 views1 answer
Mysql two joins
SQL
5 votes350 views6 answers
In operator sql
SQL