Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips
Tip Bank > XML > Data Management

Data Management

1-20 of 34     Previous     Next
Remove DataLinks in an Excel Workbook Programmatically
by Srinath MS
This is useful when you have an object such as a Chart in a workbook that depends on data from another workbook.
Creating Tables in the Default Tablespace
by MS Sridhar
Most users typically create tables in the default tablespace. Most of them are not familiar with the actual tablespaces concept and are not aware that this is responsible for the issues they encounter when large data is pumped into said tables.
A Quick Way to Obtain create table Statements
by Sriram Swaminathan
Learn about this quick, easy way to obtain create table statements in the table view of Enterprise Manager.
Use Oracle and Triggers to Secure Table Data
by Sridhar MS
Ever deleted some tables accidently and had to waste your time doing them all over again? Oracle, in conjunciton with Triggers, provides an easy solution to this problem.
Make Cell Data Visible with a MouseMotionListener
by Jeevan Joseph
Learn how to use a MouseMotionListener to render the contents of a cell visible.
Using Insert Iterators
by Saurabh Ramya
Insert iterators come in very handy when you need to populate a container using an STL algorithm which uses an assignment operator to fill in the data.
Read Time Zone Names Stored in the Registry
by Dinesh Asanka
The following code reads the time zone names stored in the registry and places those names in a combobox.
Generating a Sequence of Numbers in SQL Server
by Raj Chidipudi
This tip shows you how to fill the dropdown lists on a Web page, Combo box, or List box in a Windows application.
List All the Tables with a Foreign Key Constraint
by Parthasarathy Mandayam
Use this code in Query Analyzer to list all tables with foreign key constraints.
Use Oracle's VARRAY Through JDBC
by Vijayanandraj Amaladoss
This code snippet demonstrates how to use Oracle's VARRAY through JDBC.
Uploading a Large Number of Records in DB2
by Gautham Muthuravichandran
A myriad of database configuratrion issues can pop up while you're performing database-intensive operations. This tip outlines solutions to some common problems.
Look Up a DataSource Object in Your Web Server
by Sujata De
This code demonstrates how to look up a DataSource object in your Web server using JNDI Lookup.
How to Use an XPath on a DataSet
by Sonu Kapoor
This tip shows you the used classes, the XML file, the code and the output for using an XPath on a DataSet.
Using XPathDocument in XPath Queries
by Sonu Kapoor
This tip shows how to use the .NET class XPathDocument instead of XmlDocument when you're working with XPath queries.
Create a Sortable Column Dynamically
by Ian Lane
Learn how to customize the sorting of your resultset using the CASE function.
Dynamically Create a Sortable Column
by Ian Lane
Get Details of the Aggregated Data
by Dinesh Asanka
Get Separate Records for the Comma Delimited Values of One Field (TSQL)
by K.Nageswara Rao
Serialize Data Using a PropertyBag
by Mike Kurtz
Get the Average Value Across the Columns by Using the AVG() Function
by K.Nageswara Rao
1-20 of 34     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date