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

4 votes213 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote179 views1 answer
SQL Server Enterprise
SQL
0 vote161 views1 answer
Postgresql regular expression special characters
SQL
0 vote181 views1 answer
Oracle sql count occurrences of value in column
SQL
1 vote176 views1 answer
Psql connect
SQL
0 vote166 views1 answer
Deny select insert update delete sql
SQL
0 vote170 views1 answer
Google sheets filter rows above current cell
SQL
5 votes172 views1 answer
JBDC
SQL
1 vote181 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote179 views1 answer
Custom row number
SQL