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

8 months ago

Use dot-notation to access attributes of stored #JSON with Oracle #SQL SELECT tab.jcol.attr This returns a JSON data type => implicit conversions & poor plans Use type methods to set the type: SELECT tab.jcol.attr.number() Philipp Salvisberg demos salvis.com/blog/2025/01/2…