Skip to content

Instantly share code, notes, and snippets.

@brunkb

brunkb/clob_insert1.sql

Created June 8, 2015 18:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save brunkb/3004bedbd11ac900c87c to your computer and use it in GitHub Desktop.
Save brunkb/3004bedbd11ac900c87c to your computer and use it in GitHub Desktop.
Download ZIP
Example of inserting JSON via SQL
Raw
clob_insert1.sql
insert into myclobs (data, date_created) values (‘[{
"_id": "556e52fc21aa6202ee1aac18",
"index": 0,
"guid": "dd60b0a8-2bb8-4dae-83b4-1940b2e47f9c",
"isActive": false,
"balance": "$3,616.96",
"picture": "http://placehold.it/32x32",
"age": 40,
"eyeColor": "blue",
"name": "Mayra Stevenson",
"gender": "female",
"company": "EPLODE",
"email": "mayrastevenson@eplode.com",
"phone": "+1 (927) 436-2136",
"address": "702 Celeste Court, Beaverdale, Connecticut, 169",
}]’, SYSDATE);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment