Created
June 8, 2015 04:09
-
-
Save brunkb/c0b5cbbd90271144243c to your computer and use it in GitHub Desktop.
CLOB Insert
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Fake data generated by: http://json-generator.appspot.com/ | |
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", | |
"about": "Sint et aliqua non mollit cupidatat aute amet culpa esse aliquip laborum. Eu irure ex laboris non sunt ex cillum tempor. Dolore do est voluptate id nulla occaecat irure nostrud adipisicing esse occaecat tempor culpa ut. Veniam adipisicing eiusmod culpa magna pariatur amet id occaecat eiusmod officia Lorem quis ex. Qui aute ea consectetur Lorem anim cillum exercitation incididunt Lorem sunt consequat minim adipisicing et. Laboris est nulla tempor mollit cillum amet qui adipisicing pariatur consequat. Sint cupidatat voluptate tempor fugiat esse consectetur ut ex pariatur irure aliqua non irure exercitation.\r\n", | |
"registered": "2015-04-28T10:11:46 +05:00", | |
"latitude": 50.9154, | |
"longitude": -150.848441, | |
"tags": [ | |
"veniam", | |
"ad", | |
"excepteur", | |
"deserunt", | |
"non", | |
"in", | |
"tempor" | |
], | |
"friends": [ | |
{ | |
"id": 0, | |
"name": "Gena Mcfarland" | |
}, | |
{ | |
"id": 1, | |
"name": "Julia Jenkins" | |
}, | |
{ | |
"id": 2, | |
"name": "Cheryl Reed" | |
} | |
], | |
"greeting": "Hello, Mayra Stevenson! You have 3 unread messages.", | |
"favoriteFruit": "strawberry" | |
}', SYSDATE); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment