Project Level Issue

To Check what will be the NLS Map for Oracle
=====================================

select DECODE(parameter, 'NLS_CHARACTERSET', 'CHARACTER SET',
'NLS_LANGUAGE', 'LANGUAGE',
'NLS_TERRITORY', 'TERRITORY') name,
value from v$nls_parameters
WHERE parameter IN ( 'NLS_CHARACTERSET', 'NLS_LANGUAGE', 'NLS_TERRITORY');

To omit any new line from a column in SQL Server
=====================================
select ID002,ID003,ID006,ID010,ID017,ID018,ID019_PHONE,ID019_MAIL,ID019_EMAIL,ID027,ID030,ID037,ID076,ID077,ID081,ID092,ID093,ID094,ID097,REPLACE(REPLACE(ID098, CHAR(13), ''), CHAR(10), '') as ID098,REPLACE(REPLACE(ID099, CHAR(13), ''), CHAR(10), '') as ID099,REPLACE(REPLACE(ID100, CHAR(13), ''), CHAR(10), '') as ID100,ID101,ID103,ID104,ID120,ID121,ID134,ID135,ID136,ID139 from VW_CRM_CAMS_CORPORATE

select ID002,ID003,ID006,ID010,ID017,ID018,ID019_PHONE,ID019_MAIL,ID019_EMAIL,ID027,ID030,ID037,ID076,ID077,ID081,ID092,ID093,ID094,ID097,REPLACE(REPLACE(REPLACE(ID098, CHAR(13) + CHAR(10), ' '), CHAR(13), ' '), CHAR(10), ' ') as ID098,REPLACE(REPLACE(REPLACE(ID099, CHAR(13) + CHAR(10), ' '), CHAR(13), ' '), CHAR(10), ' ') as ID099,REPLACE(REPLACE(REPLACE(ID100, CHAR(13) + CHAR(10), ' '), CHAR(13), ' '), CHAR(10), ' ') as ID100,ID101,ID103,ID104,ID120,ID121,ID134,ID135,ID136,ID139 from VW_CRM_CAMS_CORPORATE