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 vote185 views1 answer
Oracle date summer time
SQL
0 vote116 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote157 views1 answer
Table values functions in SQL
SQL
0 vote145 views1 answer
Mysql select where text contains
SQL
0 vote180 views1 answer
Alter owner in PostgreSQL
SQL
1 vote173 views1 answer
Mysql view curren querys
SQL
2 votes158 views1 answer
Enum in SQL Server
SQL
3 votes141 views1 answer
Sql select all
SQL
0 vote149 views1 answer
Order by ip address sql
SQL
0 vote288 views1 answer
Generate a random otp in sql server
SQL