DatabaseJournal.com Staff

[From WebReference] The preceding example shows how you might move the XML processing performed by your PHP/Oracle application from PHP to Oracle, thus taking advantage of the optimizations provided by the Oracle database server. In particular, you saw how to generate an XML document from scratch and apply an XSL transformation inside the database, rather […]

SQL Server 2000 This sp can compare two tables with the same structure. Parameter Description: 1. @TableA: Name of first table 2. @TableB: Name of second table 3. @ExcludeFields: Comma delimited list of column names that are insignificant in the table comparison for example audit fields, notes fields, etc. 4. @JoinFields: Comma delimited list of […]

by JP Vijaykumar I received mail from one of our developers to tune a procedure that is taking about eight hours to complete. Before, I start tuning the procedure, I want to understand the procedure and its background. The Scenario The job dynamically generates update statements, through an Informatica workflow and executes each update statement, […]

[From PostgreSQL Global Development Group] Network Theory Ltd is pleased to announce that printed copies of the PostgreSQL Reference Manual (v8.2.4) are now available from all major online bookstores. The manual is divided into 3 volumes, running to 1300 pages in total. The article continues at http://www.postgresql.org/about/news.863

[From MySQL AB] TOKYO — September 12, 2007 — MySQL AB today announced that it plans to release alpha and beta versions of several new Free and Open Source Software (FOSS) products this month, including a ‘release candidate’ of MySQL 5.1 — a major new upgrade of the world’s most popular open source database server. […]

[From builderau.com.au] Although the DBA can resolve most problems that arise with Oracle databases, there are times when you need to file a Service Request (SR) with Oracle Support. The Remote Diagnostic Agent (RDA) shortens the time it takes for the Oracle engineer to become familiar with your system. Service Requests are also known by […]

[From MySQL AB] So, someone had a great idea to go back through the Developer Zone, which has become a bit disorganized of late, and put together an article with links and summaries for all the Dev Zone articles that discussed MySQL 5.1 features. I have done so, and also linked in many community member’s […]

[From Mentat Technologies] Mentat Technologies is now offering the option of subscription licensing for their popular database tools for MySQL, Oracle and PostgreSQL. Mentat Technologies’s subscription licensing model means that the database tools can be deployed for less than the current price for a single processor or less than the current price for a physical […]

Oracle This procedure finds all the employees working under ‘KING’ from the ‘SCOTT.EMP’ table. Starting with ‘KING’ all the employees working under ‘KING’ or under his subordinates are found. For my procedure, I had created a table PRIOR_JP. (Details given in comments section) Author: JP Vijaykumar set serverout on size 1000000 declare v_count number(10); v_empno […]

[From PostgreSQL Global Development Group] seeMore Technologies & Solutions a provider of Virtual Database Server Technology has added support for the Postgres due to customer demand. seeMores’ Virtual Database Server allows organizations to see a secure view of all of its enterprise data in real-time using SQL based standards. The article continues at http://www.postgresql.org/about/news.859

[From Advanced Data Access Tech.] Advanced Data Access Technologies, Inc. has made its Enterprise 2.0 SQLfX® interactive SQL transparent XML solution available. It is the first transparent and seamless integration of native XML by ANSI SQL. It requires no use of XML centric syntax or procedural nesting of functions, XML training, or knowledge of the […]

[From 3PAR] 3PAR, provider of utility storage, announced today support for Oracle Database 11g, the latest release of Oracle’s popular database. 3PAR’s shared commitment to simple, efficient, and scalable storage for Oracle Database environments delivers compelling advantages for joint customers. Organizations using Oracle and 3PAR to support mission-critical applications are able to leverage both technologies […]