1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
set head off
set linesize 32767
set heading off
set pagesize 0
set showmode off
set feedback off
set verify off
set tab off
timing start timer_1;
select o.id_objet,
lib_stock,
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(o.reference,CHR(10),'\r'),CHR(13),'\n'),CHR(09),'\t'),' ',' '),' ',' '),
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(i.source,CHR(10),'\r'),CHR(13),'\n'),CHR(09),'\t'),' ',' '),' ',' '),
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(o.titre_court,CHR(10),'\r'),CHR(13),'\n'),CHR(09),'\t'),' ',' '),' ',' '),
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(o.legende,CHR(10),'\r'),CHR(13),'\n'),CHR(09),'\t'),' ',' '),' ',' '),
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(i.localcaption,CHR(10),'\r'),CHR(13),'\n'),CHR(09),'\t'),' ',' '),' ',' '),
(SELECT wm_concat(iptc_keyword) FROM iptc_keywords WHERE o.id_objet=iptc_keywords.id_objet )"keywords"
from objets o, iptc i,stocks s
where o.id_objet=i.id_objet
and o.id_stock = &id_stock
and o.id_stock=s.id_stock order by lib_stock;
exit; |
Partager