求条sql语句，解决方法

求条sql语句，
查找用户user1下创建日期为当天的表大小！

[解决办法]

SQL code

上面是用户自己执行时的，如果想看别人的，执行如下:SELECT t.bytes  FROM DBA_Segments T,       (SELECT object_name          FROM DBA_OBJECTS S         WHERE TRUNC(S.CREATED) = TRUNC(SYSDATE)           AND OBJECT_TYPE = 'TABLE'           and owner='USER1') VWHERE t.segment_name=v.object_name      and owner='USER1';