We have a 9.2 database with journaling against a number of tables using
packages and triggers generated from Designer 6i.
This has happily worked away for a few months until someone used a MERGE
statement. This caused a trigger failure on the after update statement

How can I superscript data from a database table?  Any help is appreciated.

We want to develop database driven website. because of enormous amount
of data (300GB)
customers's tech advisor is insisting on using SAN instead of  direct
attached storage method.

I am a Oracle newbie, looking for a freeware performance measurement tool
for Oracle Server on various systems running Microsoft Windows. I am
interested in simulating large number of clients (say 200) and check the CPU
utilization, IO throughput and TPS with the OLTP operations.

I have two similar databases which I want to diff the
source codes of procedures, packages, views, triggers, etc.
I can use Toad to export the source codes and then do
a diff.

I noticed some invalid characters, control characters in an Oracle
table.  There was an upside question mark in the LNAME field.
I want to write a query to select all rows which have an Invalid
Character in the LNAME field.

Dear,
can somebody give me a place where i can download one of these 2 database
software and where i don't have to create an account?
Is it true that whit windows XP you have to use the 9 and not the 8?

Does someone work with Oracle Portal here ? I need to to know how can I
build an URL to redirect to a TAB within a page, knowing the internal name
of that page. I don't use Page's URL rendered by Oracle Portal , because
they are not safe, page ID's can change, I use instead this ...

i'm new, so i want to ask you if you know how can i check if a
database is available before i connect to it. I am using Oracle 7.3.4
on a UNIX machine, and i am using Oracle Forms 4.5.
The situation goes as follows: I'm using Oracle Forms and i want at

My application uses pro*c for database interaction. All application
objects have unique ids which are usigned long long type. Can someone
please suggest
1. what should be the column datatype to store this value? I am

To be honest, I am not a programmer or even have very indepth knowledge
of Oracle products.
Recently our company have some problems with the applications that were
developed using Oracle Forms & reports 2000 about 5 years ago. The last

My problem is that I have quite a few reports that take a long time to
complete due to the fact that they acces a huge amount of data.
What I want to achieve is to present something like a progress bar or
completed percentage, that will inform the user how long it will take

If you have a delimeted text file which is to be uploaded into 2
tables, one a parent table and the other a child table - how is this
handled when the primary key is generated from a sequence?  Also in
general is there a PL/SQL like scripting language associated with

Problem : loading XML messages in Oracle 8i database with Oracle's XML
Parser for JAVA 817. This works just fine in 8i : java
oracle.xml.parser.v2.oraxsl -v -d $INFILEDIR -i XML -s
/home/cdb/inflow/transform/V4/parser.xsl -o $INFILEDIR -r JAVA -t 1 -e

I have been working on this all day and I am still stuck. Would you have
some advice? Here is the situation:
I have some data that I want to move from mysql to oracle. Some of
the fields are large blocks of html, about 3000 characters in a