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 vote112 views1 answer
Acual month sql
SQL
-1 vote121 views1 answer
Count occurrences sql
SQL
0 vote118 views1 answer
TSQL function split string
SQL
8 votes153 views3 answers
Postgres database sizes
SQL
0 vote137 views1 answer
What is default mysql database password in linux
SQL
0 vote218 views1 answer
Sqlite woth cmake
SQL
0 vote120 views1 answer
Declare or use variable in snowflake
SQL
1 vote113 views1 answer
Get table column names sql ssms
SQL
4 votes80 views2 answers
Select todays data postgres query
SQL
1 vote115 views2 answers
Sql where keyword
SQL