select i.*,i.rowid
from smsinfoabout i
where to_char(i.createdate,'yyyymmdd')>=to_char(sysdate-9,'yyyymmdd') and i.addresseeid=81397
from smsinfoabout i
where to_char(i.createdate,'yyyymmdd')>=to_char(sysdate-9,'yyyymmdd') and i.addresseeid=81397