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 vote226 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
9 votes216 views4 answers
Add primary key to existing table sql
SQL
1 vote231 views1 answer
Raw query must include primary key
SQL
0 vote264 views1 answer
Finding leap year in sql
SQL
0 vote289 views1 answer
Drop view sql
SQL
0 vote192 views1 answer
Mysql timeout 30 seconds
SQL
8 votes220 views2 answers
Phpmyadmin default password
SQL
0 vote219 views1 answer
Drop domain postgresql
SQL
0 vote222 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote243 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL