I run some DDL, such as "create table", "alter table", "drop table", "truncate table". However, I cannot find DDL in v$ views, such as v$sql. Why can't I find them? Is there some mistakes? Thanks a lot.
SQL> create table temp (id number);
Table created.
SQL> select * from v$sqlarea where upper(sql_text) like 'CREATE%';
no rows selected