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 vote343 views1 answer
Query on date sqlite flutter
SQL
3 votes345 views2 answers
How to start postgresql on windows
SQL
0 vote353 views1 answer
Sql server separar numeros por comas miles
SQL
1 vote329 views1 answer
Increase date by one day in sql oracle
SQL
0 vote324 views1 answer
Sql select rows between 1000 and 2000
SQL
8 votes302 views8 answers
Second highest salary in mysql
SQL
1 vote342 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote386 views1 answer
How to print sql query
SQL
0 vote366 views1 answer
Oracle locked objects
SQL
0 vote366 views1 answer
Insert set mysql
SQL