Search Results

It is working.

I use the following:

set pagesize 0;
set serveroutput on
set termout off
set verify off
set heading off
set long 999
set lines 999
SET FEEDBACK OFF
SET HEAD OFF

SELECT...

Because I need to select a sequence or a value from the database. Instead
SELECT '<ns1:messageId>' || ' ' || imk.nextval || '</ns1:messageId>' FROM dual;
it could be
select value from...

I am not sure I understand your question at all but... the data which is populated is two types:
1. is results of queries which come directly from the oracle database
2. is fixed values.

I am...

Thanks for the good idea.

I will use CONCAT to export the values from the database + tags. Like this:
SELECT '<ns1:messageId>' || ' ' || seq.nextval || '</ns1:messageId>' FROM...

Hello,

I need help for writing a script that fills already generated xml file with data from oracle database and random sequences.

For example if we have the following tags:
<ns1:message>
...