oracle/r/func_substr.result

6 SELECT SUBSTR('abc',2,1),SUBSTR('abc',1,1), SUBSTR('abc',0,1) FROM dual;
7 SUBSTR('abc',2,1)	SUBSTR('abc',1,1)	SUBSTR('abc',0,1)
9 SELECT SUBSTR('abc',2),SUBSTR('abc',1), SUBSTR('abc',0) FROM dual;
10 SUBSTR('abc',2)	SUBSTR('abc',1)	SUBSTR('abc',0)
12 SELECT SUBSTR(null,2,1),SUBSTR(null,1), SUBSTR(null,0) FROM dual;
13 SUBSTR(null,2,1)	SUBSTR(null,1)	SUBSTR(null,0)
15 SELECT SUBSTR('abc',-2),SUBSTR('abc',-1), SUBSTR('abc',-0) FROM dual;
16 SUBSTR('abc',-2)	SUBSTR('abc',-1)	SUBSTR('abc',-0)
18 SELECT SUBSTR('abc',-2,1),SUBSTR('abc',-1,1), SUBSTR('abc',-0,1) FROM dual;
19 SUBSTR('abc',-2,1)	SUBSTR('abc',-1,1)	SUBSTR('abc',-0,1)
21 SELECT SUBSTR('abc',null) FROM dual;
22 SUBSTR('abc',null)
24 SELECT SUBSTR('abc',2,null),SUBSTR('abc',1,null), SUBSTR('abc',0,null) FROM dual;
25 SUBSTR('abc',2,null)	SUBSTR('abc',1,null)	SUBSTR('abc',0,null)
27 SELECT SUBSTR('abc',2,0),SUBSTR('abc',1,0), SUBSTR('abc',0,0) FROM dual;
28 SUBSTR('abc',2,0)	SUBSTR('abc',1,0)	SUBSTR('abc',0,0)
30 SELECT SUBSTR('abc',2,-1),SUBSTR('abc',1,-1), SUBSTR('abc',0,-1) FROM dual;
31 SUBSTR('abc',2,-1)	SUBSTR('abc',1,-1)	SUBSTR('abc',0,-1)
33 SELECT SUBSTR(SPACE(0),1) FROM DUAL;
34 SUBSTR(SPACE(0),1)
50 SELECT SUBSTR(c1,start,length) FROM t1;
51 SUBSTR(c1,start,length)
67 CREATE TABLE t2 AS SELECT SUBSTR(C1,1,1) AS C1 from t1;
75 EXPLAIN EXTENDED SELECT SUBSTR('abc',2,1) ;
79 Note	1003	select substr_oracle('abc',2,1) AS "SUBSTR('abc',2,1)"
80 CREATE VIEW v1 AS SELECT SUBSTR('abc',2,1) ;
83 v1	CREATE VIEW "v1" AS select substr_oracle('abc',2,1) AS "SUBSTR('abc',2,1)"	latin1	latin1_swedish…
85 SUBSTR('abc',2,1)