MySQL, Oracle Abc Wiki

create public database link admindb
connect to ... identified by ...
using '...';
 
select table_name, comments, num_rows, blocks, avg_space 
from 
user_tables@admindb
natural join user_tab_comments@admindb
and col.table_name = '...'
and rownum <= 10;
 
select /*+ rule */ col.table_name, col.column_name, comments, data_type, data_length, data_precision, nullable
from 
user_tab_columns@admindb col
left outer join user_col_comments@admindb cmt 
on col.table_name = cmt.table_name 
and col.column_name = cmt.column_name
and col.table_name = '...'
and rownum <= 10
order by table_name, column_id;