TAILIEUCHUNG - Oracle Database 10g The Complete Reference phần 8

Tham khảo tài liệu 'oracle database 10g the complete reference phần 8', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 928 Part VIII Hitchhiker s Guides xsd attributeGroup ref productDetails xsd complexType xsd element xsd attributeGroup name productDetails xsd attribute name productID use required type xsd ID xsd attribute name name use required type xsd string xsd attribute name description use required type xsd string xsd attribute name unit type xsd positiveInteger xsd attribute name price use required type xsd decimal xsd attribute name stock type xsd integer xsd attributeGroup You can enforce uniqueness within a document instance by using xsd unique agx-. xsd unique name uniqueProductID xsd selector xpath tc Product xsd field xpath tc @productID xsd unique Uniqueness is declared at the same level as the complex type definition for the Product element. The tc namespace is for the schema you are creating and is declared in the xsd schema element. The xsd selector value specifies the elements to constrain the Product elements and xsd field specifies the attribute to constrain productID . You can use xsd key and xsd keyref to create references between elements. For example you can create a Customer element and then reference it from multiple Invoice elements xsd key name customerID xsd selector xpath tc SalesData xsd field xpath tc Customer @CustID xsd key xsd keyref name item refer customerID xsd selector xpath tc SalesData xsd field xpath tc Invoice @CustID xsd keyref To allow an element to be NULL use the nillable attribute xsd element name FlightDinner nillable true Using XSU to Select Insert Update and Delete XML Values You can use Oracle s XML-SQL Utility XSU to convert the result of a SQL query to XML. XSU supports dynamic generation of DTDs and the insertion of XML into database tables. You can also use XSU to update or delete rows from database objects. Chapter 47 The Hitchhiker s Guide to XML in Oracle 929 You can access XSU via Java and PL SQL APIs application programming interfaces . The XSU Java classes are part of the Oracle kernel software. The PL SQL API is a .

TÀI LIỆU LIÊN QUAN
TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.