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 vote101 views1 answer
Sql sum if
SQL
-2 votes103 views2 answers
Sqlserver docker
SQL
10 votes92 views1 answer
Oracle dependency
SQL
0 vote114 views1 answer
Min salary in sql
SQL
0 vote108 views1 answer
Oracle exchange subpartition
SQL
2 votes119 views1 answer
Query any digits record
SQL
3 votes128 views1 answer
Force using index oracle
SQL
5 votes121 views1 answer
Purge undo tablespace usage
SQL
1 vote116 views1 answer
Set autoincrement to 0
SQL
1 vote117 views3 answers
How to pass password to mysql command line
SQL