oracle
Java喝咖啡
你只需努力,剩下的交给时光
展开
-
oracle to_date to_char的使用
select table_name,owner,row_movement from dba_tables where lower(table_name) = 'actnodtl'; alter table actnodtl enable row movement;原创 2014-05-06 22:53:00 · 571 阅读 · 0 评论 -
oracle修改server段字符集
5.1 修改server端字符集(不建议使用) 1. 关闭数据库 SQL>SHUTDOWN IMMEDIATE 2. 启动到Mount SQL>STARTUP MOUNT; SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION; SQL>ALTER SYSTEM SET JOB_QU原创 2014-05-06 22:54:50 · 556 阅读 · 0 评论 -
安装oracle
update mp a set msg_status = '0', chg_type = '1', status = '2' where brno = '772' and exists (select 1 from tmp2 b where brno = '772' and a.extno = b.e原创 2014-05-06 22:56:55 · 584 阅读 · 0 评论