Performing DML Operations on XML Schema Based XMLType Views |
|
Performing DML Operations on XML Schema Based XMLType Views Analyzing the underlying query of the empSch v view discussed in the preceding section you may note that each attribute of the EMP T object used in the select list maps to a certain column of a single table namely emps What this means in pr
|
|
Using XMLType Views |
|
Using XMLType Views Using XMLType Views XMLType views provide a convenient way to construct XML representations of relational data without physically migrating that data into XML Once written an XMLType view may be used in various queries making them simpler and so increasing their readability mosgo
|
|
Retrieving XML Data |
|
Retrieving XML DataTo retrieve XML data from an XMLType table you can use a SELECT SQL statement just as you would if you had to query a relational table For example to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section you might issue the
|
|
ODP.NET - Retrieving Multiple Rows on to the Grid |
|
ODP NET Retrieving Multiple Rows on to the Grid In the previous section we tried to retrieve only one row using OracleDataReader In this section we will try to retrieve more than one row or a result set and populate a DataGridView on a WinForm mosgoogle The following code lists out the details of al
|
|
SQL Server Integration Services |
|
SQL Server Integration Services Here is a sample chapter from Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy Environment set up for Visual Studio 2005 with respect to SSIS and multiple tasking Connecting to Microsoft Access Text Files Excel S
|
|
Switched Multi Megabit Data Service (SMDS) |
|
Switched Multi Megabit Data Service SMDS SMDS or Switched Multi Megabit Data Service is used to communicate on the Public Data Networks using the WAN networking technology The SMDS technology uses fiber or copper wires for networking There are many components in the SMDS networking environment that
|
|
jQuery - Column Highlighting |
|
Learning jQuery Column Highlighting It can be a nice user interface enhancement to visually remind the user of what has been done in the past By highlighting the column that was most recently used for sorting we can focus the user s attention on the part of the table that is most likely to be releva
|
|
jQuery - Finessing the Sort Key |
|
Learning jQuery Finessing the Sort Keys Now we want to apply the same kind of sorting behavior to the Author s column of our table By adding the sort alpha class to its table header cell the Author s column can be sorted with our existing code But ideally authors should be sorted by last name not fi
|
|
jQuery - Basic Alphabetical Sorting |
|
Learning jQuery Basic Alphabetical Sorting Now let s perform a sort on the Title column of the table We ll need a class on the table header cell so that we can select it properly geshibot lang html" Title Author s Publish Date Price geshibot mosgoogle To perform the actual s
|
|
N-Tier Architecture: Data Access Layer |
|
N Tier Architecture Data Access Layer In an N Tier architecture the data access layer consists of components that aid one in the process of accessing the database When it is used correctly the data access layer serves as an abstract level for the structures of the database Simple changes that are ma
|
|
|
Online Testing (31)
Brain Gym (1)