118 reputation
16
bio website
location
age
visits member for 2 years, 1 month
seen Sep 11 at 2:32

Jan
10
comment Oracle delete technique for table's segment size (data compactness)
corrected the code @ypercube. Nice eyes
Jan
9
comment Oracle delete technique for table's segment size (data compactness)
I am sorry if my definition of tablesize space is vague. I will edit the question to be clear on where I get the tablesize. I meant table's segment size by tablesize.
Oct
12
comment Oracle: Output not shown even if SERVEROUTPUT variable set to ON
I am executing in an sqlplus prompt in linux. yes the SET SERVEROUPUT ON was a typo error. I really did use SERVEROUTPUT cause it is noticeable if I get it wrong cause it displays a SP2-0735 error. So just perform the same thing i was writing yesterday and it worked. must be loosing it.
Sep
18
comment Is there an Oracle function to check for valid Japanese characters (Non-ASCII)?
The database character set is UTF-8. I guess garbled character is difficult to defined since it may still appear as japanese character but because it is already corrupted data it would be some squares, diamond and unreadable japanese.