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 Takipçi

4 Takip Edilen

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

25 days ago

The #database is free to run parts of a SQL WHERE clause in any order So how do you stop errors if you know an expression may throw one e.g. the square root of negative numbers? Use CASE to only run it on valid values WHERE CASE WHEN col > 0 THEN sqrt ( col ) ELSE ... END ...