My query looks like:
select a.type_id, sum(cost)  as summary
from a, b,  c, d, e
where a.type_id = e.type_id

I have seen the problem reported in various news groups going back to
1999 (Deja.News).  Does anyone know if it's been fixed yet.  There
appears to be no solution on the web.
I call a simple stored procedure from a java program and use the

I need to discard the first and last element from an ordered set of
values returned by a query.
For example, I have the following query:
select

I am using Oracle 9.2.0.5 on HP  UNIX 11i. I am calling an https URL
from a PL/SQL function using utl_http. I have saved server certificate
(i.e., calling URL web-site certificates) in Oracle Wallet and have my
https call working.

Hello everyone, this is my question. Where are most recently executed
PL/SQL statements stored in a DEDICATED SERVER mode? Are these
statements stored in the shared PL/SQL area in the library cache or in
a certain area of the PGA? If it is in the PGA, then what specific part

Anyone worked with interfacing MQ Series or Secured Web Service(web
service with a digital certificate) using Oracle ?
Thanks
Jiten

I searched the internet without success (or maybe without asking the
right question...) so I'll hope to find here the answer ... do anyone
know if there's a limit on how many tables could be created into an
Oracle 7.3.4 database?

i am interested in knowing about the scripts/sql statements DBAs use on
day to day basis.
May i request the group members to let me know where can i find such
sql statements.

Hey there,
im in the need of a Statement that returns the datatype of a
columnname/table that is included into the statement.
Something that returns me types like Numeric or Blob.

Yes, really. I have database on a schema A and need to
create users that have access to A's tables. Also one
of the tables need to be viewed by the use so that only
those rows that are either common or belong to the user

pls how do i add users to the database using just sql

Hi, all
I have DB Server ( Sun Server act as Oracle 8i DB Server ).
and
I have Web Server ( Dell Server RHEL4 ES  act as Web Server  run

We just reinstalled our two node RAC, to upgrade the machines. We are
now facing a strange problem:
Everytime we have both instances up, any query with user SYSTEM on the
GV$ and DBA_ views results in ORA-00600 [15735].

I would like to write a query (probably with analytic functions) that
when given the 'weight' (for example salary) , it distributes the
salary between X groups with the same (more or less) weight.
example:

Please help about Thai character on Oracle ...
=====================================
Hi,
I 've already install Oracle-XE on My Redhat Server.