Edit Values ??- Oracle

[informatica@cofina.com.br]

I'm using Oracle 10G Express. I created a table with several Number type fields (14.2).
When I'm inserting values ??he only accepts if I type the point as a house deciamal, so much, but it's okay to do the edition of another record already typed I have to go through all these fields and change it. If contrary, I can not record the data.
What to do to improve this?
Have a solution?
I have already changed the decimal symbol of my windows to. But nothing has changed.

Thanks

[dr_gori]

You can run an alter session. Then it will change only for the current session.

Select all

SQL> alter session set NLS_NUMERIC_CHARACTERS=',.'; 
 
Session altered. 
 
SQL> select 12345.67 from dual; 
 
  12345.67 
---------- 
  12345,67 
 
SQL> alter session set NLS_NUMERIC_CHARACTERS='.,'; 
 
Session altered. 
 
SQL> select 12345.67 from dual; 
 
  12345.67 
---------- 
  12345.67 
 
SQL> 

Unfortunately, there is no way to rotate Alter System for this command. http://www.orafaq.com/parms/parm1322.htm
only changing the Oracle parameter.

[informatica@cofina.com.br]

I continue with the same problem.
Visually when I give a Select OK, but when when I enter the NLS it continues the same way by making it in the registry edition I have to change the, by.

Thanks

[diegolenhardt]

In Regedit has an Oracle entry,
in,

Select all

HKEY_LOCAL_MACHINE > Software > ORACLE

there is something like nls_lang ???

How are you?

[informatica@cofina.com.br]

brazilian Portuguese

[diegolenhardt]

Makes there in the bank: show parameters nls

[informatica@cofina.com.br]

By the site shows brazilian in the sql (prompt) command shows american. In regedit brazilian portuguese

I do not understand anything else.

[diegolenhardt]

On the Oracle website when you will download Oracle Express, there are two links, oracle and oraclexeuniv,

Which one did you download ????

Is your Windows English?

[informatica@cofina.com.br]

I downloaded oraclexeuniv, and my windows is in Portuguese

[informatica@cofina.com.br]

The funny thing is that when the data is being shown they appear with the, when I ask to edit the line shows the, only yours I have recording memos without changing anything I can not, then I need to change the, by.
But after recording he comes back to show me with the,

[diegolenhardt]

I should have downloaded the other, rs



attempts to change his regedit, lá in the NLS_LANG places American,

American_america.we8iso8859p1

does this test aí

[informatica@cofina.com.br]

I can still install the other because I'm just starting now if I change the language users will realize the exchange of the decimal house?

[diegolenhardt]

I believe that no, I think this comes from the client configuration,

In fact, I always used the other version,

I never had problems,

= /

[informatica@cofina.com.br]

Do you use the Browse itself or any other application to manage it?
When you ask to edit a line with numerical values ??as he sees the decimal house (or.)?
I have tried to install the other version (English) but I have not succeeded continues everything as before: if you query via command line the NLS parameters it shows the language and language America / American. Via Bank's website EME shows Brazil / Brazilian Portuguese.
both via the command line or bank site I type the commands to change the language only that soon after consult and it does not change anything and also does not deliver error message in the commands. Apparently only solves the problems in SELECT bad is as if it did not change anything in the bank.
I'm almost giving up please help.

Thanks

[dr_gori]

So, for us to understand better, put the following information:
* Are you using which tool to do this? (SQL * plus, toad, some other, etc.)
* Which command are you running? Also place the bank's response.

If we can see what's happening there, certainly someone will be able to help ...

[informatica@cofina.com.br]

I am using via http://127.0.0.1:8080/apex
in SQL commands I am trying:

Select all

ALTER SESSION SET NLS_NUMERIC_CHARACTERS=".,";

No error is displayed, but when consulting NLS it shows how it was before , i.e ",."

When I enter Edit a record it shows all the numbers with the "," as a decimal house, but I have to change everything from "," to "." to save the changes.

Now that changes the regional Windows properties (control panel) to English (United States) when editing a record it already shows you with "." As a decimal house there during the change in the registry I do not need to make the exchange and it works.
The only question is that I would like to leave the conf. Windows Brazil (portuguese) and non-English, but if you do not have another way to do what?