Oracle Jdeveloper uploads XML files to Dynamic Data Tables

1. Create required data

1. CREATE TABLE "TEST"
2. (
3. "ID"NUMBERNOT NULLENABLE,
4. "NAME"VARCHAR2 (50 BYTE)NOT NULLENABLE,
5. "AGE"NUMBERNOT NULLENABLE,
6. "DEPT"VARCHAR2 (50 BYTE)NOT NULLENABLE,
7. CONSTRAINT "TEST_PK" PRIMARY KEY("ID") ENABLE
8. )

XML file to be imported into the database

1. <?Xml Version="1.0" Encoding=UTF-8" ?>
2. <List>
3. <Persons>
4. <Id>001</Id>
5. <Name>Zhang San</Name>
6. <Age>34</Age>
7. <Dept>Sales Department</Dept>
8. </Persons>
9. <Persons>
10. <Id>002</Id>
11. <Name>Li Si</Name>
12. <Age>25</Age>
13. <Dept>Sales Department</Dept>
14. </Persons>
15. <Persons>
16. <Id>003</Id>
17. <Name>James</Name>
18. <Age>30</Age>
19. <Dept>Sales Department</Dept>
20. </Persons>
21. </List>

2. Create a fusion web application --> ImpXML

Create a VO object based on the test table. Because we want to import data to the table, this VO object should have no data at first, so we need to set it in the query.

Where 1 = 0 query condition, so that the initial row set is empty. For example:

 

 

 

 

1 2 3 Next Page