Oracle数据库备忘录

• Show all tables

select owner, table_name from all_tables;

• Show table info

describe tb_aaa;

• Get time zone

select dbtimezone, sessiontimezone from dual;

• Get current time

select current_timestamp from dual;

• Get db version

select * from v$version;

• find all constraints

select * from all_constraints where table_name='xxx';
select * from all_indexes where table_name='xxx;
select * from all_ind_columns where table_name='xxx;

• find all comumns

select column_name, data_default, hidden_column from user_tab_cols where table_name='xxx'