Differences

This shows you the differences between two versions of the page.

--- kurs:typkonvertierung_-_casten [2014/09/10 21:22]
127.0.0.1 external edit
+++ kurs:typkonvertierung_-_casten [2016/11/30 11:14]
admin
@@ Line 2: / Line 2: @@
 select to_char(to_date('2006', 'yyyy'), 'yyyymmdd hh24:mi:ss') from dual;
 </code>
+<code>
+CREATE OR REPLACE FUNCTION TRY_TO_NUMBER
+(p_val in varchar2)
+RETURN NUMBER AS
+  v_number number;
+BEGIN
+  begin
+    v_number := to_number(p_val);
+    exception
+      when VALUE_ERROR then
+      v_number := 0;
+   end;
+   return v_number;
+END TRY_TO_NUMBER;
+</code>

dokuwiki