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

17 votes131 views4 answers
Show tables sql server
SQL
8 votes136 views1 answer
Sql limit results returned
SQL
5 votes142 views1 answer
Commentaire table oracle
SQL
0 vote155 views1 answer
On delete set default
SQL
0 vote137 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
1 vote161 views1 answer
Psql search table
SQL
0 vote138 views1 answer
Like and not like together in sql
SQL
4 votes135 views1 answer
Restart for pg_hba.conf file
SQL
3 votes130 views1 answer
How to remove characters from string in mysql
SQL
0 vote145 views1 answer
Ansi sql count duplicate rows
SQL