如何在Oracle中列出所有数据库名称 [英] How to list all database names in Oracle
本文介绍了如何在Oracle中列出所有数据库名称的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨
我想列出所有数据库名称,但没有得到任何命令,请帮助...
提前感谢
解决方案
1 ) view database
选择 * 来自 v
数据库;
2 )至 view 实例
选择 * 来自 v
实例;
3 ) view 所有用户
选择 * 来自 all_users;
4 ) 查看 表 和列 for 特定用户
选择 tc.table_name Table_name
,tc.column_id Column_id
,lower(tc.column_name)Column_name
,lower(tc.data_type)Data_type
,nvl(tc.data_precision,tc.data_length)Length
,lower(tc.data_scale)Data_scale
,tc.nullable nullable
FROM all_tab_columns tc
,all_tables t
WHERE tc.table_name = t.table_name;
Hi
I want to list all database names, but not getting any command to do so, please help...
thanks in advance
解决方案
1) To view database select * from v
database; 2) To view instance select * from v
instance; 3) To view all users select * from all_users; 4) To view table and columns for a particular user select tc.table_name Table_name ,tc.column_id Column_id ,lower(tc.column_name) Column_name ,lower(tc.data_type) Data_type ,nvl(tc.data_precision,tc.data_length) Length ,lower(tc.data_scale) Data_scale ,tc.nullable nullable FROM all_tab_columns tc ,all_tables t WHERE tc.table_name = t.table_name;
这篇关于如何在Oracle中列出所有数据库名称的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文