Other functions in SQL

Linklist

1. DBSERVERNAME - servername
2. NVL - replace NULL-values with others
3. SITENAME - servername
4. USER - the name of the current user

NVL - replace NULL-values with others

Syntax

NVL( Feldname [, Value ] )

Description

Replaces all NULL-values with the value given in the argument.

DBSERVERNAME - return the name of the database server

Syntax

DBSERVERNAME

Description

Returns the name of the database server.

USER - return the user-ID

Syntax

USER

Description

Returns the login name of the currrent user.

SITENAME - return the name of the server

Syntax

SITENAME

Description

Returns the name of the current database server.