Not exactly sure what you mean by that.... You can do: Select dummy, cursor(select dummy from dual) from dual; But, that's probably not what you're trying to do....or maybe it is..... Please provide a more descriptive example of what it is you're trying to achieve....? -Mark -- Mark J. Bobak Senior Oracle Architect ProQuest Information & Learning For a successful technology, reality must take precedence over public relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bob Robert Sent: Monday, April 17, 2006 8:04 PM To: oracle-l@xxxxxxxxxxxxx Subject: cursor in side cursor Gurus, Is it posssible to write cursor in side of another cursor? Thanks, Bob __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l