| Share this post! | Vote this! |
|
LOB's can store text, images, music and video inside the database.
You can define BLOB, CLOB and NCLOB columns, you can also secure these
with securefiles.
LOB's can store a maximum of 8 to 128 terabytes, depending on how you configure the database, you can call get_storage_limit using the dbms_lob package to get the maximum size.
get maximum LOB size : declare
var1 clob := 'some string';
var2 blob := hextoraw('43'||'41'||'52');
begin
result := dbms_lob.get_storage_limit(var1);
dbms_output.put_line('CLOB maximum limit: ' || result);
dbms_output.put_line('CLOB length: ' || dbms_lob.getlength(var1)); more...
LOB's can store a maximum of 8 to 128 terabytes, depending on how you configure the database, you can call get_storage_limit using the dbms_lob package to get the maximum size.
get maximum LOB size : declare
var1 clob := 'some string';
var2 blob := hextoraw('43'||'41'||'52');
begin
result := dbms_lob.get_storage_limit(var1);
dbms_output.put_line('CLOB maximum limit: ' || result);
dbms_output.put_line('CLOB length: ' || dbms_lob.getlength(var1)); more...
0 comments:
Post a Comment