I'm sorry I did'nt phrased my requirements correctly.Actually what I'm looking at is extracting the entire sqltext for eg. (create table A as select * from B) which a user might be running against the database.

select t.sql_text
from sys.gv_$sqltext t
, sys.gv_$session s
-- Adress in session_info.sql (sql_address)
where t.address = s.sql_address
and s.sid = ??
ORDER BY piece

does not extract sql information if it is a DDL.Is there Any view that can be queried for extracting DDL statement text.
Please let me know if it is possible.

Thanks