-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|