Oracle 12c : Convert blob to sql literal
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
I got an Oracle DB 12c where TableName1.FILE is a blob type column. Currently I want to generate an insert query so that I can use it on my SqlLite TableName2.FILE which is also a blob column.
I expect to generate this kind of query
INSERT INTO TABLENAME2 (FILE) VALUES (X'<sql binary literal>')
So, how can I convert my Oracle DB blob column to generate that sql binary literal ?
I tried to use this one, but I got ORA-06502 exception
SELECT
dbms_lob.substr (FILE, 32767, 1 ) head
FROM TableName1;`
sql oracle oracle12c
asked Nov 14 '18 at 7:30
MryeMrye
142317
add a comment |
I got an Oracle DB 12c where TableName1.FILE is a blob type column. Currently I want to generate an insert query so that I can use it on my SqlLite TableName2.FILE which is also a blob column.
I expect to generate this kind of query
INSERT INTO TABLENAME2 (FILE) VALUES (X'<sql binary literal>')
So, how can I convert my Oracle DB blob column to generate that sql binary literal ?
I tried to use this one, but I got ORA-06502 exception
SELECT
dbms_lob.substr (FILE, 32767, 1 ) head
FROM TableName1;`
sql oracle oracle12c
asked Nov 14 '18 at 7:30
MryeMrye
142317
Don't convert it to character inserts. Save the BLOBs to OS files usingutl_file.put_rawSee Here asktom.oracle.com/pls/asktom/…. There's a working example at the end of the post. Then copy them to your target folder of the server where SQLite is hosted. I don't know SQLite,but importing binary looks like Child's play compared to Oracle stackoverflow.com/a/35960885/7998591
– Kaushik Nayak
Nov 14 '18 at 8:47
add a comment |
I got an Oracle DB 12c where TableName1.FILE is a blob type column. Currently I want to generate an insert query so that I can use it on my SqlLite TableName2.FILE which is also a blob column.
I expect to generate this kind of query
INSERT INTO TABLENAME2 (FILE) VALUES (X'<sql binary literal>')
So, how can I convert my Oracle DB blob column to generate that sql binary literal ?
I tried to use this one, but I got ORA-06502 exception
SELECT
dbms_lob.substr (FILE, 32767, 1 ) head
FROM TableName1;`
sql oracle oracle12c
asked Nov 14 '18 at 7:30
MryeMrye
142317
I got an Oracle DB 12c where TableName1.FILE is a blob type column. Currently I want to generate an insert query so that I can use it on my SqlLite TableName2.FILE which is also a blob column.
I expect to generate this kind of query
INSERT INTO TABLENAME2 (FILE) VALUES (X'<sql binary literal>')
So, how can I convert my Oracle DB blob column to generate that sql binary literal ?
I tried to use this one, but I got ORA-06502 exception
SELECT
dbms_lob.substr (FILE, 32767, 1 ) head
FROM TableName1;`
sql oracle oracle12c
sql oracle oracle12c
asked Nov 14 '18 at 7:30
MryeMrye
142317
asked Nov 14 '18 at 7:30
MryeMrye
142317
asked Nov 14 '18 at 7:30
MryeMrye
142317
asked Nov 14 '18 at 7:30
MryeMrye
142317
asked Nov 14 '18 at 7:30
MryeMrye
142317
142317
Don't convert it to character inserts. Save the BLOBs to OS files usingutl_file.put_rawSee Here asktom.oracle.com/pls/asktom/…. There's a working example at the end of the post. Then copy them to your target folder of the server where SQLite is hosted. I don't know SQLite,but importing binary looks like Child's play compared to Oracle stackoverflow.com/a/35960885/7998591
– Kaushik Nayak
Nov 14 '18 at 8:47
add a comment |
Don't convert it to character inserts. Save the BLOBs to OS files usingutl_file.put_rawSee Here asktom.oracle.com/pls/asktom/…. There's a working example at the end of the post. Then copy them to your target folder of the server where SQLite is hosted. I don't know SQLite,but importing binary looks like Child's play compared to Oracle stackoverflow.com/a/35960885/7998591
– Kaushik Nayak
Nov 14 '18 at 8:47
Don't convert it to character inserts. Save the BLOBs to OS files using
utl_file.put_raw See Here asktom.oracle.com/pls/asktom/…. There's a working example at the end of the post. Then copy them to your target folder of the server where SQLite is hosted. I don't know SQLite,but importing binary looks like Child's play compared to Oracle stackoverflow.com/a/35960885/7998591– Kaushik Nayak
Nov 14 '18 at 8:47
Don't convert it to character inserts. Save the BLOBs to OS files using
utl_file.put_raw See Here asktom.oracle.com/pls/asktom/…. There's a working example at the end of the post. Then copy them to your target folder of the server where SQLite is hosted. I don't know SQLite,but importing binary looks like Child's play compared to Oracle stackoverflow.com/a/35960885/7998591– Kaushik Nayak
Nov 14 '18 at 8:47
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53295086%2foracle-12c-convert-blob-to-sql-literal%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53295086%2foracle-12c-convert-blob-to-sql-literal%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Don't convert it to character inserts. Save the BLOBs to OS files using
utl_file.put_rawSee Here asktom.oracle.com/pls/asktom/…. There's a working example at the end of the post. Then copy them to your target folder of the server where SQLite is hosted. I don't know SQLite,but importing binary looks like Child's play compared to Oracle stackoverflow.com/a/35960885/7998591– Kaushik Nayak
Nov 14 '18 at 8:47