We are making some changes and I'd like to know if this can be done
with a trigger.
I have Table1 which is the master table and Table2 which is the
history table.  Currently we have over 100 places where Table1 is

I can get a list of all my functions + procedures via:
select distinct object_name, package_name, overload
 from all_arguments
where owner = 'MYNAME'

Dear group,
Somehow my archivelog is in the primary site ASM disk, but failed to
shipped to standby site.
If I do

The following query will return 3 word in 3 "TABLE COLUMN", How can I
modify the query to return "NO 3 words are the same"?
the following Table will have duplicated as both row has the same 3
words, I only need "a, young, woman" is enough. I do not need "a,

We are at :
Oracle 9.2.0.6
HP Ux : 11.23
RAC : 02 Node

I am using Oracle 10g.
Please answer my doubts regarding Materialized Views ( MV ) :
1. if we give the option 'enable query rewrite' option, while creating
MV, will the optimizer do automatic query rewriting and optimize the

I have table with parallel degree 4.
I altered the table with  parallel degree 8.
But the insert query of that table didnt take the parallel process of
8, though i forced the parallel hint with 8. Instead it is taking

This is interesting.  Say I have a package with a function in it.  The
function is local to that package only and is not called from the
outside.
Now, I have a line like this:

what is the size of the Oracle datatype NUMBER in bytes?
Thank you,
Norbert

Hi Gang
I have a table that has the following.
Part          Revision
AA1234     1

Hi people, this is a continuation of the post titled "ACCELERATING
STORED PROCEDURE" from the last week, am sorry for the inconvenience
that might cause them to have to read the previous post but its a long
history as you can see, so the last post was very useful and thanks

Having a extremely low budget for IT,  I tried to design a very cheap
recovery database system without having to pay for a standby database.
This is the idea:
1 -use a duplex destination for the archive logs located in a remote

The following query will output 2 word that's close in position, but
how can I output 3 word that's close in position instead of 2 word?
the query will have 3 column output instead of 2 column output for
words.

Can you have a select statement that returns a literal AND normal
query results without a UNION?
Say I have a parameter, like and employee ID, passed to a procedure.
I want to run a query which returns the top 4 records in the result

I am new to Oracle and I was wondering if someone could help me with a
query.  Basically, what I want to know is how to return all the
columns in a given table EXCLUDING the primary key column.
Thanks In Advance,