Global variables

Global variables are available by using the command:

select @@variable_name

Example 11

For example:

> select @@servername, @@version
> go

Following is a list of available global variables:

@@autocommit – returns the autocommit setting.

@@compatibility_level – returns the current configured value for number_mode and truncate_text. truncate_text exists for compatibility only.

@@child_logfile – returns the file specification of the errorlog. This variable has been replaced and is here for compatibility only. New applications should use @@errorlog instead.

@@client_csname – returns the character set in use by the current connection.

@@connect_info – returns the configured value for ‘connect_string’. For compatibility only.

@@connect_string – returns the connect_string that the service is using.

@@default_charset – returns the charset name used when the server was started.

@@errorlog – returns the file specification of the errorlog.

@@max_users – returns the max_users run value.

@@maxpagesize – returns the maxpagesize run value.

@@language – returns the language in use by the current connection.

@@ncharsize – returns the size of an nchar character.

@@nls_lang – returns the language, territory and character set in use by the Oracle connection.

@@oracle_version – returns the version of Oracle to which a connection has been established.

@@servername – returns the current server name to which the client has connected.

@@spid – returns the process ID of the current connection.

@@sql_transform – returns the current sql_transform setting.

@@textsize – returns the current textsize value.

@@version – returns the version string of the DirectConnect server.