RE: comma_to_table cannot convert a list of numbers ??

2001-10-03 Thread Nicoll, Iain (Calanais)
Probably your nls_numeric_characters are ., (look at the nls_session_parameters view) (comma will be for thousands parameter). You should be able to change it with an alter session but I can't see how yet. Iain Nicoll -Original Message- Sent: 03 October 2001 13:56 To: Multiple

RE: comma_to_table cannot convert a list of numbers ??

2001-10-03 Thread Nicoll, Iain (Calanais)
ALTER SESSION SET nls_numeric_characters = './' where / is the group separator. You could change this to something that you would never come across. -Original Message- Sent: 03 October 2001 13:56 To: Multiple recipients of list ORACLE-L List, i'v been trying out a simple use of