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

0 vote224 views1 answer
Shrink database file in sql server
SQL
4 votes205 views1 answer
Find tables with column name in sql
SQL
4 votes234 views4 answers
Mysql get date from datetime
SQL
1 vote198 views2 answers
Mysql join two tables
SQL
1 vote226 views2 answers
Mysql add column tinyint default 0
SQL
0 vote228 views1 answer
New rails app with mysql
SQL
0 vote195 views1 answer
Sql orcale i forgot what my name & password was
SQL
0 vote181 views1 answer
Mysql create table columns with spaces
SQL
1 vote207 views1 answer
Media sql
SQL
0 vote223 views3 answers
Condition in count sql
SQL