Question:
I was working on this job and tried to insert values as follows:
insert into
posamezna_zival(ID_zivali, Datum_rojstva, Spol, Namestitev, Mati,
Oce, Prihod, Odhod, Sorta_FK, Kupec_FK)
values ('SI 9267 9903', 1.4.2010, 'M', 'hlev 4', 'SI 42144700', 'SI
707005', 1.4.2010, 'XXX', 3, 'XXX);
but then I get this error message:
ORA-01756: quoted string not properly terminated
How do I fix this problem?
Answer:
To diagnose any
error, you start by using the
oerr utility to display the ORA-01756 error:
ORA-01756:
quoted string not properly terminated
Cause: You
tried to execute a statement that contained a string that was not
surrounded by two single quotes. One of the quotes was entered
without the second accompanying quote.
Action:
Rewrite the statement so that the string is surrounded by two single
quotes.
The key is to look for a quoted string that is not properly terminated.
Look at your statement and find where you are missing a quotation mark. It's not
too hard to spot it.
For example, if you were trying the following:
SELECT author_id,
author_name
FROM authors
WHERE author_name = 'Burleson;
You can correct this SQL statement by surrounding the string (ie:
Burleson) with two single quotes as follows:
SELECT author_id, author_name
FROM authors
WHERE author_name = 'Burleson';
So, looking back at your statement, it is easy to
correct the problem. Here's the correction, with the addition of a single
quotation mark to surround that last string with two single quotes:
insert into
posamezna_zival(ID_zivali, Datum_rojstva, Spol, Namestitev, Mati,
Oce, Prihod, Odhod, Sorta_FK, Kupec_FK)
values ('SI 9267 9903', 1.4.2010, 'M', 'hlev 4', 'SI 42144700', 'SI
707005', 1.4.2010, 'XXX', 3, 'XXX');
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
