Category: XMLDB

April 8

HOWTO: Query via Xpath position function

Based upon: http://forums.oracle.com/forums/thread.jspa?threadID=498374


SQL> select * from v$version;
 
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
 
5 rows selected.

Read the post

April 8

HOWTO: Manually create a XMLType table (OR / Schema based)

The Mark Drake Method (first steps to success)

begin
 dbms_xmlschema.registerSchema
(schemaURL => 'http://www.gralike.com/marco/HistorieWW/WWBase.xsd'
,schemaDoc => xdbURIType('/public/HistorieWW/WWBase.xsd').getClob()
,local     => FALSE
,genTypes  => TRUE
,genBean   => FALSE
,genTables => TRUE
);
end;
/

Read the post

April 8

HOWTO: Compile a XML Schema in XMLDB

Just a simple script I want to keep for posterity. The foundations were laid by…

Read the post

Bad Behavior has blocked 309 access attempts in the last 7 days.