Is there any other way to get Oracle Patches (Oracle 9i) appart from
metalink ?
Is there any Sample Patch with Oracle installables or ORACLE_HOME ??
Thanks

SQL> desc dept
Name          Type
---------------- -------------
DEPTNO    NUMBER(2)

I want to implement a simple employee, department relationship.
Only condition is that an employee can belong to multiple departments.
Do I go for
1. a three table implementation ( employee, department and

Is there a way to change the name of the database from 'XE' to
something else?  I would like to use a different name.  Is there a way
to do that?

I need to set up a generic table in Oracle that allows users to enter
data that can later be retrieved in reports.
I was thinking of a 3 column table in this structure:
DATE,ITEM,VALUE

What is the difference between QUIESCEing and SUSPENDing, and what is the
relationship to ALTER TABLESPACE BEGIN BACKUP ?
Thank You
Joachim

Hi, all
I need some help about Oracle 8i 8.1.6 installation...
I must migrate a DB from Oracle 8i 8.1.6 (Windows NT SP 6) to an Oracle
8i 8.1.6 (Windows 2000 SP 4).

Hi everybody..
I'm trying to execute a stored procedure in orecle, from my visual
basic script.
How can i do this? and how can i display the results ?

Hello people,
I have this strange behaviour on one of my Oracle9i databases.
I am trying to backup the database though RMAN (using controfile).
I am shutting the following:

I've been approached by my employer to review possible hardware
upgrades to our database. Due to the new licencing options available
the sun route seems to be very favourable.
I do how ever have some questions the licencing stipulates that each

This one works...
FROM From.Timelog, From.Cmo_Worker WHERE ( Timelog.Case_Manager (+)=
Cmo_Worker.Portalid )
but I needed the opposite joins..so I did...

This is my first experience with database links.  I am writing a PL/SQL
function that defines a type as
TYPE approvals IS TABLE OF test_results@xyx.approved%TYPE;
where test_results is the table, @xyz is the link, and approved is the

             Which is better, performance wise. Using "BETWEEN" clause
or using "<=" or ">=" clause.
Just wanted to know performance significance,if any.
Any help would be appreciated

Hello Partner,
Please forward some good resumes with excellent communication skills.
ATG Dynamo Developer
Location: Minneapolis, MN

I am in a dilemma where I wastoldby other developers in my team that
complex stored procedures are not used for accessing oracledb where the
tables return millions of rows of data. Is this true? The smarts after
retrieving the data is done in business objexts using Pro C.