Database Utilities (MOSC)

MOSC Banner

DBMS_METADATA: How to transform a DDL "create sequence scott.seq" into it an xml like dbms_metadata

edited Jun 9, 2013 9:36AM in Database Utilities (MOSC) 6 commentsAnswered
Dear all,
DBMS_METADATA: How to transform an sql "create sequence scott.seq" into it an xml like dbms_metadata without creating the objects?

From an DDL SQL Statement, it's needed to get it's xml represenetation in order to be able to compare this DDL with an already existing objects.

SQL  := 'create sequence scott.seq' ;
XML := '
<?xml version="1.0"?><ROWSET><ROW>
  <SEQUENCE_T>
 <VERS_MAJOR>1</VERS_MAJOR>
 <VERS_MINOR>0</VERS_MINOR>
 <OBJ_NUM>84822</OBJ_NUM>
 <SCHEMA_OBJ>
  <OBJ_NUM>84822</OBJ_NUM>
  <OWNER_NUM>152</OWNER_NUM>
  <OWNER_NAME>SCOTT</OWNER_NAME>
  <NAME>SEQ</NAME>
  <NAMESPACE>1</NAMESPACE>
  <TYPE_NUM>6</TYPE_NUM>
  <TYPE_NAME>SEQUENCE</TYPE_NAME>

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center