Environment: Windows XP SP2
Database: Oracle 9.2.0.6
I have a table defined as follows:
CREATE TABLE dpr_opening_balance

I'm trying to write a statement in SQL to return the date of the last
sunday. ie today is
'18-NOV-2005', previous sunday was '13-NOV-2005'. I don't want to use a
function because I don't have access to create functions.

Which UPDATE statement do I need to replace a substring in a column.
e.g.
old value = "\\ComputerA\Projects\aaa.txt"
new value = "C:\Projects\aaa.txt"

I have a problem that hopefully will be very simple to somebody out
there but is causing me a headache at the moment!
This is an example of my problem.
I have a table:

Guys,
   I'm running Oracle 9.2.0.6 on SUN. I've got this huge query
generated by Siebel (I know, I know, all the queries generated by
Siebel are huge!) which goes like this:

I have created a table called movie_by_year which has list parttion
based on the year
CREATE TABLE Movie_By_Year
 2  (MovieID CHAR(4) PRIMARY KEY,

Is the database 9.2.0.4  for AIX 5L exists?

Configuration:
Oracle 10.2.0.1.0 x86_64 on RHEL4 , using ASM and ASMLIB.
4 gigs mem, single Xeon (dual core), 4 D1000's with 48 drives through three
dual interfaced controllers (8 - SCSI hookups) controlled by ASM.

I am sort of new to Oracle and i am using 9i.  I am trying to set up
ISQL*PLUS on my oracle server, but I'm not sure how to set it up.
Can anyone give me, or point me in the right direction on setting up
ISQL*PLUS?

Could anyone help with rewriting queries below that are equivalent to
avoid self-join or subquery in the second query so the materialized
view fast refresh would be possible ?
SELECT *

create or replace directory my_out as '/export/home/mig10g/muthuk';
grant read, write on directory my_out to public;
SQL> create or replace procedure utl_file_test_read
 2  authid current_user

I'm able to get the error number within the SERVERERROR trigger via
ORA_SERVER_ERROR. How is it possible to get the respective error message?
Regards,
Robert

When I insert into a pl/sql table, do I need to commit ?
I have a package body which defines a pl/sql table to contains a DATE
table type;
  TYPE DateTable       IS TABLE OF DATE

I have oracle 9.2.0.7, running on windows 2003, I find some direct path
read/write wait event, and checked the p1 value of the event is 20.
select * from dba_data_files where file_id=20;
0 rows returned

I was looking at an optimized way in pl/sql to compare the data from
tables in two different databases (Oracle 9i). Is there any alternate
to opening cursors for each of the two tables and looping through them?
The table has a few millions of records.