table

I created a table instead of view based on a select stmt .I didn't saved the select stmt.

now i cannot see the original stmt in OEM like view.

is there any way we can get the select stmt i used with when i created that table

i used create table demo_table as select ...

is it possible?

Did you check in v$SQL?

Tamil

thanks, no i was not able find .I created this like 20 days ago...