Guest User

Untitled

a guest
Oct 23rd, 2017
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.52 KB | None | 0 0
  1. create table fedcommusr.md_commtab1 sharing=metadata
  2. (deptno number, dname varchar2(100));
  3. insert into fedcommusr.md_commtab1 values (1, 'One');
  4. insert into fedcommusr.md_commtab1 values (2, 'Two');
  5. comment on column fedcommusr.md_commtab1.deptno is 'department number';
  6. comment on column fedcommusr.md_commtab1.dname is 'Department name is';
  7.  
  8. exec DBMS_STATS.GATHER_SCHEMA_STATS(ownname=>'FEDCOMMUSR');
  9.  
  10. select owner,table_name, NUM_ROWS from dba_tables where owner like upper('%fed%') ;
  11.  
  12. FEDCOMMUSR MD_COMMTAB1 (null)
Add Comment
Please, Sign In to add comment