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

0 vote158 views1 answer
Command line mysql xampp
SQL
0 vote155 views1 answer
Sql cmd no truncate
SQL
0 vote132 views1 answer
Formatting code with SQL Developer
SQL
2 votes155 views3 answers
Current setting postgres timezone
SQL
0 vote151 views1 answer
Typical max-connect-errors mysql
SQL
5 votes135 views4 answers
Rollback to in sql
SQL
0 vote140 views1 answer
Max mysql
SQL
0 vote117 views2 answers
Postgresql display subquery as json
SQL
9 votes130 views2 answers
Default number in sql
SQL
20 votes140 views6 answers
Change password in mysql
SQL