DatabaseJournal.com Staff

[From Original Software] Original Software announced the release of the latest version of TestBench for Oracle, which includes an intelligent data scrambling module, protecting companies from data exposure and satisfying audit and compliance requirements, as well as safeguarding the individuals or companies referenced in the data. The article continues at http://www.origsoft.com/News/release34.htm

>>Script Language and Platform: Sql Server 2000 This script will check the rerun status of failed or cancelled jobs and the job steps. There are many times when you have multiple job/steps failures and you would like to find out in a quick way of what needs to be reran. This will help. Author: Jules […]

[From Oracle Corp.] Oracle today announced the new Oracle CRM On Demand Integration to Siebel CRM a comprehensive, prebuilt integration that creates a single customer view across on-demand and on-premise CRM deployments. Oracle provides a holistic view of the sales pipeline for sales and executive managers and the ability to perform analytics against it by […]

[From OTN] Oracle SQL Developer 1.5 expands its file-based support by introducing tight integration with the CVS and Subversion version control systems. In addition to letting you browse and edit files in the file system, this Oracle SQL Developer release enables you to import files into your source control system, check them out, modify them, […]

>>Script Language and Platform: OraclePL/SQL String Parser can parse sentences and paragraphs that are separated by blank lines of any length and new lines. Author: jp vijaykumar Download Script:PlsqlStringParser.sql Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at […]

[From eITPlanet] Obviously, database administrators are critical to the success of any disaster recovery scenario. There are many key roles that are critical to the success of the database administrator. A server administrator will have to install and set up the server. A system administrator will be needed to install and set up the operating […]

[From Oracle Corp.] CaseCentral, a secure SaaS platform for corporations looking to take control of eDiscovery, has migrated its Software-as-a-Service (SaaS) platform to Oracle Database and Oracle Real Application Clusters to deliver better performance, scalability and availability, Oracle announced today. CaseCentral’s platform allows corporations to apply disciplined business process to litigation and regulatory matters, reducing […]

[From eWeek] As vendors such as Microsoft, Amazon and others push databases into the cloud, enterprises should consider database-as-a-service as part of their DBMS strategy, according to a new Forrester Research report. However, a number of challenges remain before cloud databases can be widely adopted by enterprises. It’s no secret vendors such as Microsoft and […]

[From Builder AU] With the introduction of Large Object (LOB) datatypes, the LONG and LONG RAW datatypes were deprecated. If you need to make a copy of a table that uses LONG, the CREATE TABLE AS SELECT syntax won’t work; you’ll get this error: ORA-00997: illegal use of LONG datatype. The article continues at http://www.builderau.com.au/program/oracle/soa/Copy-legacy-Oracle-tables-with-SQL-Plus/0,339028441,339291273,00.htm

>>Script Language and Platform: Oracle You can run this script on any Oracle version of database to find out the lock details. Author: T.N.V.R.L.S Gupta set echo off col sid form 9999 col id1 form 9999999999 col id2 form 999999999 col lmode head “Lock Held” form a14 col request1 head “Lock Request” form a16 col […]

[From MSDN Blogs] With SQL Server 2008 RTM announced, we wanted to give you an update on the release plans for Report Builder 2.0. Report Builder 2.0 will ship as part of the updated feature pack for SQL Server 2008 in fall of this year. The article continues at http://blogs.msdn.com/sqlrsteamblog/archive/2008/08/07/report-builder-2-0-release-plan-update.aspx

[From Packt Publishing] The book introduces the user to installing the MVC Framework and building his first application, and follows with looking at each main component of a CakePHP application in detail. This book walks the PHP developer through setting up a CakePHP environment, and develops an example application to illustrate all of the techniques […]