Hi, I want to create a complex query... but I would like to "draw" it as in
Ms SQL Server Enterprise Manger.
I've tried to use TOAD, I've a  SQL Modeler Windows, but with this tool I
can draw the query (link the table) and than TOAD creates the text query

I am ready to shut down my 2 names servers and move to Internet
Directory, I have installed the OID on a 9.2.0.6 database and have it up
and running,  created all the neccesary entries by migrating a tnsnames
file and tested from my workstation after running net configuration

Can anyone help me with the metadata tables for views which has the
code for a view?
I know about all_views where you get the code for the view as a LOB
But, I want to search the code of a view to find what source columns it

I am having some issues with an application that enters NULL values to
an oracle 9.2 db. The application inserts multiple rows with NULL,
which are currently removed by using standard SQL (delete) on two
tables (table a contains the value, table b contains the relation).

Any one know if there is a release of Oracle for Mac OSX that runs
natively on the new Intel Core Duo available or will there be one?

does anyone know what what are option are included in the license for
10gr1 and 2 enterprise edition
i know it comes with partitioning etc but is there an extra license if
you use it??

I have one question about UTF8, I have one db 9207 windows with UTF8
charset.
We have used jsp page to insert one record with chinese word to table,
then I try to use sqlplus client to retrieve the record.

I found several SQL scripts which show tablespace usage.
The scripts usually query dba_free_space to get free space of
tablespaces,
which is very slow.

I have a table where dates are stored as numbers (seconds since
1/1/1970) and I want to generate a query to show them as dates with the
format DD/MM/YYYY hh:mm:ss.
Which conversion functions should I use?

Hello, Oracle Server v9.0.1 on SUSE Linux here. I changed the DB
hostname from *host.domain.com* to *host.subzone.domain.com*.
In $ORACLE_HOME/network/admin/listner.ora I wrote this listener
configuration:

In a 10.1.0.4 2-node RAC on HP-UX Itanuim,  I have a database running
which doesn't seem to have any DML activities.  Now I run a long
running SQL query (with SUM, GROUP BY), and the AUTOTRACE stats looks
like this:

Does anyone know how to link between forms in oracle form developer
(bulider)
is the code anything like this:
       run_data input (forms, 'sub menu data input', synchronous,

Where do I get Oracle 7 Downloads for Solaris and Windows Platform ?
Thanks

there is a view that is compiled fine. It is also possible to select
from this view. And it is also possible to use a where- clause. But if I
use the field VID_SBA inside the where- clause I get an error ORA-12571
an the connection to DB is closed.

Firstly,
Can I thank all those who have helped me in the past.
I have another tricky requirement and I am hoping someone has the
knowledge to assist me.