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 vote138 views1 answer
Sql max of two values
SQL
0 vote126 views1 answer
Add alternate add column sql
SQL
0 vote123 views1 answer
Assign value to var in SQL
SQL
0 vote143 views1 answer
Postgresql inheritance
SQL
1 vote126 views1 answer
Random name function in mysql for nvarchar
SQL
34 votes161 views6 answers
Alter table add foreign key mysql
SQL
8 votes91 views1 answer
Similarities between ddl and dml
SQL
0 vote126 views1 answer
Asp.net core sql server stored procedure
SQL
2 votes136 views1 answer
Postgresql create schema in specific database
SQL
21 votes132 views4 answers
Add column mssql
SQL