# E121-01: DECLARE CURSOR

onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_01_01_01 ( A INT );
DECLARE MYCURSOR CURSOR FOR SELECT A FROM TABLE_E121_01_01_01

onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_01_01_02 ( A INT );
DECLARE MYCURSOR CURSOR FOR SELECT A FROM TABLE_E121_01_01_02 FOR READ ONLY

onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_01_01_03 ( A INT );
DECLARE MYCURSOR CURSOR FOR SELECT A FROM TABLE_E121_01_01_03 FOR UPDATE

onlyif Postgres
statement ok
CREATE TABLE TABLE_E121_01_01_04 ( A INT );
DECLARE MYCURSOR CURSOR FOR SELECT A FROM TABLE_E121_01_01_04 FOR UPDATE OF TABLE_E121_01_01_04
