Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÔÚOracleÖи´ÖƱí½á¹¹ºÍ±íÊý¾Ý

1. ¸´ÖƱí½á¹¹¼°ÆäÊý¾Ý£º
create table table_name_new as select * from table_name_old
2. Ö»¸´ÖƱí½á¹¹£º
create table table_name_new as select * from table_name_old where
1=2;
»òÕߣº
create table table_name_new like table_name_old
3. Ö»¸´ÖƱíÊý¾Ý£º
Èç¹ûÁ½¸ö±í½á¹¹Ò»Ñù£º
insert into table_name_new select * from table_name_old
Èç¹ûÁ½¸ö±í½á¹¹²»Ò»Ñù£º
insert into
table_name_new(column1,column2...) select column1,column2...
from table_name_old


Ïà¹ØÎĵµ£º

¹ØÓÚORACLE·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷

´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
        1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
        2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
        3.±í·ÖÇøµÄÓÅȱµã
        4.±í·ÖÇøµÄ¼¸ÖÖÀàÐ ......

Íæ×ªOracle£¨5£©

||-------  Êý¾Ý¿â¹ÜÀí  -------||
//ÏÔʾ³õʼ»¯²ÎÊý
show parameter;
//Êý¾Ý¿â±íµÄÂß¼­±¸·ÝÓë»Ö¸´
//µ¼³ö
1.µ¼³ö±í
exp userid=scott/tiger@ORCL tables=(emp) file=d:\e1.dmp
2.µ¼³öÆäËû·½°¸µÄ±í£¬Ê×ÏÈҪȷÈÏ×Ô¼ºÊÇsysdbaÉí·Ý
exp userid=system@919959ORCL tables=(scott.emp) file=d:\e1.d ......

Íæ×ªOracle£¨7£©

||-------  pl/sql »ù´¡ -------||
pl/procedural language ¹ý³ÌÓïÑÔ
//´´½¨±í
SQL> create table mytest(
  2  name varchar2(30),
  3  pwd varchar2(30));
//´´½¨¹ý³Ì
create procedure sp_pro1 is
create or replace procedure sp_pro1 is --Èç¹û´æÔÚ¼´ ......

oracle ³£ÓÃÐÔÄܲéѯSQL·ÖÏí

select count(1) from dictionary;
select * from dba_data_files;
select count(1) from dba_objects t where t.owner='BESTTONE';
select * from dba_tablespaces t where t.tablespace_name='BESTTONE';
select count(1) from dba_tables t where t.owner='BESTTONE';
select t.table_name,t.comments from diction ......

oracleС¼Í

INSERT INTO hydlsrs@remote_£ú£úh
SELECT * from hydlsrs where zzh='2'
hydlsrsΪ±íÃû¡¡£Àremote_zzhΪ¿âÃû
select * from hydlsrsΪÁí1¿âÖбíÃû£¬
²»Í¬¿âÖÐÏàͬ±í½á¹¹£¬¿ÉÒÔ¿ç¿â²åÈë¡£ÓÃÓÚ
2µØµ¹Èë±íÄÚÈÝ¡£  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ