SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily (@sqldaily) 's Twitter Profile Photo
SQL Daily
@sqldaily

6 months ago

Test if you can convert an expression to a data type in Oracle #SQL with VALIDATE_CONVERSION ( <expr> AS <datatype>, <fmt> ) This tries to convert <expr> using the <fmt> supplied; omit <fmt> & it defaults to the session's NLS settings This returns 1 on success, 0 on failure

Test if you can convert an expression to a data type in Oracle #SQL with VALIDATE_CONVERSION ( &lt;expr&gt; AS &lt;datatype&gt;, &lt;fmt&gt; ) This tries to convert &lt;expr&gt; using the &lt;fmt&gt; supplied; omit &lt;fmt&gt; &amp; it defaults to the session's NLS settings This returns 1 on success, 0 on failure