Once I get results from a SQL statement in TOAD 10, is there a way to save it to
a new Oracle Table?
If not, that could be a cool new feature on the right-click menu….
Jerry
Once I get results from a SQL statement in TOAD 10, is there a way to save it to
a new Oracle Table?
If not, that could be a cool new feature on the right-click menu….
Jerry
Just type in ‘create table as’
Before your select statement, and then run it.
This is a very common thing. There is even an acronym for it CTAS (Create Table
As Select).
You might go a little further and specify
CREATE TABLE xyz
tablespace abc
as
SELECT ……….