forked from orafce/orafce
-
Notifications
You must be signed in to change notification settings - Fork 0
/
orafce-varchar2-casts.sql
201 lines (152 loc) · 3.09 KB
/
orafce-varchar2-casts.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
/* CREATE CAST */
CREATE CAST (nvarchar2 AS text)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (text AS nvarchar2)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (nvarchar2 AS char)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (char AS nvarchar2)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (nvarchar2 AS varchar)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (varchar AS nvarchar2)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (nvarchar2 AS nvarchar2)
WITH FUNCTION nvarchar2(nvarchar2,integer, boolean)
AS IMPLICIT;
CREATE CAST (nvarchar2 AS real)
WITH INOUT
AS IMPLICIT;
CREATE CAST (real AS nvarchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (nvarchar2 AS double precision)
WITH INOUT
AS IMPLICIT;
CREATE CAST (double precision AS nvarchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (nvarchar2 AS integer)
WITH INOUT
AS IMPLICIT;
CREATE CAST (integer AS nvarchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (nvarchar2 AS smallint)
WITH INOUT
AS IMPLICIT;
CREATE CAST (smallint AS nvarchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (nvarchar2 AS bigint)
WITH INOUT
AS IMPLICIT;
CREATE CAST (bigint AS nvarchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (nvarchar2 AS numeric)
WITH INOUT
AS IMPLICIT;
CREATE CAST (numeric AS nvarchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (nvarchar2 AS date)
WITH INOUT
AS IMPLICIT;
CREATE CAST (date AS nvarchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (nvarchar2 AS timestamp)
WITH INOUT
AS IMPLICIT;
CREATE CAST (timestamp AS nvarchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (nvarchar2 AS interval)
WITH INOUT
AS IMPLICIT;
CREATE CAST (interval AS nvarchar2)
WITH INOUT
AS IMPLICIT;
/* CREATE CAST */
CREATE CAST (varchar2 AS text)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (text AS varchar2)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (varchar2 AS char)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (char AS varchar2)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (varchar2 AS varchar)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (varchar AS varchar2)
WITHOUT FUNCTION
AS IMPLICIT;
CREATE CAST (varchar2 AS varchar2)
WITH FUNCTION varchar2(varchar2,integer,boolean)
AS IMPLICIT;
CREATE CAST (varchar2 AS real)
WITH INOUT
AS IMPLICIT;
CREATE CAST (real AS varchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (varchar2 AS double precision)
WITH INOUT
AS IMPLICIT;
CREATE CAST (double precision AS varchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (varchar2 AS integer)
WITH INOUT
AS IMPLICIT;
CREATE CAST (integer AS varchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (varchar2 AS smallint)
WITH INOUT
AS IMPLICIT;
CREATE CAST (smallint AS varchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (varchar2 AS bigint)
WITH INOUT
AS IMPLICIT;
CREATE CAST (bigint AS varchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (varchar2 AS numeric)
WITH INOUT
AS IMPLICIT;
CREATE CAST (numeric AS varchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (varchar2 AS date)
WITH INOUT
AS IMPLICIT;
CREATE CAST (date AS varchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (varchar2 AS timestamp)
WITH INOUT
AS IMPLICIT;
CREATE CAST (timestamp AS varchar2)
WITH INOUT
AS IMPLICIT;
CREATE CAST (varchar2 AS interval)
WITH INOUT
AS IMPLICIT;
CREATE CAST (interval AS varchar2)
WITH INOUT
AS IMPLICIT;