(Brian Peasland) Why is there only one primary key allowed in a table? Why not more than one? Even then you can have multiple unique and not null constraints defined on any number of columns. (R)
Tag: Oracle
Debugging PL/SQL from .NET
(Mark A. Williams) Debugging PL/SQL code in Microsoft Visual Studio is as easy as debugging native .NET code, thanks to the PL/SQL debugger in Oracle Developer Tools for Visual Studio .NET (ODT). This column demonstrates how to set up PL/SQL debugging in ODT and how to create and step through PL/SQL
Who Watches the Watchers or Upgrading Applications
(Antony Reynolds) We all remember our first encounter with recursion when learning programming, and we enjoyed the dictionary definition recursion – see recursion
Size of database in gigabytes
(Brian Peasland) I’m new to Oracle. How do I find out the total size of a database in gigabytes? (R)
Scalability : SQL Server vs Oracle
(Partha S) In this post we look for answers to some of the questions we saw in – Oracle vs SQL Server : What’s different ?
G-Log acquisition bears fruit with Oracle Transportation Management 5.5
(Mark Brunelli) Oracle unveiled Oracle Transportation Management 5.5 (OTM), the first major release of G-Log supply chain and logistics management software since Oracle acquired the growing firm last November. (R)
RMAN in 10g
(Christo Kutrovsky) Even though there’s a new features guide, there’s always these little things that you discover when you read the manuals.
Challenges in backing up large databases
(Brian Peasland) What are the challenges that we should be ready to address when devising a backup and recovery strategy for large databases, typically 10 TB or larger in size? What is the best way to overcome these challenges? (R)
Oracle RAC Administration – Part 4: Administering the Clusterware: Components
(Tarry Singh) I have a Google alert running for Oracle RAC and besides pulling the regular vendor offerings, I receive a lot of alerts on how often Oracle RAC is being adopted into the enterprise. I mentioned commoditization in my previous article, but there are a lot of pressures and several odd an
Harnessing the Active Data Model
(Steve Muench) One of the key benefits of using Oracle Application Development Framework (ADF) Business Components is its built-in support for an active data model. If you’ve worked with Oracle Forms or other 4GL tools, you’ll find active data model support in Oracle JDeveloper using ADF Business Co