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

2 votes130 views1 answer
Select * from table where name like
SQL
0 vote144 views1 answer
Query to remove duplicate rows from a table
SQL
3 votes126 views1 answer
Uppercase and lowercase in sql
SQL
20 votes127 views2 answers
Counting in sql
SQL
34 votes126 views5 answers
Oracle alter table add column
SQL
0 vote146 views1 answer
Is not numeric sql
SQL
0 vote142 views1 answer
Connect by query in oracle
SQL
2 votes142 views2 answers
Create empty table from existing table
SQL
0 vote167 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
12 votes136 views4 answers
Mysql version query
SQL