DatabaseJournal.com Staff

[From EnterpriseDB Corporation] OPEN SOURCE BUSINESS CONFERENCE, NEWTON, Mass., Nov. 1, 2005 –EnterpriseDB Corporation, an enterprise database company, announced today at the Open Source Business Conference the availability of EnterpriseDB 2005 Release 2. EnterpriseDB 2005 is an enterprise-class database that is built on PostgreSQL, the world’s most advanced open source database. EnterpriseDB 2005 features the […]

I have been active in several industries since 1991. While working in the maritime industry I have worked for several Fortune 500 firms such as NYK, A.P. Møller-Mærsk Group. I made a career switch, emigrated, learned a new language and moved into the IT industry starting 2000. Since then I have been a Sr. DBA, […]

[From The SANS(TM) Institute ] Joshua Wright, a researcher at SANS released details tonight of the Oracle password hashing algorithm at the SANS Network Security conference in Los Angeles. As part of his presentation, Wright demonstrated an attack tool he wrote that makes it possible to recover the plaintext password from even very strong, well […]

[From EMS Software Development] EMS announces a new version of a tool for MySQL Database Server administration and development – SQL Manager 2005 for MySQL. What’s new in the latest version? 1. Triggers support implemented. 2. Visual Query Builder: – Support of subqueries and UNION joins. – Ability to create INSERT/UPDATE/DELETE statements. 3. Now you […]

In a previous review, I looked at SwisSQL SQLOne Console from AdventNet, that converts SQL statements from one SQL dialect to another. That’s a generic SQL Converter and supports conversion to and from Microsoft SQL Server, Sybase, Oracle, IBM DB2, Informix, MySQL, PostgreSQL and ANSI SQL. Now it’s time to review yet another migration related […]

by Paul C. Zikopoulos The Toad product from Quest Software is a well-known database tool that helps to improve the productivity of application developers and database administrators (DBAs) working with some of the world’s most popular relational databases. In September 2005, Quest Software made some serious news in the database industry by announcing an open […]

by Paul C. Zikopoulos The Toad product from Quest Software is a well-known database tool that helps to improve the productivity of application developers and database administrators (DBAs) working with some of the world’s most popular relational databases. In September 2005, Quest Software made some serious news in the database industry by announcing an open […]

>>Script Language and Platform: Oracle 9iThis script provides details of users session. Author: Anirban Dey Download Script:find_criminal.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 is provided “as -is”, […]

[From Oracle Corp.] ORACLE OPENWORLD, SAN FRANCISCO 21-SEP-2005 Oracle today announced a new record-breaking TPC-H three terabyte (TB) data warehousing benchmark for Oracle(r) Database 10g Release 2. Running on an IBM eServer(r) p5 595 system with 64 1.9 GHz IBM POWER5(tm) processors using the IBM AIX 5L V5.3 operating system, Oracle Database 10g Release 2 […]

>>Script Language and Platform: Oracle This script finds the tables that contain more than 100 rows. Author: Praveen Kumar Chugh(09818276143) create or replace function rowcount(tname varchar2) return number is x number; stmt varchar2(200); begin stmt := ‘select count(*) from ‘||tname; execute immediate stmt into x; return x; exception when no_data_found then return 0; end; / […]

>>Script Language and Platform: OracleThis script finds the nth minimum value from table emp. Author: Praveen Kumar Chugh(09818276143) select level, max(sal) from emp where level = &level connect by prior sal > sal group by level; Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information […]

>>Script Language and Platform: SQL Server This script will give the Column names with datypes of a table. You can give tablename id for specific table. Author: Sarang R Bobde SELECT SYSOBJECTS.NAME AS [TableName], SYSCOLUMNS.NAME AS [Column Name], SYSTYPES.NAME AS [Field Type], SYSCOLUMNS.Length, CASE WHEN SYSCOLUMNS.isNullable= 0 THEN ‘NOT NULL’ ELSE ‘NULL’ END AS isNullable […]