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 vote112 views1 answer
Sql check if column exists
SQL
0 vote64 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote101 views1 answer
How to get n result in sql
SQL
0 vote103 views1 answer
Alter precision
SQL
0 vote103 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote102 views1 answer
Reading from right to left from string find first special characters in sql
SQL
0 vote103 views1 answer
What is metadata in sql
SQL
0 vote101 views1 answer
Change schema of all tables postgres
SQL
6 votes95 views1 answer
Wordpress change user password sql
SQL
0 vote121 views5 answers
Right join
SQL