Oracle PLSQL XML 42 codes

1 Call existsNode() function from xmltype data

2 Count() and existsnode()

3 Create a table to hold the simple Hello World XML document

4 Create table myTable of xmltype

5 Create xml attribute with xmlattribute function

6 Create xml element with xmlelement function

7 Creation of tables using XMLType data type and set the xml schema

8 Dbms_metadata get_xml

9 Existsnode and where clause

10 Existsnode(myValue, ROWSET)

11 Extract can be used in WHERE clause to search xml document

12 Extract returns a COLLECTION of values (a repeating node)

13 Extract(doc, messagegreetingtext())

14 Find rows that contain the ROWSETROW node

15 Get xdburitype

16 Insert xml document to a XMLType column with xmltype function

17 Must use a single-group group function with xmlattribute

18 Oracle support XPath predicate expressions

19 Oracle XML function ExistsNode

20 PLSQL ability to access text within an XML document in the database

21 Query xmltype column

22 Reference one element

23 Store an XMLType type data in clob

24 Update (i e replace) the entire XMLType column with new content

25 Update xmltype type column

26 UPDATEXML function supports multiple elements

27 Use Aggregrate functions on XML data

28 Use extract function and xpath function to retrieve xml element data

29 Use extract function to get xmltype data

30 Use Text() function to get text value from xml string

31 Use the EXTRACT function and the following XPath

32 Use the UPDATEXML function to change element value

33 Use to_clob to save xml string to a clob type column

34 Use UPDATEXML function to update a portion of the doc

35 Use value function with single xmltype table

36 Use xmltype to convert xml string to xmltype data

37 Without the text() operator, returns node name + text value

38 Xmlagg and xmlforest

39 XMLElement

40 XMLtype column

41 XMLTYPE with xml schema

42 XPath text() function