摘要:
--根据某一列中包括的逗号将一行数据变多行select a,c from (with test as (select 'abc' a,'1,2,3' c from dual e) select a,substr(t.ca, instr(t.ca, ',', 1, c.lv) + 1, instr(t... 阅读全文
摘要:
1. 查看所有表空间大小SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;2. 已经使用的表空间大小SQL> select tablespace_name,sum... 阅读全文
摘要:
1.查看当前日志组成员:SQL> select member from v$logfile;MEMBER------------------------------------------------------C:\ORACLE\PRODUCT\10.2.0\ORADATA\FYDB\REDO01... 阅读全文