Hello,
I am going to calculate size of database. Is anybody knows how to get size of long raw value?
Thanks
Printable View
Hello,
I am going to calculate size of database. Is anybody knows how to get size of long raw value?
Thanks
hi
use thsi to calculate the size of long raw.
set serveroutput on
declare
length_var NUMBER;
cursor toy_cursor is
select * from TOY;
toy_val toy_cursor%ROWTYPE;
begin
open toy_cursor;
fetch toy_cursor into toy_val;
length_var := LENGTH(toy_val.Description);
DBMS_OUTPUT.PUT_LINE('Length of Description: '||length_var);
close toy_cursor;
end;
toy_val.Description is a column of long raw okay
regards
hrishy