Using Oracle 7.3 -
I want to order on a long column, but get a message that it
is illegal use of the type.
What I am trying to do is an extract of user_constraints that
will be comparable to a similar extract from another schema on
another database on another box.
I have been instructed to verify the constraints between these two
places and make sure they are ok.
I use decode to drop the system generated portion of the constraint
names,
but I can't get around the delete_rule being a long column, and that's
where
the extracts are differing. I really want to be able to use a Unix diff
command
to verify the constraints are all the same.
Does anyone have a work around for ordering by a LONG??
Received on Sat Mar 06 1999 - 15:47:29 CST
