Hi,

I have a XMLPayload like
?xml version='1.0' encoding='UTF-8' ?>
<METADATA>
<SCHEMA>
<NAME></NAME>
<TABLE>
<TABLE_SCHEM></TABLE_SCHEM>
<TABLE_NAME></TABLE_NAME>
<TABLE_TYPE></TABLE_TYPE>
<COLUMN>
<TABLE_SCHEM></TABLE_SCHEM>
<TABLE_NAME></TABLE_NAME>
<COLUMN_NAME></COLUMN_NAME>
<DATA_TYPE></DATA_TYPE>
<TYPE_NAME></TYPE_NAME>
<COLUMN_SIZE></COLUMN_SIZE>
</COLUMN>
<COLUMN>
<TABLE_SCHEM></TABLE_SCHEM>
<TABLE_NAME></TABLE_NAME>
<COLUMN_NAME></COLUMN_NAME>
<DATA_TYPE></DATA_TYPE>
<TYPE_NAME></TYPE_NAME>
<COLUMN_SIZE></COLUMN_SIZE>
</COLUMN>
<COLUMN>
<TABLE_SCHEM></TABLE_SCHEM>
<TABLE_NAME></TABLE_NAME>
<COLUMN_NAME></COLUMN_NAME>
<DATA_TYPE></DATA_TYPE>
<TYPE_NAME></TYPE_NAME>
<COLUMN_SIZE></COLUMN_SIZE>
</COLUMN>
<COLUMN>
<TABLE_SCHEM></TABLE_SCHEM>
<TABLE_NAME></TABLE_NAME>
<COLUMN_NAME></COLUMN_NAME>
<DATA_TYPE></DATA_TYPE>
<TYPE_NAME></TYPE_NAME>
<COLUMN_SIZE></COLUMN_SIZE>
</COLUMN>
</TABLE>
</SCHEMA>
</METADATA>
 

I am retriving a table name first.
and then I have to retive all the coulmn name belong to that specific table,but this I have to do in some other class where I am getting only the table name as an input.
 

Please let me know how to do this.I have used XPATH to retrive all the table name.

Thanks and Regards
Savita
 
 
 

Reply via email to