July 26, 2006

Changing Column Names in Oracle

Oracle does not have a mechanism by which you directly change column names. But this workaround is quick and efficient. Consider TableA: COLUMN_1 NUMBERCOLUMN_2 VARCHAR2(500)COLUMN_3 DATE You want to change

Using XMLSchema DOM and SAX in JAXP 1.2

To take advantage of the power of XMLSchema in a SAX or DOM application, you simply have to set two properties. In JAXP 1.3, use the javax.xml.validation package. The two

Add a Fresh Set of Records to a Dataset

When you execute a new query and populate an existing dataset, the newly retrieved records are appended to the existing records in the dataset. If you wish to remove the