RE: SELECT INTO new_table

Regrettably that only works if your in pl/sql.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Day Sent: Wednesday, November 23, 2005 9:40 AM To: oracle-l_at_freelists.org
Subject: Re: SELECT INTO new_table

Did I miss something?

Wouldn't this be the perfect place for a PL/SQL cursor?

Create cursor mytem as select * from table;

Very dynamic. Nothing static about it at all.

There are many ways to skin the cat. People should use what they're comfortable with. Though some methods do, in fact, work better than others.
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 23 2005 - 08:46:28 CST