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
|
|
Managing SQA Projects |
|
Managing SQA Projects No matter how big a project is there will always be a person who will be overseeing the whole project They are usually the project managers and in this case called the SQA managers SQA managers are always at the forefront of everything answering to the business manager regardin
|
|
Using XMLType for Handling XML Data in the Database |
|
Using XMLType for Handling XML Data in the Database Being an object type XMLType can not only be used to store XML data in the database but also to operate on that data via its built in methods Regardless of the storage model you choose XMLType provides a set of XML specific methods to operate on XM
|
|
Business Performance Management |
|
Business Performance Management What is Business Performance Management Business Performance Management is most commonly described as a set of processes that help companies or organizations optimize their business performance It is specifically designed to organize automate and analyze business meth
|
|
Querying a DOM Document with XPath |
|
Querying a DOM Document with XPath One way to access the DOM tree in a DOMDocument object is through an associated DOMXPath object Identifying a specifi c node or nodes within the DOM tree of a DOMDocument object with this approach involves use of appropriate XPath expressions passed to the DOMXPath
|
|
ODP.NET - Handling Nulls when Executing with ExecuteScalar |
|
ODP NET Handling Nulls when Executing with ExecuteScalar The most important issue to remember is that ExecuteScalar simply returns an object type of data The object refers to any data type within NET If the data type of your variable matches with the type of object returned by ExecuteScalar an impli
|
|
ODP.NET - OracleCommand Object |
|
ODP NET More About the OracleCommand Object Till now we have seen OracleCommand working with OracleDataReader OracleCommand is not simply meant for OracleDataReader It has got a lot of functionality for itself Let us see few of the most commonly used features of OracleCommand in this section We will
|
|
ODP.NET - Presenting Master-Detail Information Using a Dataset |
|
ODP NET Presenting Master Detail Information Using a Dataset As mentioned before a DataSet object can have its own relations between data tables existing in it We can add these relations dynamically at the client side within an application to represent master detail or hierarchical information The f
|
|
ODP.NET - Working with DataTableReader |
|
ODP NET Working with DataTableReader DataTableReader is complementary to a DataTable object and is mainly used as a type of Data Reader in the disconnected mode The following is the modified code mosgoogle geshibot language VB NET" create connection to db Dim cn As New OracleConnection D
|
|
ODP.NET - Retrieving a Single Row of Information Using OracleDataAdapter |
|
ODP NET Retrieving a Single Row of Information Using OracleDataAdapter In the previous example we worked with a set of rows in the DataTable object Now we shall work with a particular row using the DataTable object The following code accepts an employee number from the user and gives you the details
|
|
|
Online Test 
