DatabaseJournal.com Staff

[From tucows] This program performs ERD modeling, SQL script generation and forward engineering of relational databases. Enhanced Entity Relationship Diagram modeling allows you to design a fully relational database, complete with Referential Integrity Constraints, indexes, checks, defaults and unique constraints. Diagrams show the complete table structure. The program supports all major databases including Oracle, DB2, […]

[From Techconnect] Download or order the SQL Server 2000 120-day Trial Software. SQL Server is a complete database and data analysis package that opens the door to a new generation of enterprise-class business applications. SQL Server CE is the compact database for rapidly developing applications that extends enterprise data management to mobile and embedded devices. […]

by Amar Kumar Padhi EXECUTE IMMEDIATE is the replacement for DBMS_SQL package from Oracle 8i onwards. It parses and immediately executes a dynamic SQL statement or a PL/SQL block created on the fly. Dynamically created and executed SQL statements are performance overhead, EXECUTE IMMEDIATE aims at reducing the overhead and give better performance. It is […]

Marin Komadina For a long time, corporations tried very hard to keep systems running under all conditions. For many e-commerce and business applications, database unavailability for an extended period leads to revenue loss. With a wide range of solutions in use (local disk mirroring, RAID, local clustering, remote disk mirroring, replication and local clustering with […]

>>Script Language and Platform: Oracle PL/SQL The purpose of this code is to provide an example of the new pipelined and parallel PL/SQL table functions available in Oracle9i Database. Author: Claudiu Ariton Script Code: create table phones (cust_id number(12) primary key, phone1 varchar2(50), phone2 varchar2(50), phone3 varchar2(50), phone4 varchar2(50), phone5 varchar2(50) ) / — insert […]

MAK [Muthusamy Anantha Kumar] DTS packages are fantastic features available in SQL Server 7.0 and SQL server 2000. One outstanding feature in the DTS package is the ability to run ActiveX scripts. ActiveX gives us an added advantage in handling many situations; we will discuss how to handle three of these situations. File-names with date-stamp […]

http://www.oreilly.com/catalog/oracleian/?CMP=OT16271 By Rick Greenwald, David C. Kreines O’Reilly & Associates, Inc. December 2002 0-596-00336-6, Order Number: 3366 926 pages $49.95 US $77.95 CA#35.50 UK Buy this book The goal of Oracle in a Nutshell is to pull together the most essential information on Oracle architecture, syntax, and user interfaces. The content and format of this […]

by Ajay Gursahani The SQL *Plus command-line interface enables you to generate a complete HTML output which can be embedded in a web page. SQL *Plus provides you with a command, SET MARKUP HTML ON SPOOL ON, which is used to produce HTML pages automatically. You can view these pages using any web browser. The […]

>>Script Language and Platform: Oracle Find all of the sessions that are idle for more than 1 hr. Command to kill those sessions is also given. Author: K Chithra select sid,serial#,username,trunc (last_call_et/3600,2)||’ hr’ last_call_et from V$session where last_call_et > 3600 and username is not null / Note : last_call_et is in seconds .You can give […]

>>Script Language and Platform: SQL Server 2000 This SQL code can be ran from the SQL Editor or included in a stored procedure which can run as a job in SQL Server 2000 to send automated email when a certain event occurs. (Management | SQL Server Agent | jobs ) You need to have SMTP […]

MAK (Muthusamy Anantha Kumar) The ability to link SQL Server to heterogeneous systems such as Oracle, DB2, Sybase, etc., is imminent. This article provides the basic and most important information required to make a linked server connection to heterogeneous systems from SQL Server. We are going to deal with three different RBBMS. DB2 Sybase Oracle […]

MAK (Muthusamy Anantha Kumar) It is a fact, that once we setup an Active/Passive cluster and install SQL server on a cluster server, the passive nodes will never be used unless it fails over. The main objective here is to try to make use of the unused resource and equipment, without spoiling the failover concept. […]