Need help in below mentioned problem.
Does Oracles provides tools or functionality which could be used to
refresh tables across different databases. I have to maintain same data
of tables on 2 different database, Any insert/update/delete in one

I have a form I've developed with Forms 6i using the formula function.  The
field(s) display on the form properly but I cannot seem to get them to be
able to be saved into the database with the other fields I have on the form.
I have checked all the documentation I have and I can't ...

I installed the latest oracle 10 on windows xp but did not find the demo
files claimed ot be in the documentation.  For example, ffilopen.c is
supposed to be a bfile demo file.  I only have 6 .c demo files installed.
Where do I get the demo files from the documentation lists?

Is there a command that will take a string (vcarchar2), and (if its
less that N characters long, PAD it will spaces until it is N
characters long? Like the reverse of TRIM.
Thanks!

I have about 20 tables that I need to join together and I need help on
a strategy. I can ultimately tie all the table back to one base table.
My other option is to to join 10 tables together and then the other 10
together and have those hook together through 1 base table in each

I want to calculate the coefficient of correlation between x with id=1
and x with id=2. mytable is looking something like this:
x | id
-------

Home based Internet research Jobs
We are now hiring home based workers to complete simple online research
assignments.
No selling - no recruiting - no adplacing

Is there any way to rollback DDL (and not just DML).

Execution Plan
----------------------------------------------------------
  0      SELECT STATEMENT Optimizer=CHOOSE (Cost=4 Card=2 Bytes=384)
  1    0   SORT (ORDER BY) (Cost=4 Card=2 Bytes=384)

I have a table with several columns that may have null values.
I want to set the columns to 0 if they are null.
An UPDATE statement like this below gives me a syntax error, but how
could all the columns be set to 0 in one update statement?

I've reinstalled it at least 3 times.. each time the file is missing.
When I startup I get
oracleWRHS: error while loading shared libraries: libaio.so.1: cannot
open shared object file: No such file or directory

  Can I use Oracle 10g Designer with Oracle10 Exprress Edition? If I
can, what are the steps that I should take to create the repository? I
am a newbie to Oracle!!
Thanks alot

We've got about 15 client sites who's 'backup strategy' currently
consists of running in noarchivelog mode & doing nightly exports. Now I
know in reality it's neither a 'backup' nor a 'strategy', but they've
been happy to lose a day's data, & it's served them well for nearly a

I need some help with this.  I was able to count all the records in our
database using the user_tables and user_tab_columns tables after
refreshing the statistics on this database.
We are doing an upgrade of a system and I will not be able to refresh

can you call a procedure from trigger in Pl/Sql