Oracle PLSQL Tutorial XML 49 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 based on single data type

5 Create table myTable of xmltype

6 Create xml attribute with xmlattribute function

7 Create xml element with xmlelement function

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

9 Demo EXTRACTVALUE use in the WHERE clause

10 Existsnode and where clause

11 Existsnode(myValue, ROWSET)

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

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

14 Extract(doc, messagegreetingtext())

15 Find rows that contain the ROWSETROW node

16 Get xdburitype

17 Individual fields from the XMLTYPEd column may be found using the EXTRACTVALUE function like this

18 Insert xml document to a XMLType column with xmltype function

19 Insert XML document to database

20 Must use a single-group group function with xmlattribute

21 Oracle support XPath predicate expressions

22 Oracle XML function ExistsNode

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

24 Query xmltype column

25 Reference one element

26 Retrieve value from SYS XMLTYPE column

27 SQL to XML

28 Store an XMLType type data in clob

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

30 Update xmltype type column

31 UPDATEXML function supports multiple elements

32 Use Aggregrate functions on XML data

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

34 Use extract function to get xmltype data

35 Use sys xmltype createxml to add XML data to table

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

37 Use the EXTRACT function and the following XPath

38 Use the UPDATEXML function to change element value

39 Use UPDATEXML function to update a portion of the doc

40 Use value function with single xmltype table

41 Use xdbURIType

42 Use XMLELEMENT to convert column data to xml format

43 Use xmltype to convert xml string to xmltype data

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

45 Xmlagg and xmlforest

46 XMLElement

47 XMLTYPE column

48 XMLTYPE with xml schema

49 XPath text() function