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 vote209 views1 answer
Postgress append string in select
SQL
5 votes229 views1 answer
AND OR NOT operators sql
SQL
0 vote188 views1 answer
Is numeric in sql
SQL
2 votes242 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote392 views1 answer
Multiple row join
SQL
6 votes190 views2 answers
How to copy data in sql
SQL
0 vote263 views1 answer
Which lock mode is not available in sql
SQL
0 vote206 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote210 views1 answer
Drop unique
SQL
1 vote212 views1 answer
Sql select where id not exists in another table
SQL