Can anyone please show me how to call a xmlrpc method from a sql query?
Thank you!

I am trying to sort on multiple columns using a parameter that I
specify as the sort order.
For example,
...

I want to export all tables data in only one shot. I already made a
full export with rows=n parameter, but now I need to retrieve JUST the
data as insert into statements. I've tried many ways using pattern
matching, but I could not success.

we use Oracle 10g on Solaris 10. Before we used Oracle 8i with Solaris
8. We made a test where we insatelled the OS than Oracle and right after
inserted ~35.000 records in empty tables.
At the moment we have a problem that the insert statements - on Oracle

We run an Oracle RAC on 2 servers (rac1pub and rac2pub).
Can I make an SQL-stament showing which users is on which server ?
The reason is, that i have a killed session on rac1pub, that is
blocking the system, and it will not go away. (it has been hanging for

Pls help ...
why this sql statement shows error
ORA-01855: AM/A.M. or PM/P.M. required
INSERT INTO TESTTABLE

Is anybody out there who can verify my reflections on the following
Statspack Report?
STATSPACK report for
DB Name         DB Id    Instance     Inst Num Release     Cluster Host

Dear friends,
First of all, allow me to say that browsing through this forum is a
great learning experience, thank you all. Now to the question: :-)
We have some PSP pages within our application, which we run using OAS

I'm an admin trying facilitate an Oracle conversion from 32bit to 64bit. We're
running AIX 5.3, I've got the old Oracle 32bit kernel extension unloaded and the
OS is now running a 64bit kernel.
The question is, what does the DBA need to do or have me do to get Oracle up in

In our company we have an ERP-system, which runs on an Oracle 10g.
In the warehouse we are now installing a transport system for moving
pallets from one location to another. This system runs on ms sqlserver.
If people in the warehouse wants the transport system to move a pallet,

Is support for the IPC protocol needed in listener.ora on AIX servers when
external procedures are not used ? It's not clear to me.
Matthias

i am using the 10g database . if i want statistic information about
tables ( e.g how often a certain table is selected  ) i have to use the
view 'v$segment_statistics' . is this right ?
if i enter the statement :

I am doing a minus query to compare data in a data conversion. The
problem is there are some rounding discrepancies and I can't seem to
account for them in my minus query. For example, I am already rounding
to the nearest $5, but am still having a problem:

I would like to know how I can collect all stored procedures (SPs),
functions (SFs), packages and SQL calls to the DB between two
timestamps. I tried to write SQL against, DBA_HIST_SNAPSHOT,
DBA_HIST_SYSSTAT, DBA_HIST_SQLSTAT,  DBA_HIST_SQL_PLAN and

I'm seeking some advice. Basically, one of our developers has written
an insert-select statement within a procedure. When the statement is
extracted from the procedure and run in sqlplus it executes in about 30
secs (populated table).