I have a task table that has a hierarchial structure as follows:
Visit One
   Task A
   Task B

I am new to Oracle 9i. I have just installed it and it is not showing
me the performance counters for Oracle in sysPerfMon (System
performance monitor).
How can we get the Performance counter objects in the sysPerfMon?

I have a table named PAIR with a column that contains name=value pairs.
Now, I have a conversion script which goes through each row of this
table, and parses the contents of the name-value column putting the
results into two separate tables.  The script kinda looks like this:

The www.dizwell.com/BB has been hacked (defaced). Can someone inform Howard
Rogers.
regards,
Ivan

I'm trying to spell out 1,721,131.31 using a plsql and got an error
saying "ORA-01841: (full) year must be between -4713 and +9999, and not
be 0"
Is anybody ever come across this error before?

I have this task.
Basically, I have find a bunch of frequently RUN SQL statements in the
database. (later on to run explain plan on them).
I am running statspak and I do know some sql statements that run a lot

I have heard that in Oracle 8 the PLSQL parser and the SQL parser are
different sets of code within the database.
Basically, I wrote a function with some SQL in it.  When I run the
function, I get one value, and when I run just the SELECT statement I

The performance of some complex PL/SQL functions has dropped
dramatically since migrating from Oracle 8i (8.1.7.0.0) on Windows
Server 2000 to 9i (9.2.0.6.0) on Windows Server 2003. We found out,
that Oracle 9i performance on a multi processor CPU machine (our

Hi, all.
I've been tasked with doing some index cleanup, and am looking for a
way to quantify my task.
My db has about 450 tables in it. In some of these tables, the PK index

How can I select the user_objects from one particular user that is the
owner of these objects? I mean something similar to "select * from
user_objects" but including one particular user.
Best regards,

Is it possible to create a link from oracle database to a mysql table
on another server?
Thanks
-Reuben

hi i have install oracle 10g Enterprise Edition in win xp. Now i want to
insert some character like (alt + 0138 i.e Š)in the table only. The font
used is Type New Roman
my sql command is:

I'm a newbie here.  I try to update data from 1 table from another
table.  So I used cursor to update my employee table on Total_sale
column  = amount column on Sales Table where employee.empid =
sales.empid.  The problem is for 700,000, it took 2 hours to update.

I have heard that in Oracle 8 there is a different 'parser' for native
SQL and SQL that is used within a PLSQL procedure.
I am getting different results if I have the SQL as a view vs if I use
the SQL within the PLSQL procedure.

I am having trouble getting the details section to display info.  I
move the boxes into the Header and footer, they appear, but not in the
detail section.