How to show environment variable?

11 |

How to show environment variable in Oracle SQLPLUS .

For expamle : how to show environement variable NLS_LANG ?

千问 | 2013-5-11 09:31:00 | 显示全部楼层

select * from nls_database_parameters
order by parameter

千问 | 2013-5-11 09:31:00 | 显示全部楼层

show all?

千问 | 2013-5-11 09:31:00 | 显示全部楼层

Dear All:
Thanks for your help, now I find correctly answer, you can use regedit, Finditin hkey_local_machine\software\oracle

千问 | 2013-5-11 09:31:00 | 显示全部楼层

可能问的是:
#set
or
c:\set

千问 | 2013-5-11 09:31:00 | 显示全部楼层

show parameters;

主题	0 回帖	4882万积分

Rank: 8 Rank: 8

热门排行