OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » cursor

Sat, 10 May 2003 04:18

Cindreen Clarence
Messages: 41
Registered: March 2003
Location: Bangalore

Member

Hi all,

Does the 'OPEN <cursor>' statement have a FOR clause which can be used for any purpose other than 'UPDATE' ?

Thanks,
Ciona

Sat, 10 May 2003 06:27

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

Ref cursors are opened like:

OPEN ref_cursor_name FOR SELECT * FROM table_name;

Previous Topic:	Cartesian Product Question
Next Topic:	scrollable cursor in 9i pl/sql

Goto Forum:

]

Current Time: Fri Apr 26 02:11:43 CDT 2024