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 vote171 views2 answers
Collation in sql
SQL
2 votes151 views1 answer
Plsql left() function
SQL
0 vote111 views1 answer
How to set field to null in sql
SQL
0 vote153 views1 answer
Suse start MySQL
SQL
1 vote198 views1 answer
Base64 encode sql server
SQL
0 vote170 views3 answers
Insert query in ci
SQL
0 vote152 views1 answer
Oracle index hint
SQL
0 vote154 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote182 views1 answer
Query to insert image
SQL
0 vote144 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL