Hi all,
CREATE TABLE XX_QUOTES
(
COLUMN1 VARCHAR2(250 BYTE)
)
insert into XX_QUOTES values ('""" КОМПАНИЯ ЗА ЛУКСОЗНИ ХОТЕЛИ"" АД"');
insert into XX_QUOTES values ('"""100-ЕВ"" ООД"');
insert into XX_QUOTES values ('"""АВИОКОМПАНИЯ БАЛКАН"" АД /В НЕСЪСТО"');
insert into XX_QUOTES values ('"""АКУПЛАСТ"" АД"');
commit;
Please, how to update those rows and exclude the quotes?
expected result for the first row:
" КОМПАНИЯ ЗА ЛУКСОЗНИ ХОТЕЛИ" АД
...And let us consider we have 10000 rows in that table and there is no point to update row by row.
version:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
"CORE 11.1.0.7.0 Production"
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
Thanks in advance,
Bahchevanov.