ttHostNameGet

This procedure returns the name of the current local host for the database. The value returned is only for the current session. It is not a systemwide setting and does not persist after the current session has been disconnected.

Use this procedure to check whether a particular store name in a scheme refers to the current host. This can be helpful when configuring replication schemes.

Required Privilege

This procedure requires no privilege.

Related Views

This procedure has this related view.

SYS.V$HOST_NAME

Syntax

ttHostnameGet()

Parameters

ttHostNameGet has no parameters.

Result Set

ttHostNameGet returns the result:

Column	Type	Description
`hostName`	`TT_VARCHAR (200)`	The current default local host setting for the database. If a default has not been supplied then the current host name is returned.

Examples

CALL ttHostNameGet ();
< myhost >
1 row found.