DatabaseJournal.com Staff

>>Script Language and Platform: SQL This script will compare NULL with NULL, because NULL is not equal to NULL. Author: Paul Nersesov declare a number := NULL; b number := NULL; begin if nvl(a, 99999) = nvl(b, 99999) then dbms_output.put_line(‘Both values are NULL.’); end if; end; —— or declare a number := NULL; b number […]

>>Script Language and Platform: VBScript This script will delete old files from a given folder and all subfolders. Usage: cscript deloldfiles.vbs c:dbalog 7 This script will delete all the files older than a week. cscript deloldfiles.vbs c:dbalog 2 This script will delete all the files older than 2 days. Result: Started […]

[From PostgreSQL Global Development Group] The first beta of Version 8.4 of PostgreSQL, was just released by the PostgreSQL Global Development Group. After fourteen months of development, 8.4 is ready for testing by PostgreSQL users all over the world in order to make it our best release ever. The article continues at http://www.postgresql.org/about/news.1074

[From Oracle Corp.] In order to help financial institutions better manage their exposure, Oracle Financial Services Software today announced the availability of Oracle FLEXCUBE Enterprise Limits and Collateral Management. Oracle FLEXCUBE Enterprise Limits and Collateral Management is an enterprise application that enables banks to achieve a holistic view of their exposure by helping them to […]

[From SQL Server Magazine] Keeping up with new data-access enhancements in Visual Studio (VS) is a full-time job for SQL Server database developers. VS 2008 and the .NET Framework 3.5 SP1 include these new SQL Server data-access options. The article continues at http://www.sqlmag.com/Article/ArticleID/101528/sql_server_101528.html

>>Script Language and Platform: Oracle PL/SQL This procedure returns 0 if invalid mail ID else 1. Author: vishal Download Script: email_val.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 your sole risk. All information on these pages […]

[From Packt Publishing] Written by experienced developers in SOA BPEL, this book provides a detailed tutorial of the core components that make up the Oracle SOA Suite; namely the Oracle Service Bus, BPEL Process Manager, Human Workflow, Business Rules, and Business Activity Monitoring, and will show the reader how to combine all of these different […]

[From eWeek] Microsoft has released SQL Server 2008 Service Pack 1 with enhancements meant to ease deployment but no brand new features. According to Microsoft, this is a result of an emphasis on ensuring its database is feature complete before its release. The article continues at http://www.eweek.com/c/a/Database/Microsoft-Releases-SQL-Server-2008-Service-Pack-1-687774/?kc=rss

[From PHP Builder] Welcome back. In part 1 of this series, you created some PHP remote services and the Clocked! widget application. Part 2 covers PHP administration and completion of the timer widget. Let’s jump right into Adobe Flex Builder and add more widget features. The article continues at http://phpbuilder.com/columns/bates/richard_bates040609.php3

[From MSDN Blogs] This version of the JDBC driver supports features introduced in the JDBC 4.0 API, including: national character set data types: NCHAR, NVARCHAR, LONGNVARCHAR, NCLOB SQLXML data type Wrapper interface to access SQL Server JDBC Driver specific methods More… The article continues at http://blogs.msdn.com/jdbcteam/archive/2009/04/03/announcing-microsoft-sql-server-jdbc-driver-2-0.aspx

[From Oracle Corp.] Oracle today announced the availability of Oracle’s Agile Product Lifecycle Management (PLM) Design-to-Release Process Integration Pack (PIP), connecting the Enterprise PLM Product Record in Oracle’s Agile PLM with SAP ERP. Oracle’s Agile PLM Design-to-Release PIP is based on an open, standards-based service oriented architecture (SOA) designed to deliver seamless synchronization of product […]

[From eWeek Europe] Can Dabble DB from Smallthought Systems solve one of the modern knowledge worker’s most enduring dilemmas by bridging the gap between the spreadsheet and the database? The article continues at http://www.eweekeurope.co.uk/product/dabble-db-web-based-online-database-567