By Michael Singer – Oracle Thursday unveiled Oracle Collections, a collections software enhanced Customer Relationship Management (CRM) features. The Redwood Shores, Calif.-based business software giant says the new software is part of its Oracle E-Business Suite and is now available as tradi

By Prakash – The management of copies of tables across a distributed database environment is replication. Replication may implicitly involve maintenance of all or some of the objects related to a table; e.g. Triggers, Indexes, Referential Integrities, and so on, so as to maintain database consistenc

By Dusan Djuric – You are in a SQL*Plus (Windows) session. Somewhere on your machine is the one script you need, but where? The script name is something like my*query.sql, but you’re not sure. What do you do? Here’s a handy way find it fast.

By Joe Johnson – As a DBA, you undoubtedly understand the importance of proper indexing when tuning databases. New features in Oracle9i Database make it easier for you to monitor and manage your application’s index use. When you determine and confirm an index is not used by your application, you can

By Thomas C Greene – In light of the fortnight-old SNMP pandemic, it’s tempting to forget that the world’s most popular database kit remains vulnerable to a host of potential exploits which were published about three weeks ago by NGSSoftware Insight researcher David Litchfield.

Thursday, March 14th: Oracle iRecruitment Internet Seminar at 11:00 am PST/2:00 pm EST! How Can You Save Over 60% of your overall recruiting costs, decrease your time to recruit from an average of 90 days to 30, and ensure you are hiring the most qualified candidates for the job?Find

(Rohit Sinha) Many times you may need to find what SQL is currently running and which user is running it. The following SQL runs on Oracle versions 7 and 8.1.7 and gives the SID, Serial#, SQL text, and the Oracle and OS user running it. The SID and serial number information may be used to kill the p

By Rick Whiting – Embarcadero Technologies Inc. is expanding beyond its roots as a database administration tools vendor with new data extraction, transformation, and loading software. Embarcadero is targeting sales of the ETL software, DT/Studio, toward small and midsize companies for whom other ETL

by Rich Niemiec – Oracle9i opens the gate to legacy data and more with the biggest enhancement to relational technology in years.

This tip comes from Don Beeler – This SQL will create two sql scripts: one to create a table and one to insert data into an Oracle table from an AS400 flat file. This process uses a temporary table so that CHARs can be changed to VARCHAR2s. In the INSERT for AS400 CHAR columns, I do RTRIM and LTRIM.