unpivot price for "TYPE" in (
OFFICES_BUSINESS_CENTER as 'OFFICES_BUSINESS',
OFFICES_OTHER as 'OFFICES_OTHER',
...
LAND_INDUSTRIAL as 'INDUSTRIAL'
)
rem NLS_LANG=RUSSIAN_RUSSIA.AL32UTF8
chcp 65001
sqlplus
set NLS_LANG=RUSSIAN_RUSSIA.CL8MSWIN1251
chcp 1251
sqlplus
set NLS_LANG=AMERICAN_RUSSIA.CL8PC866
sqlplus
If the TNS_ADMIN environment variable is not set, and TNSNAMES entries such as inst1, and so on, are used, then the ORACLE_HOME variable must be set, and the configuration files are expected to be in the $ORACLE_HOME/network/admin directory.