Pl sql example

Pl sql

# just don't do it

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

1 vote229 views1 answer
Apex run 404
SQL
0 vote192 views1 answer
Create table sql generator
SQL
0 vote215 views1 answer
Datagrip execute procedure
SQL
0 vote176 views1 answer
Get who is hired in month in sql
SQL
0 vote226 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
0 vote206 views1 answer
Search from comma separated values in sql server
SQL
2 votes197 views1 answer
Mysql last 7 days including today
SQL
0 vote189 views1 answer
Sqlalchemy query sql compiled
SQL
11 votes298 views2 answers
Sql between date range
SQL
3 votes181 views1 answer
Difference sql vs mysql
SQL