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
|
|
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
|
|
ODP.NET - Working with OracleDataAdapter with OracleCommand |
|
ODP NET Working with OracleDataAdapter together with OracleCommand In the previous examples we worked with OracleDataAdapter by directly specifying SQL statements You can also pass OracleCommand to OracleDataAdapter This is very useful if you deal with stored procedures covered in Chapter 5 or bind
|
|
ODP.NET - Working with Bind Variables together with OracleParameter |
|
ODP NET Working with Bind Variables together with OracleParameter With the help of OracleParameter you can include bind variables within any SQL statement These bind variables are nothing but run time query parameters The values in the SQL statement are bound at run time when we use bind variables m
|
|
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 - 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
|
|
Business Intelligence History |
|
Business Intelligence History When did Business Intelligence first come into play Before the Information Age of the late 20th century companies had to collect their information from non automated sources Those were the days that businesses lacked any type of sophisticated computing resources to enab
|
|
Star Topology |
|
Star Topology Star Topology is the most common type of network topology that is used in homes and offices In the Star Topology there is a central connection point called the hub which is a computer hub or sometimes just a switch In a Star Network the best advantage is when there is a failure in cabl
|
|
Microsoft AJAX Library - Functions as Variables |
|
Functions as Variables In JavaScript functions are first class objects This means that a function is regarded as a data type whose values can be saved in local variables passed as parameters and so on For example when defining a function you can assign it to a variable and then call the function thr
|
|
|
