0 Votes Vote

ODP.NET - Handling Nulls when Working with OracleDataReader in Tech Notes    by admin on 28 Apr 2008, 08:54 ODP.NET - Handling Nulls when Working with OracleDataReader When we work with OracleDataReader (or for that matter, even with data rows in a data table), we may come across nulls. The following is the efficient way to deal in with such scenarios: Total Hits: 25      0 Comments Add Comment  Visit

---

0 Votes Vote

ODP.NET - Working with Bind Variables together with OracleParameter in Tech Notes    by admin on 28 Apr 2008, 08:54 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.... Total Hits: 26      0 Comments Add Comment  Visit

---

0 Votes Vote

ODP.NET - Working with OracleDataAdapter with OracleCommand in Tech Notes    by admin on 28 Apr 2008, 08:54 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... Total Hits: 21      0 Comments Add Comment  Visit

---

0 Votes Vote

ODP.NET - Techniques to Improve Performance while Retrieving Data in Tech Notes    by admin on 28 Apr 2008, 08:54 ODP.NET - Techniques to Improve Performance while Retrieving Data Performance tuning is a great subject in Oracle. Volumes of books would not be enough to cover every aspect of performance tuning in Oracle. However, in this section, we will only discuss the fundamental performance techniques while working... Total Hits: 25      0 Comments Add Comment  Visit

---

0 Votes Vote

Business Intelligence Applications in Tech Notes    by admin on 28 Apr 2008, 08:54 Business Intelligence Applications In this article we are going to take some time to discuss the various applications that are normally provided with Business Intelligence Systems. Total Hits: 24      0 Comments Add Comment  Visit

---

0 Votes Vote

PHP Oracle Web Development in Tech Notes    by admin on 28 Apr 2008, 08:54 PHP Oracle Web Development Data processing, Security, Caching, XML, Web Services, and Ajax The book is written by Yuli Vaseliev, a well known author of different web development and programming books. PHP Oracle Web Development: Data processing, Security, Caching, XML, Web Services, and Ajax is a good... Total Hits: 25      0 Comments Add Comment  Visit

---

0 Votes Vote

XML Processing in PHP and Oracle Applications in Tech Notes    by admin on 28 Apr 2008, 08:54 Processing XML in PHP/Oracle Applications As mentioned, there are two alternatives when it comes to performing XML processing in your PHP/Oracle application. You can perform any required XML processing using either PHP's XML extensions (or PEAR XML packages) or Oracle's XML features. Total Hits: 24      0 Comments Add Comment  Visit

---

0 Votes Vote

Creating XML with the DOM PHP Extension in Tech Notes    by admin on 28 Apr 2008, 08:54 Creating XML with the DOM PHP Extension In fact, the PHP DOM extension is a set of classes that can be used to generate, access, and manipulate XML data. The DOM.php script defined in the following listing shows how to generate an XML document based on the result set retrieved from the database. Total Hits: 25      0 Comments Add Comment  Visit

---

0 Votes Vote

Querying a DOM Document with XPath in Tech Notes    by admin on 28 Apr 2008, 08:54 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... Total Hits: 26      0 Comments Add Comment  Visit

---

0 Votes Vote

Transforming and Processing XML with XSLT in Tech Notes    by admin on 28 Apr 2008, 08:54 Transforming and Processing XML with XSLT In the preceding example, you transform XML into HTML directly in your script, wrapping the data extracted from the XML document into appropriate HTML tags. Alternatively, you might perform an XSL (Extensible Stylesheet Language) transformation to get the same... Total Hits: 22      0 Comments Add Comment  Visit

---

0 Votes Vote

Performing XML Processing inside the Database in Tech Notes    by admin on 28 Apr 2008, 08:54 Performing XML Processing inside the Database When building XML-enabled applications on top of Oracle, there are many advantages to performing the XML processing inside the database when compared to performing it on the client. The key advantages to perform XML processing inside the database are as follows:... Total Hits: 24      0 Comments Add Comment  Visit

---

0 Votes Vote

Moving All the XML Processing into the Database in Tech Notes    by admin on 28 Apr 2008, 08:54 Moving All the XML Processing into the Database In the preceding example, the database server performs only a part of the XML processing while the rest is still performed by the PHP engine. Specifically, the database server generates an employees XML document based on the records from the hr.employees... Total Hits: 28      0 Comments Add Comment  Visit

---

0 Votes Vote

Why SQA in Tech Notes    by admin on 28 Apr 2008, 08:54 Why SQA There are so many reasons why a company should consider SQA. It is all about business survival and SQA is just one of the many tools the company should effectively use. And just like a tool, it has to be effectively used to its maximum. If the tool is not used to its full extent, the tool will... Total Hits: 26      0 Comments Add Comment  Visit

---

0 Votes Vote

Business Performance Management in Tech Notes    by admin on 28 Apr 2008, 08:54 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... Total Hits: 29      0 Comments Add Comment  Visit

---

0 Votes Vote

Identifying SQA Issues in Tech Notes    by admin on 28 Apr 2008, 08:54 Identifying SQA Issues Software Quality Assurance is a good practice that every large scale business should employ. IT related businesses have never hesitated to use SQA to ensure that the application they will release for their users or sell to their customers will live up to their expectations. Total Hits: 25      0 Comments Add Comment  Visit

---

0 Votes Vote

Performing XSLT Transformations inside the Database in Tech Notes    by admin on 28 Apr 2008, 08:54 Performing XSLT Transformations inside the Database Now that you have the employees XSL stylesheet stored in the database and the xmlusr schema is permitted to access the hr.employees table, you can create a script that will instruct the database to build an HTML page based on the data stored in hr.employees.... Total Hits: 21      0 Comments Add Comment  Visit

---

0 Votes Vote

Using Oracle Database for Storing, Modifying, and Retrieving XML Data in Tech Notes    by admin on 28 Apr 2008, 08:54 Using Oracle Database for Storing, Modifying, and Retrieving XML Data With Oracle XML DB, you have various XML storage and XML processing options allowing you to achieve the required level of performance and scalability. One of the most interesting things about Oracle XML DB is that it allows you to... Total Hits: 20      0 Comments Add Comment  Visit

---

0 Votes Vote

Using XMLType for Handling XML Data in the Database in Tech Notes    by admin on 28 Apr 2008, 08:54 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... Total Hits: 23      0 Comments Add Comment  Visit

---

0 Votes Vote

Business Intelligence Tips in Tech Notes    by admin on 28 Apr 2008, 08:54 Business Intelligence Tips Understand Your Organization first Truly understanding your company and how it works is perhaps one of the most important Business Intelligence tips anyone can offer. This includes understanding the business itself, the processes involved, the data, and how that data is used... Total Hits: 21      0 Comments Add Comment  Visit

---

0 Votes Vote

Managing SQA Projects in Tech Notes    by admin on 28 Apr 2008, 08:54 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 regarding... Total Hits: 21      0 Comments Add Comment  Visit

---