ITPub博客

WITH t AS (SELECT 'abc/def/ghi' AS x FROM dual)SELECT regexp_substr(x,'[^/]+',1,LEVEL) AS wordFROM tCONNECT BY LEVEL<=LENGTH(x)-LENGTH(REPLACE(x,'/',''))+1;

CREATE TABLE SCOTT.TIME_GROUP(  ARRAY_ID  NUMBER,  TIMETAG   TIMESTAMP(9))；SQL> select * from time_group;   ARRAY_ID TIMETAG---------- ----------------------...

最近需要提取出文本文件中某几列的数据，简单写了一下脚本：use strict;my $read_file = "1.txt";my $write_file = "2.txt";open my ($fhin), '<', $read_file or die "Can't open file: $!";open my ($fhou...

1 exception com.lfx.db.DatabaseMarkdownException: Database (LOGICAL.DEFAULT) is markdown!   在配置过程中遇到的一个最大的问题是DBPASS，其后面所填的密码应该是经过加密后的密...