(Phil Zoio) It wasn’t too long ago that quality assurance (QA) teams played the leading (if not the only) role when it came to software testing. These days, however, developers are making an enormous contribution to software quality early in the development process, using automated unit-testing tech
Tag: Oracle
Samsonite to dump Oracle under SAP program
(Robert Westervelt) SAP is highlighting its latest customer win under its broadened Safe Passage program, which was launched to lure away newly acquired PeopleSoft, J.D. Edwards Co. and Retek customers from Oracle onto SAP. (R)
A View of Creating an Oracle User – Part II
(James Koopmann) In Part I of this series, a methodology was given on how to create a user. If you did not get a chance to read Part I, please do so now before continuing with Part II, as Part II builds upon Part I and requires an understanding of how a basic user is created.
Mitigate Business Intelligence Project Risks with Rule-Based Audits and Proof-of-Concepts
(Michael L. Gonzales) This white paper describes two methods for minimizing the risk associated with BI iterations: Rule-Based Audits and Proof-of-Concepts. Independently used, each will help you clarify and better understand risk points associated with your project. (R)
Simulate variable arguments in PL/SQL
(Scott Stephens) There are different approaches that try to simulate variable arguments. However, since Oracle 8, there is a better method that developers often don’t consider: using a simple VARRAY to wrap the variable portion of code.
Oracle SQL and PL/SQL Development and Maintenance Concepts
Database programming has recently become more of a distinct discipline among other types of programming. Within this distinct discipline, Oracle — the predominant database server — has specific programming considerations, such as a dedicated programming language —PL/SQL, significant control over th
Using the OracleCommand Object (Sample Chapter)
(Michael Otey and Denielle Otey) In this article, you will learn how to use the OracleCommand object to execute SQL statements and stored procedures on an Oracle 9i database.
Swap Words in a String
(Chacravarthi Ramasami) This query swaps two words of a string (when declared and defined as a bind variable).
Database Interaction with PL/SQL, OBJECT and OBJECT
(Jagadish Chatarji) It is worthwhile to introduce the concept of OBJECT here, as we can also work with OBJECTs in PL/SQL pleasantly. I will not go much into the depth of OOPS with MEMBER methods etc at this moment. My up-coming articles will look into the depth of OOPS in Oracle 10g. For now we w
Partitioning Trend a Problem for Oracle?
(Gene J. Koprowski) These real-time databases — increasingly in demand from customers — are different than generic relational databases, and exhibit a “complexity,” said Susan Eustis, president of Winter Green Research, an IT consultancy. Data has to be made as quickly available as a telephone dia
