z.B. als Auswahlliste:
create or replace view ahp_w3_start.INET_ANFRAGE_LIST as
SELECT
substr( cast( (xpath( '/article/h3/a/text()', content_elements))[1] as varchar), 1, 1) as ART_TITLE_OG,
concat( 'zu ', cast( (xpath( '/article/h3/a/text()', content_elements))[1] as varchar)) as ART_TITLE,
concat( 'Anfrage zu ', cast( (xpath( '/article/h3/a/text()', content_elements))[1] as varchar)) as ART_TITLE_TEXT
from
ahp_w3_start.inet_content_qry
where
xml_is_well_formed_document( cast( content_elements as text)) = true
and xpath_exists('/article/h3/a/text()', content_elements) = true
order by
1, 2
;
##2073 demo-online -- -
- 1 - (TxtDoc-1015-2026-04-17.html)