I have been working in Oracle database for a while. I am actually looking
for an easy way to get a dependency tree. I know Oracle
provides us with the script "utldtree.sql",however I am not really succesful
in using it.

Please contact me via email at my_job_offers@hotmail.com
Kew Gardens, NY
Cell Phone: (718) 930-7947
Email:  my_job_offers@hotmail.com

I have a trigger that ago a insert in one table.
The execution of the trigger is transaction?
thanks
Sergio

under Oracle 8.1.7 and redhat linux 8 I want to create a daily copy of
the production database (or a part of it) on the same machine for use as
a test database.
So far we have used

I am running Toad 7.5.2.0 on win xp. I find that while I am using it,
it periodically freezes my system. e.g. if I have 5 toad windows open
(schema browsers, sql editors), I work in 1 window, I then click on
another and work in that, I then click on another - at this point the

I use JDevelopper 9.0.3.3 with BI Beans on  9.2.0.4.1.
The BIBDEMO I successfully tested. Now I have created new dimensions and
cubes on another database.
Then I created an analytical workspace with awm and enabled for olap api and

We are trying to take inventory of all the reports used in the
department. Part of the inventory we have to capture all the tables ,
columns , where class , functions, procedures etc., used in the
reports. We are planning to load the reports into oracle designer and

I hope this isnt an off topic subject for an oracle.tools disucssion,
but I notice that at last some of the contributors here are educators
with strong opinions.
Some (few) of our users has expressed a desire to learn SQL so as to be

How to use LOV?
Is it a list for value retrieve from database and select one from the
list and output to a text item?

I have a forms 6i web application which sets roles dynamically based
on the login.  No problem using dbms_session.set_role.
However, we have a user form which assigns specific roles based upon a
user class.  I'm using the EXEC_SQL package to grant the roles to the

Hi. I'm using Portal 3.0.9 and am about to migrate a portal from a
development environment to a live environment. I've seen the stuff on
how to export pages, content areas, etc. but how do I export a content
area style?

we intend to do project on designing a migrator tool which converts
the database from foxpro2.6 to oracle8i on the Novell netware5.1
Help us with your suggestions to start with.

I'm new to Oracle. I'm trying to install Oracle 9i using the Universal
Installer on a Red Hat Linux workstation 7.0. I know old crap but that
is what I currently have. During the installation I get to
"Installation Types" page the installer stops and goes away during

Supposing all tablespaces a dump would create if imported full were
precreated, what difference remains if comparing a full dump import
with a user-wise import of all regular users?
One difference concerns importing the SYSTEM schema. Can I afford not

Does anyone know a good way to exclude the commas when editing a number
field?  I have a format mask that adds commas for readability on long
numbers, but when I edit the number, I don't want the commas to be there.
For instance, if I where to put the decimal point off by one ...