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

1 vote205 views2 answers
Oracle replace
SQL
0 vote221 views2 answers
Add colum in sql
SQL
0 vote215 views1 answer
How to add mysql to path on termin after installation
SQL
1 vote199 views1 answer
Set all the vluses in calumn in sql to false
SQL
0 vote212 views1 answer
Sql query tags
SQL
7 votes217 views2 answers
Mysql get year from date
SQL
1 vote226 views1 answer
Sql server if exists update else insert
SQL
1 vote229 views1 answer
Mysql take number in string
SQL
0 vote205 views1 answer
Sql server system messeges
SQL
34 votes202 views6 answers
Install mysql client ubuntu
SQL