This discussion is archived
2 Replies Latest reply: Jul 29, 2012 1:49 AM by 808794 RSS

How to know the select stmt used in creating a table?

808794 Newbie
Currently Being Moderated
If we create a table by selecting some records form another table, can we see the select statement used to create that table.
example: Create table emp2 as select * from emp where deptno=20;
is there any data dictionary table which stores select * from emp where deptno=20

Thanks in advance.

Edited by: 805791 on Jul 28, 2012 9:01 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points