question

OraLearner avatar image
OraLearner asked

What is large object in oracle?

What is large object in oracle? Explain its purposes, Explain types of large objects in oracle, i.e. BLOB, LLOB,NCLOB and BFILE ? Thank you.

oracleobjectslob
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KillerDBA avatar image KillerDBA commented ·
Is there some specific reason you haven't approved the answer? Do you have some reason to believe the answer isn't reasonably correct? Do you not understand the answer? If so, you should probably respond to Hillbilly Toad's efforts with a responsive comment.
0 Likes 0 ·

1 Answer

·
HillbillyToad avatar image
HillbillyToad answered

Let's say you wanted to store the contents of a magazine article in a table column. VARCHAR2 would most likely fall short. CLOB on the other hand (Character Large Object) handles the task just fine.

Or let's say you wanted to store your iTunes collection of MP4's in a table. BLOB (Binary Large Object) handles this just fine as well.

NCLOB, NVARCHAR2, N... allows you to store data in a different characterset than normal. That's better discussed as a separate topic.

There are storage implications in using LOB's if that's of interest to you.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

OraLearner avatar image OraLearner commented ·
Thank you for the answer.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.