-
Oracle SQL: Using the analytic rank function
Expert Karen Morton explains how to use a simple analytic rank function to sort through a group of golf scores.
-
Oracle licensing with logical partitions (LPARs)
One reader asks about what Oracle licensing his organization must have if they have an environment with two LPARs with one active node.
-
Itanium's core factor affects Oracle DR licensing
One reader asks about licensing Oracle Database 11g on the company's Itanium-based HP servers, and a discussion on Oracle's processor core factor table ensues.
-
Using inline view to better query joined tables
One reader asks how to best query data from two joined Oracle tables.
-
Oracle license requirements in DR scenarios
One reader asks whether they need an Oracle license to back up their database to tape.
-
SQL query for sorting through ID columns
A reader asks Oracle expert Karen Morton how to query a group of rows based on their text columns.
-
Replacing text strings in an employee name column
One reader asks how he can change occurrences of "LL" to "LX" in an employee name column.
-
Avoiding and fixing mutating table errors
PL/SQL expert Daniel Clamage tells one reader why her merge statement is creating a mutating table error.
-
Oracle temporary tablespace too large
One reader asks how he can adjust a query to prevent his temporary tablespace file from getting too large.
-
Mirroring in Oracle RAC and Data Guard
A reader asks a question about mirroring on Oracle RAC using Data Guard.
-
Copy Oracle Database but with no data
One reader asks how he can make a copy of his Oracle Database but not have any data in it, for test purposes.
-
Oracle RAC and distance limitations
One reader asks what the Oracle RAC distance limitations are for two environments being run in sync.
-
Object privileges in Oracle database security
A reader asks a question about the GRANT OPTION as it relates to object privileges in Oracle database security.
-
Oracle perpetual license policies
One reader asks about his company's Oracle software licenses that they want to drop support on, saying that Oracle wants them to discontinue product use altogether.
-
Changing file paths in a recovered Oracle database
Expert Brian Peasland helps a reader figure out how to successfully remap the file path for a database that had to be recovered from a dead server.
-
Exadata, hybrid columnar compression, and inserts
One reader asks Oracle Exadata book co-author Rick Greenwald about compression on row-insertion on Exadata.
-
Oracle Exadata and SGA caching
One reader asks Oracle Exadata book co-author Rick Greenwald about the SGA caching dynamic in Exadata.
-
Cache Fusion for RAC on Exadata
One reader asks whether Cache Fusion for Oracle RAC is implemented differently on Oracle Exadata compared to other platforms.
-
Purchasing extra licenses despite no software modificat
Oracle licensing expert Scott Rosenberg answers a reader's question about their adoption of Oracle E-Business Suite.
-
Problems with row-by-row processing in Oracle Database
One reader asks what's wrong with his script, and Oracle expert Karen Morton explains the problem with row-by-row processing.
-
Perfect the Oracle RMAN duplicate 10g command
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
-
Do SQL arithmetic without using arithmetic operations
Learn how to do simple SQL arithmetic operations without using the arithmetic operators.
-
Managing SQL parent table-child table relations
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Submit a question to our experts