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 vote145 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
3 votes181 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote135 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
2 votes151 views1 answer
Metasploit start postgresql
SQL
5 votes118 views1 answer
Alter table default value mysql
SQL
0 vote105 views1 answer
Print sum of values sql
SQL
3 votes170 views1 answer
Define REGEXP?
SQL
1 vote135 views1 answer
Error code 1175 mysql fix
SQL
1 vote159 views1 answer
Float precision in psql
SQL
4 votes162 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL