DBMS_DATA XML option

[partha]

How do you use this option?

 

[Marco Kalter]

I'm not quite sure what you mean. Can you elaborate?

 

[partha]

Right click on any table and click dbms_metadata - you have two options ddl and xml. What is the practical use of these?

 

[Marco Kalter]

It allows you to get a specification of the object in DDL or XML format, as generated by the dbms_metadata system package.

 

[partha]

Can you give a practical example of how I would use the xml output?

 

[Marco Kalter]

An XML definition of an object can be used for many purposes, such as version control, finding differences, reporting, and so on.

 

[partha]

Can you please elaborate with a detailed practical example?

 

[Bert Gombos]

Try this and examine results.