(5)Data Dictionary Content and Usage

• Data Dictionary
  (1) Data Dictionary tables
      Base tables: 加密，只读
      Data Dictionary View
  (2) Dynamic performance tables
• Data Dictionary View Categories
  (1) DBA
  (2) ALL
  (3) USER
• Query
  (1) select * from dictionary
  (2) select * from v$fixed_table

• 

  catalog.sql            创建数据字典视图

  catproc.sql            创建存储过程

   spool c:\temp.log

  set serveroutput on

  execute dbms_output.put_line('test string1'); 

  spool off