自學(xué)數(shù)據(jù)庫(kù),如何創(chuàng)建數(shù)據(jù)庫(kù)表格?
網(wǎng)友解答: 1、直接創(chuàng)建:create table t(name varchar2(50 char)); 2、創(chuàng)建與表A結(jié)構(gòu)相同的空表:create table a_tmp as sel
1、直接創(chuàng)建:create table t(name varchar2(50 char)); 2、創(chuàng)建與表A結(jié)構(gòu)相同的空表:create table a_tmp as select * from A where 1=0; 3、復(fù)制表A全部(或部分)數(shù)據(jù):create table a_tmp as select * from A (where a.xxx=xxx)