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 vote366 views1 answer
Mysql server not starting in xampp in mac
SQL
3 votes398 views1 answer
Select count from table mysql
SQL
4 votes352 views1 answer
Add constraint fk
SQL
0 vote361 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote361 views1 answer
Sparql if bound query
SQL
0 vote363 views1 answer
DATEDIFF minute postgres
SQL
0 vote391 views1 answer
Bigrock database connection string
SQL
0 vote418 views1 answer
Wordpress make wp user in db
SQL
0 vote357 views1 answer
Django how to get query result count
SQL
2 votes353 views1 answer
How to insert string variable into sqlite database
SQL