lbk90032190

SELECT c.tablespace_name tablespace_name, ROUND(a.bytes/1048576,2) total_size,ROUND((a.bytes-b.bytes)/1048576,2) used_size,ROUND(b.bytes/1048576,2) free_size, ROUND(b.bytes/a.bytes * 100,2)||'%' free_...

alter table table_name  enable row movement; flashback table table_nameto timestamp to_timestamp('2009-11-20 15:00:00','yyyy-mm-dd hh24:mi:ss');

UPDATE tablename SET PARENTID=( case WHEN LENGTH(column1)/2=1 then '0' when LENGTH(column2)/2=2 then substr(column1,1,2) when LENGTH(column3)/2=3 then substr(column2,1,...