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

-2 votes136 views1 answer
Modify column name in tsql
SQL
11 votes204 views2 answers
Sql between date range
SQL
21 votes158 views6 answers
Update sql
SQL
7 votes120 views3 answers
How ot change name of column mysql
SQL
0 vote120 views3 answers
Get free card roblox
SQL
0 vote132 views1 answer
Oracle date winter time
SQL
28 votes94 views6 answers
Distinct sql
SQL
11 votes203 views1 answer
Oracle insert from select
SQL
0 vote129 views1 answer
Typeorm raw sql
SQL
3 votes128 views2 answers
WhereIn SQL
SQL