Lines Matching refs:SUBSTR
7 SELECT SUBSTR('abc',2,1),SUBSTR('abc',1,1), SUBSTR('abc',0,1) FROM dual;
8 SELECT SUBSTR('abc',2),SUBSTR('abc',1), SUBSTR('abc',0) FROM dual;
9 SELECT SUBSTR(null,2,1),SUBSTR(null,1), SUBSTR(null,0) FROM dual;
10 SELECT SUBSTR('abc',-2),SUBSTR('abc',-1), SUBSTR('abc',-0) FROM dual;
11 SELECT SUBSTR('abc',-2,1),SUBSTR('abc',-1,1), SUBSTR('abc',-0,1) FROM dual;
12 SELECT SUBSTR('abc',null) FROM dual;
13 SELECT SUBSTR('abc',2,null),SUBSTR('abc',1,null), SUBSTR('abc',0,null) FROM dual;
14 SELECT SUBSTR('abc',2,0),SUBSTR('abc',1,0), SUBSTR('abc',0,0) FROM dual;
15 SELECT SUBSTR('abc',2,-1),SUBSTR('abc',1,-1), SUBSTR('abc',0,-1) FROM dual;
16 SELECT SUBSTR(SPACE(0),1) FROM DUAL;
33 SELECT SUBSTR(c1,start,length) FROM t1;
37 CREATE TABLE t2 AS SELECT SUBSTR(C1,1,1) AS C1 from t1;
42 EXPLAIN EXTENDED SELECT SUBSTR('abc',2,1) ;
44 CREATE VIEW v1 AS SELECT SUBSTR('abc',2,1) ;