In today’s economy, information is the fuel that keeps enterprises running. Enterprises embraced the Internet for its ability to rapidly deliver information from computer to computer. Now, mobile technology is becoming the intermediary, bridging the gaps and enabling the extension of your databa

(Scott Stephens) This article explains why you should avoid public and private synonyms and use alternatives that depend on your application design. The best alternative is to always fully qualify a table with its schema name.

(Adrian Billington) It has always been possible in PL/SQL to identify the source of an exception in a block of code; i.e. to know the precise point at which a block of code failed. However, until Oracle 10g, it has not been possible for developers to intervene in the exception in any way whilst reta

(Xiang Gao) When generating a script to perform data maintenance, especially DML, one common problem is that the user is required to make multiple commits between the DML operations to reduce the UNDO/rollback segment size. Typically, the script is edited manually after it has been generated.

(Kimberly Floss) Segments that undergo significant data manipulation language (DML) activity, such as UPDATE and DELETE operations, can become sparsely populated, with chunks of free space within their data blocks. Besides simply wasting space, sparsely populated segments can also lead to poor p

SAMSys Technologies Inc. has joined the Oracle PartnerNetwork to make SAMSys RFID readers available to the system integrators, value-added resellers, and enterprises using Oracle’s 10g Sensor Edge Server in radio frequency identification (RFID) implementations.

You run an Oracle procedure in an Oracle database. When you do this from a computer that is running Microsoft SQL Server 2000 by using a linked server to an Oracle database, you receive the following error message: Server: Msg 7212, Level 17, State 1, Line 1 Could not execute procedure ‘Oracle Pr

Oracle today announced that Oracle Application Server 10g closed out the SPECjAppServer2002 industry standard benchmark as the overall performance world record leader for Java 2 Platform, Enterprise Edition (J2EE) 1.3 application servers, beating out rivals BEA and IBM.

(James Niccolai) Fresh from its takeover of PeopleSoft Inc., Oracle Corp. was recently in discussions about the possibility of buying out another applications rival, Siebel Systems Inc., although the talks are no longer active, according to published reports.

(Bhagwan Singh) This script returns the column and table names for a value input by a user. For example, if we know that there is a character value of ‘US-15017094’ with no other details available, this routine will search the user schema and list both table and column name for that value.