PL/DEV SETTING:
DECIMAL SYMBOL = .
DIGIT GROUP SYMBOL = ,

NLS PARAMETERS:
nls_language = CROATIAN
nls_territory = CROATIA
nls_numeric_characters = empty (derived from nls_territory ,. )

NLS DATABASE PARAMETERS:
NLS_LANGUAGE = AMERICAN
NLS_TERRITORY = AMERICA
NLS_NUMERIC_CHARACTERS = .,

WHY PLDEV IN SLQ/WINDOW USES "derived from nls_territory" when I explicitly want ., ???????????

This is bad! I've allready had few "situations" with this.

EXAMPLE:
When I duplicate row in SQL/WINDOW results with COPY/PASTE, numbers are displayed as "123.45" but after submit requery shows that in database was stored "12345" !!!


DoDo
--------------------------------------------
Be happy, tomorrow it can become only worse. If not, even better!