New answers tagged oracle-11g
0
votes
NLS_NUMERIC_CHARACTERS in SQL loader control file
If you are certain the decimal separator is dot, you can directly use it in format pattern, for example
"TO_NUMBER(:MyVariable, '9999999999.999999')"
I was solving similar problem and found ...
Top 50 recent answers are included
Related Tags
oracle-11g × 717oracle × 525
oracle-11g-r2 × 88
plsql × 45
oracle-12c × 33
oracle-10g × 28
oracle-sql-developer × 23
sqlplus × 21
performance × 19
rman × 19
backup × 16
partitioning × 14
installation × 14
listener × 14
optimization × 13
linux × 12
query-performance × 11
permissions × 11
trigger × 11
datapump × 11
join × 10
query × 10
view × 10
database-design × 9
select × 9