---更新一整列的值
update 表名 set 列名=REPLACE(列名,'1','2');
1是被替换的值 2是新值
--PL/SQL解锁表
select t.*,t.rowid from 表名 t
--清空表数据
TRUNCATE TABLE 表名
--oracle导出数据库
exp szfspub/szfspub@10.10.10.3:1521/orcl file=需要放到哪里文件路径 log=日志打印文件路径 文件类型.log
--oracle导入数据库
imp szfspub/szfspub@10.10.10.129:1521/orcl file=D:\data\punlic\szfspub.dmp log=D:\data\punlic\szfspub.log full=y ignore=y
--创建Dblink
create shared database link YTHdblink
connect to szfs identified by szfs
-- authenticated by sys identified by orcl
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.129)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
--创建Dblink简单写法
create public database link shenzhen connect to szfs IDENTIFIED BY szfs
using '10.10.10.129/orcl';