Toad World® Forums

Table From Data Grid (results)


#1

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


#2

Just type in ‘create table as’

Before your select statement, and then run it.


#3

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 ……….
image001.jpeg