-
Three facets of Oracle Hyperion implementation
When implementing an Oracle Hyperion project, a company must be aware of technical, management and roadmap issues.
-
Using SQL SELECT, SQL UNION ALL statements for sorting
Expert Dan Clamage explains how to use SQL SELECT and SQL UNION ALL statements to sort and visualize a set of sales figures.
-
How to copy Oracle Database 9i to new server
Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another.
-
Confusion around PL/SQL to_date and to_char functions
One reader asks expert Daniel Clamage about the PL/SQL to_date and to_char functions and how to properly convert date and string values.
-
Why won't TNS listener connect with Oracle Database 11g
One reader asks why his 64-bit TNS listener won't connect with 32-bit Oracle Database 11g.
-
Where to look for Oracle DBA learning materials
Readers ask SearchOracle.com expert Brian Peasland where they can find learning materials for becoming a better Oracle database administrator.
-
Call stored procedures inside user-defined functions
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database.
-
Solve a PL-SQL error that creates dynamic tables
Oracle PL-SQL expert Daniel Clamage answers a question about a problem with doing an “insert” in PL-SQL to create a table dynamically.
-
Inconsistent data type error in Oracle Database 9i
A reader asks SQL expert Daniel Clamage about an inconsistent data type error he's getting on a query running in Oracle Database 9i.
-
Oracle licensing on Oracle Database Standard Edition
One reader asks two questions about licensing Oracle Database Standard Edition.
-
Hyperion update has issues with migrating Essbase data
One reader asks how to properly migrate Essbase data when upgrading from Hyperion 9.3.1 to 9.3.3 and then 11.1.2.1.
-
Oracle third-party support has benefits, drawbacks
Expert Al Marmero describes the pluses and minuses of Oracle third-party support. Cost, quality and potential litigation are all key considerations.
-
Partitioning and Oracle licenses
One reader asks expert Scott Rosenberg from Miro Consulting about partitioning Oracle software licenses.
-
Understanding Oracle Exadata Smart Scan
Expert Shyam Varan Nath explains what Oracle Exadata Smart Scan does and how it can improve query performance on Exadata.
-
Examining mobile applications for J.D. Edwards
Oracle recently announced some new mobile apps for J.D. Edwards. Expert Al Marmero talks about their benefits and potential drawbacks.
-
Making Monday the start of the week in Oracle SQL
One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week.
-
Does storing documents in a database hinder performance
One reader asks if it is the best practice to store a document inside an Oracle database.
-
Improve the Media Recovery Process in Oracle Data Guard
One reader asks expert William Cullen why the Media Recovery Process (MRP) in Oracle Data Guard shouldn't be used in multi-node Real Application Clusters (RAC) environments.
-
Creating and retrieving a binary large object (BLOB)
One reader asks how to create and retrieve a binary large object (BLOB), and SQL expert Karen Morton gives some comprehensive advice and tips.
-
Creating a virtual SQL table for date values
One reader asks how to use SQL to track his company employees' absentee days, and expert Dan Clamage suggests creating a virtual table.
-
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.