ALTER TABLE READINGS 
     ADD( JSON_COL CLOB 
     CONSTRAINT con_jos_colm CHECK (JSON_COL IS JSON));
I'm trying to run this on Oracle 12.1.0.1.0 (which is suppose to support JSON) but getting this error 
Error report -
SQL Error: ORA-00908: missing NULL keyword
00908. 00000 -  "missing NULL keyword"
*Cause:    
*Action:
I'm trying to run this on Oracle 12.1.0.1.0
JSON support was introduced with 12.1.0.2, so your version doesn't support that.
Oracle Database 12c Release 1 (12.1.0.2) New Features
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With