Category: Howto

April 16

HOWTO: Create DDL statements from XML

This was once posted on a Oracle OTN XMLDB forum; and though I thought it was easy, it wasn’t at all. It took me some sweat and I learned more about XPath than I had done so far and the (in)possibilities of using XPath within an Oracle database… All in all it was a good exercise.

Also see: http://forums.oracle.com/forums/thread.jspa?threadID=495729&tstart=0

Read the post

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

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