Select Insert Select Create

기술관련/초짜DBA

Select Insert Select Create

흰머리개발자 2006. 7. 3. 19:26

--select Insert
[oracle]
INSERT INTO TESTTABLE(SELECT * FROM TESTTABLE WHERE TESTCOLUMN = 'TESTVALUE');
[mssql]
INSERT INTO TESTTABLE SELECT * FROM TESTTABLE WHERE TESTCOLUMN = 'TESTVALYE'

--select create
[oracle]
CREATE TABLE TESTTABLEBK AS SELECT * FROM TESTTABLE;

[mssql]
SELECT * INTO TESTTABLEBK FROM TESTTABLE