RE: SELECT INTO new_table
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <tomday2@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Nov 2005 09:44:00 -0500
Regrettably that only works if your in pl/sql.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Day
Sent: Wednesday, November 23, 2005 9:40 AM
To: oracle-l@xxxxxxxxxxxxx
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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
