Questions tagged [ora-01481]
8 questions
1
vote
2 answers
ORA-01481: invalid number format model in oracle insert query
I have below query where i am getting error as
ORA-01481: invalid number format model
The user is attempting to either convert a number to a string via TO_CHAR or a string
to a number via TO_NUMBER and has supplied an invalid number format model…
Andrew
- 3,632
- 24
- 64
- 113
1
vote
2 answers
show currency in APEX in euro's
In Oracle's apex you can do to_char( moneycolumn, '$9,999.99').
But when I do to_char( moneycolumn, '€9.999,99')
I get: ORA-01481: invalid number format model
So how can I convert float values to euro format like:
€400,-
€4,99
€1.000,23…
botenvouwer
- 4,334
- 9
- 46
- 75
1
vote
1 answer
invalid number format model oracle error inserting a char
I am trying to create an Oracle stored procedure that simply inserts a row into a table. There is a column in the table (MEAS_IND) that is type char(1 byte) and cannot be null. When I try to insert any one character into the column/table I get the…
indianapolymath
- 323
- 1
- 4
- 15
0
votes
1 answer
ORA-01481: invalid number format model at to_date
this is my table:
create table exemplare(
id integer,
id_tierart integer not null,
name varchar2(32),
details varchar2(32),
geburtsdatum date,
kaufdatum date,
constraint pk_exemplare_id primary key(id),
…
MP13
- 390
- 3
- 11
0
votes
2 answers
Oracle conversion causes error
Can anyone explain what is wrong with this SQL?
SELECT TO_CHAR(1890.55,'$9,99D9V99') FROM DUAL;
it throws an error:
ORA-01481: invalid number format model
01481. 00000 - "invalid number format model
Cause: The user is attempting to either…
Rahul
- 49
- 8
0
votes
1 answer
SQL TO_CHAR TO_NUMBER TO_DATE
I have the following expression
WHERE TO_CHAR(TO_DATE(dab.SNAPSHOT_DAY,'YYYYMMDD'),'MM') >=
TO_CHAR(TO_DATE('{RUN_DATE_YYYYMMDD}','YYYYMMDD'),'MM') -1
'{RUN_DATE_YYYYMMDD}' returns the date of when the data was captured.
I get the following…
alexparq
- 13
- 5
0
votes
2 answers
char value and date value comparison in query
one column (txn_issue_dt) is char and issue_dt is date and I am attempting to compare the two but I am self taught and I am stumped, please help.
SELECT ptf.carrid,
ptf.cov_effdt,
ptf.cvg_id,
ptf.err_msg,
ptf.error_id,
…
Jdeezy4
- 1
-1
votes
3 answers
TO_CHAR failing to set specific format in update
I'm trying to set a specific field in a record where the legacy code has used a DDMM format DATETIME as a char. I want to be able to find one specific value that matches something and basically change that one field. Super simple stuff,…
solarflare
- 423
- 3
- 14