Oracle常用SQL

1	UPDATE MSMD_CONVERT_B SET MEMO = REPLACE(MEMO,CHR(10),'') WHERE MEMO LIKE '%'\|\|CHR(10) \|\|'%';

1	SELECT 'drop table ' \|\| t.TABLE_NAME \|\| ';' FROM USER_TABLES t WHERE LENGTH(t.TABLE_NAME) != LENGTH(REGEXP_REPLACE(t.TABLE_NAME, '[^0-9]'));

1
2
3

create database link dblink2
connect to db1 identified by "1"
using '192.168.1.5/orcl';

冰块的个人首页