DatabaseJournal.com Staff

[From internetnews] Just nine months after Oracle first announced its Optimized Warehouse Initiative to help accelerate data warehouse deployments, Hewlett-Packard (NYSE: HPQ) has introduced its entry into the market. The HP BladeSystem for Oracle Optimized Warehouse Initiative (OOWI) will be available in July and comes in capacities of 1 terabyte (TB) to 4TB. The article […]

[From Search Oracle] Oracle’s decision to raise its list prices by 15% to 20% is cause for concern for both existing and prospective customers. But there are opportunities to offset those hikes, according to industry analysts. Oracle’s new price list, updated June 16, includes increased pricing for its new 11g database Enterprise Edition (from $40,000 […]

[From OTN] This article provides an introduction to Hyperion Essbase, describing its architecture and explaining how it fits in with Oracle’s middleware and business intelligence technology stacks. Later on, you will see how easy it is to build a Hyperion Essbase multidimensional database and then connect it to Oracle Business Intelligence Suite Enterprise Edition, taking […]

>>Script Language and Platform: Oracle This script will delete all duplicate records in a table. Author: Pramod Vasudevan,india DELETE FROM tablename(say EMP) WHERE ROWID NOT IN(SELECT MIN(ROWID) FROM tablename(say EMP) GROUP BY tablename [columnname](say EMPNO)); Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained […]

[From Search SQL Server] When you open a SQL Server Integration Services (SSIS) package in SSIS Designer or add components to a package, SSIS by default checks the data sources used by the various components. This process for SSIS package validation ensures that the external metadata is valid. If the metadata is not valid, you’ll […]

>>Script Language and Platform: SQLServer 7.0, 2000 The following script is to find out which tables in MSSQL Server have Identity fields. In addition, the script displays the Seed & Increment value for each user table in a database. Author: Sushant Saha /* Purpose : To find which table has Identity Columns in a database […]

>>Script Language and Platform: OracleThis script displays all of the employees working under a particular employee in a string, separated by a ‘|’ as delimiter. To achieve this I created a function and then used the function to display all the employees working under a particular employee (Top down hierarchial traversal). Author: JP vijaykumar Download […]

by Kevin Medlin Abstract Database refreshes are one of the most popular ad hoc requests that a database administrator receives. Data becomes stale for testing or becomes corrupt after much development. In any case, data refreshes are a way of life. This document offers one approach to database refreshes for Oracle 10g databases on Windows […]

[From Computerworld] May 19, 2008 (IDG News Service) Web sites across China and Taiwan are being hit by a mass SQL injection attack that has implanted malware in thousands of Web sites, according to a security company in Taiwan. First detected on May 13, the attack is coming from a server farm inside China, which […]

[From IBM] PHP’s next edition, V6, includes new features and syntax improvements that will make it easier to use from an object-oriented standpoint. Other important features, such as Unicode support in many of the core functions, mean that PHP V6 is positioned for better international support and robustness. The article continues at http://www.ibm.com/developerworks/opensource/library/os-php-future/?ca=dgr-lnxw01PHP-Future

[From Oracle Corp.] In order to provide targeted financial performance metrics and compliance information to multiple stakeholders within the organization, Oracle has delivered Oracle’s JD Edwards EnterpriseOne Financial Management and Compliance Console. This new application enables JD Edwards EnterpriseOne customers to define role-based views across a comprehensive set of performance metrics to deliver users relevant […]

[From PremiumSoft CyberTech Ltd.] Navicat MySQL GUI is a graphical tool for managing, monitoring, and developing your MySQL database. This new version supports Excel Import, Virtual Grouping, Tabbed Window, Tabbed Windows,SSH Connection, Structure Synchronization and some other usability and stability enhancements. It can be downloaded at http://www.navicat.com/download.html The article continues at http://www.navicat.com