(Aui de la Vega) This function provides the number of times a pattern occurs in a string (VARCHAR2).
Tag: Oracle
Oracle CSO: Security must be baked into coding culture
(Bill Brenner) Though Oracle CSO Mary Ann Davidson has lead a push for more secure software, her company has seen its share of criticism this year over how long it takes to acknowledge vulnerabilities and issue patches. (R)
Oracle Warehouse Builder 10g
Oracle Warehouse Builder 10g is the only enterprise Business Intelligence integration design tool that manages the full life-cycle of data and metadata for the Oracle database. Leveraging Oracle’s Business Intelligence features and scalability, Warehouse Builder allows designers and developers to de
Oracle Lets Loose ‘Tsunami’ Collaboration Suite 10g
(John Pallatto) Oracle Corp. topped off a torrent of product announcements during its OpenWorld customer conference with the introduction of its Collaboration Suite 10g, which is designed as a universal corporate information and content management platform.
Bringing Perl to Oracle Integration Projects
(Vance McCarthy) Enterprise Java, ASP and .NET developers working with Oracle, as well as Oracle DBAs, face increasing pressure to find affordable, full-featured tools to help with database integration development projects. Oracle’s plans for its Data Hub and 10g grid technologies are intriguing, bu
Oracle, PeopleSoft to Merge in $10.3B Deal
(Michael Liedtke) Ending 18 months of bad blood, Oracle Corp. raised its takeover bid for bitter rival PeopleSoft Inc. by 10 percent to seal a $10.3 billion deal that will create the world’s second largest maker of business applications software.
Oracle Developer Tools for Visual Studio .NET
The new Oracle Developer Tools for Visual Studio .NET is a tightly integrated “Add-in” for Visual Studio .NET that brings the power of the Oracle database to .NET developers! Designed to be completely intuitive for database developers, your productivity will increase starting on day one. And if you
PRB: Oracle Cursors Remain Open After Calling VB rdoQuery
Calling the rdoQuery object in Visual Basic 5.0 or later or a Remote Data Object (RDO) PreparedStatement in Visual Basic 4.0 opens three Oracle cursors; two remain open after closing the rdoQuery or PreparedStatement object.
Filtering (WHERE) and Sorting Data (ORDER BY) in Oracle 9i (Sample Chapter)
(Gavin Powell) This chapter covers filtering of rows using the WHERE clause and sorting of retrieved data using the ORDER BY clause. The WHERE clause applies to both queries and most DML commands; the ORDER BY clause applies to queries only.
Oracle and Availability: Illustrated Downtime Scenarios (Sample Chapter)
(Matthew Hart and Scott Jesse) As you have already discovered, or perhaps are about to discover, maintaining the high-availability database is a tricky prospect. There are hundreds of possible sources of downtime hiding in the crooks and crannies of your enterprise. Many outage situations cascade in
