To report a found bug,
please, select the text with the bug and click Report a Bug or
CTRL+ENTER.
Help
system 10.5 of 04/10/2024,
©
FORESIGHT
SYSDATE
The SYSDATE function returns the current date and time. It has no arguments.
NOTE. The function is available to use only on working with Oracle DBMS.
BIRTHDATE <= SYSDATE
The value of the BIRTHDATE field cannot be more than the current date.
USERENV('Option')
The USERENV function returns the value containing information about the current session based on the Option parameter. Available parameter values:
LANGUAGE. Returns the language and the territory which are used during the session and the database symbols' set. A returned value looks as follows: language_territory.characterset. For example: RUSSIAN_CIS.CL8MSWIN1251.
TERMINAL. Returns identifier of the terminal used during the current session.
SESSIONID. Returns identifier of the auditing session.
ENTRYID. Returns available identifier of the auditing record.
LANG. Returns ISO abbreviation for the language of the current session. For example: RU.
NOTE. The function is available to use only on working with Oracle DBMS.
USER_LNG = USERENV('LANG')
The USER_LNG field (type String) may contain only the language of the current session.
See also:
Built-in SQL Functions | Table Constraints