سؤال في الفورم

لمعرفة معلومات اليوزر استخدم الفنكشن USERENV

'ISDBA'

returns 'TRUE' if you currently have the ISDBA role enabled and 'FALSE' if you do not.

'LANGUAGE'

returns the language and territory currently used by your session along with the database character set in this form:

language_territory.characterset

'TERMINAL'

returns the operating system identifier for your current session's terminal. In distributed SQL statements, this option returns the identifier for your local session. In a distributed environment, this is supported only for remote SELECTs, not for remote INSERTs, UPDATEs, or DELETEs.

'SESSIONID'

returns your auditing session identifier. You cannot use this option in distributed SQL statements.

'ENTRYID'

returns available auditing entry identifier. You cannot use this option in distributed SQL statements. To use this keyword in USERENV, the initialization parameter AUDIT_TRAIL must be set to TRUE.

'LANG'

Returns the ISO abbreviation for the language name, a shorter form than the existing 'LANGUAGE' parameter.

'INSTANCE'

Returns the instance identification number of the current instance.

'CLIENT_INFO'

returns up to 64 bytes of user session information that can be stored by an application using the DBMS_APPLICATION_INFO package.

CAUTION: Some commercial applications may be using this context value. Check the applicable documentation for those applications to determine what restrictions they may impose on use of this context area.

Oracle recommends that you use the application context feature or the SYS_CONTEXT function with the USERENV option. These alternatives are more secure and flexible. For information on application context, see Oracle8i Concepts. See also "CREATE CONTEXT" and "SYS_CONTEXT".

Example

SELECT USERENV('LANGUAGE') "Language" FROM DUAL;

Language

-----------------------------------

AMERICAN_AMERICA.WE8DEC

THAT MEAN U MUST USE USERENV (TERMINAL )

شكرا اخي

black&white

شكرا جزيلا أخي black&white

دا إنت دايما أبيض :)

أنا رايح أجرب و أكتب لك إزا كان فيه أي مشكلة ....

السلام عليكم