I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in Access:

SELECT * INTO PROJNEW FROM PROJECT WHERE PROJNUM > 24999

will create a new table named PROJNEW populated with the filtered records. What I like about Access's way of doing it (besides that it is a single step) is that the new table's columns are defined for me automatically according to what they are in the source table(s).

How can I accomplish that in PL/SQL with as few statements as possible? Thanks

"Bernie Bernbaum" <somebody (AT) somedomain (DOT) not> wrote

I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in Access:

SELECT * INTO PROJNEW FROM PROJECT WHERE PROJNUM > 24999

will create a new table named PROJNEW populated with the filtered records. What I like about Access's way of doing it (besides that it is a single step) is that the new table's columns are defined for me automatically according to what they are in the source table(s).

How can I accomplish that in PL/SQL with as few statements as possible? Thanks


create table PROJNEW
as select * FROM PROJECT WHERE PROJNUM > 24999

--
Terry Dykstra

"Bernie Bernbaum" <somebody (AT) somedomain (DOT) not> wrote

I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in Access:

SELECT * INTO PROJNEW FROM PROJECT WHERE PROJNUM > 24999

will create a new table named PROJNEW populated with the filtered records. What I like about Access's way of doing it (besides that it is a single step) is that the new table's columns are defined for me automatically according to what they are in the source table(s).

How can I accomplish that in PL/SQL with as few statements as possible? Thanks


create table PROJNEW
as select * FROM PROJECT WHERE PROJNUM > 24999

--
Terry Dykstra

"Bernie Bernbaum" <somebody (AT) somedomain (DOT) not> wrote

I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in Access:

SELECT * INTO PROJNEW FROM PROJECT WHERE PROJNUM > 24999

will create a new table named PROJNEW populated with the filtered records. What I like about Access's way of doing it (besides that it is a single step) is that the new table's columns are defined for me automatically according to what they are in the source table(s).

How can I accomplish that in PL/SQL with as few statements as possible? Thanks


create table PROJNEW
as select * FROM PROJECT WHERE PROJNUM > 24999

--
Terry Dykstra

"Bernie Bernbaum" <somebody (AT) somedomain (DOT) not> wrote

I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in Access:

SELECT * INTO PROJNEW FROM PROJECT WHERE PROJNUM > 24999

will create a new table named PROJNEW populated with the filtered records. What I like about Access's way of doing it (besides that it is a single step) is that the new table's columns are defined for me automatically according to what they are in the source table(s).

How can I accomplish that in PL/SQL with as few statements as possible? Thanks


create table PROJNEW
as select * FROM PROJECT WHERE PROJNUM > 24999

--
Terry Dykstra

"Terry Dykstra" <tddykstra (AT) forestoil (DOT) ca> wrote

"Bernie Bernbaum" <somebody (AT) somedomain (DOT) not> wrote

I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in Access:

SELECT * INTO PROJNEW FROM PROJECT WHERE PROJNUM > 24999

will create a new table named PROJNEW populated with the filtered records. What I like about Access's way of doing it (besides that it is a single step) is that the new table's columns are defined for me automatically according to what they are in the source table(s).

How can I accomplish that in PL/SQL with as few statements as possible? Thanks


create table PROJNEW
as select * FROM PROJECT WHERE PROJNUM > 24999

--
Terry Dykstra
That did it, thanks Terry!

"Terry Dykstra" <tddykstra (AT) forestoil (DOT) ca> wrote

"Bernie Bernbaum" <somebody (AT) somedomain (DOT) not> wrote

I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in Access:

SELECT * INTO PROJNEW FROM PROJECT WHERE PROJNUM > 24999

will create a new table named PROJNEW populated with the filtered records. What I like about Access's way of doing it (besides that it is a single step) is that the new table's columns are defined for me automatically according to what they are in the source table(s).

How can I accomplish that in PL/SQL with as few statements as possible? Thanks


create table PROJNEW
as select * FROM PROJECT WHERE PROJNUM > 24999

--
Terry Dykstra
That did it, thanks Terry!

"Terry Dykstra" <tddykstra (AT) forestoil (DOT) ca> wrote

"Bernie Bernbaum" <somebody (AT) somedomain (DOT) not> wrote

I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in Access:

SELECT * INTO PROJNEW FROM PROJECT WHERE PROJNUM > 24999

will create a new table named PROJNEW populated with the filtered records. What I like about Access's way of doing it (besides that it is a single step) is that the new table's columns are defined for me automatically according to what they are in the source table(s).

How can I accomplish that in PL/SQL with as few statements as possible? Thanks


create table PROJNEW
as select * FROM PROJECT WHERE PROJNUM > 24999

--
Terry Dykstra
That did it, thanks Terry!

"Terry Dykstra" <tddykstra (AT) forestoil (DOT) ca> wrote

"Bernie Bernbaum" <somebody (AT) somedomain (DOT) not> wrote

I'm new to PL/SQL and was wondering if there is an equivalent method in Oracle to Access's Make-Table query? For example this statement in Access:

SELECT * INTO PROJNEW FROM PROJECT WHERE PROJNUM > 24999

will create a new table named PROJNEW populated with the filtered records. What I like about Access's way of doing it (besides that it is a single step) is that the new table's columns are defined for me automatically according to what they are in the source table(s).

How can I accomplish that in PL/SQL with as few statements as possible? Thanks


create table PROJNEW
as select * FROM PROJECT WHERE PROJNUM > 24999

--
Terry Dykstra
That did it, thanks Terry!