I'm trying to use a combo of to_char and to_date to calculate from a
provided date, the date of the corresponding day-of-week of the
corresponding week-of-year of the previous year.
For example, 11-JAN-2001 (Thurs, wk 2 of 2001) should give me 06-JAN-2000

i just posted here on a group called alt suicide .My friend was using
that group and he didnt signed off and i posted with HIS PROFILE AND
ASKED ABOUT METHODS ABOUT SUICIDE and then i reliazed that it was his
one then i suddenly i signed out I WAS SHOCKED AND SCARED! MY PRIVECY

I'm still relatively green as a DBA, so excuse the possibly simple
question...
We have a DB that is seeing a lot of deadlocks, occasionally hundreds
at a time.  Yes, typically this is an external-application/development

We hit a strange problem on version 8.1.7.
select col1,col2,col3 from tab1,view1,tab2.. where col5 >= '08-Sep-07'
select col1,col2,col3 from tab1,view1,tab2.. where col5 >=
to_date(to_char(sysdate-1,'YYYYMMDD'),'YYYYMMDD')

Hi y'all
Im looking for an SQL learning tool, but all i found is GalaXQL
http://sol.gfxile.net/galaxql.html
Did anyone of you use it?

Im looking for an SQL learning tool, but all i found is GalaXQL
http://sol.gfxile.net/galaxql.html
Did anyone of you use it?
thank you very much

Howdy folks I have been stuck on this problem most of the day.
I have some PLSQL that is looping through a recordset and I am
attempting to update a field.
This could possibly fail because I have another session which could

does anyone know how to get the id of the last inserted dataset in
Oracle?
SQL Server does have Scope_Idendity, MySQL has LastInsertID
Thanks,

Can anyone help me with installation of
Oracle Application Server 10g (OAS) ?
OAS installation file is soa_linux_x86_101310_disk1.cpio,
from Oracle home page.

apparently, out of the blue, my blog has been removed
from the ORANA aggregator.
As usual, not even the courtesy of a message explaining why.
Why am I not surprised?  Apparently, the Oracle fusion mafia is

Can anyone help me with installation of
Oracle Application Server 10g (OAS) ?
OAS installation file is soa_linux_x86_101310_disk1.cpio,
from Oracle home page.

Hi guys!!
Presently working with Oracle 9.2.0.5.0 and looking for the same
functionality that REGEXP_SUBSTR gives. Do you have any idea if
something similar would work with the mentioned Oracle version?

10gR2 EE (10.2.0.3.0)
Have a table with a CLOB column.
In my application,
I first INSERT and populate all OTHER columns with an INSERT

i am an oracle novice....i am working on a small project, i've
created a few tables holding employee, projects and clients info. My
parent table is OGEMP whose primary key is SSN, there are 5 other
tables whose foreign key is SSN(referring OGEMP).

First of all sorry for crossposting, posted in the wrong newsgroup
first.....
For a customer I need to create a Portal page, which will invoke a page
portlet. Which page portlet to be shown is decided at runtime, so I need