Home > Oracle Database / Applications Featured Topic
Featured Topic:
Ask the Oracle Experts
Last Updated: Jul 20, 2003
Feeling stumped by an Oracle dilemma? Our panel of gurus can answer your toughest Oracle, data warehousing, SQL and PL/SQL questions. Pose a question today and check out some of their featured responses below.
Looking at each value in a VARRAY
ASK THE EXPERTS :I have a table containing a VARRAY of objects as shown below. But I don't know how to find which divisions have an employee ...
>>
Limiting number of rows returned by query
ASK THE EXPERTS :In SQL Server, there are a couple of commands (SET ROWCOUNT or TOP) that limit the number of rows that will be returned by a ...
>>
Resolving the ORA-04031 error
ASK THE EXPERTS :When i try to connect to my database, I get the ORA-04031 error. Why?
I still can connect. I
think it is something ...
>>
Best way to load 500,000 rows every hour
ASK THE EXPERTS :I load about 500,000 rows every hour into the fact table,
which has partitions. My end query basically dumps the data into ...
Problems loading data with SQL*Loader
ASK THE EXPERTS :I'm trying to load data into a one-column table
using SQL*Loader. The column length is a varchar2(550), but sqlldr rejects ...
>>
Where are RMAN scripts kept?
ASK THE EXPERTS :I am presently using OEM in Oracle 9i to perform our backups on a Solaris platform. I can see the output results in OEM, but ...
>>
Making a test server with IMPORT/EXPORT
ASK THE EXPERTS :Could you please explain step-by-step the way to make a test server by using export/import? The test server will be in ...
>>
Representing set of numbers as set of ranges
ASK THE EXPERTS :I need to be able to insert a comma or a dash between two numbers,
depending
on if the numbers are consecutive or ...
>>
Transferring data in one table between schemas
ASK THE EXPERTS :Using the EXP/IMP utility of Oracle 9i, is it possible to
transfer only data of a table in one schema to a
table (of same ...
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.
