[SQL] pobierz, plaintext 
SELECT * FROM v$nls_parameters;
 
PARAMETER               VALUE
----------------------- ---------------------------
NLS_LANGUAGE		POLISH
NLS_TERRITORY		POLAND
NLS_CURRENCY		zł
NLS_ISO_CURRENCY	POLAND
NLS_NUMERIC_CHARACTERS	, 
NLS_CALENDAR		GREGORIAN
NLS_DATE_FORMAT		RR/MM/DD
NLS_DATE_LANGUAGE	POLISH
NLS_CHARACTERSET	AL32UTF8
NLS_SORT		POLISH
NLS_TIME_FORMAT		HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT	RR/MM/DD HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT	HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT	RR/MM/DD HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY	zł
NLS_NCHAR_CHARACTERSET	AL16UTF16
NLS_COMP		BINARY
NLS_LENGTH_SEMANTICS	CHAR
NLS_NCHAR_CONV_EXCP	FALSE
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT to_char(sysdate-2,'D') AS nr_dnia FROM dual;  -- którym dniem tygodnia był poniedziałek?
 
NR_DNIA
-------
      1
[SQL] pobierz, plaintext