subject:"RE\: PL\/SQL Date Format"

RE: PL/SQL Date Format

2003-01-08 Thread Mercadante, Thomas F




Dan,

Look 
at the TO_DATE function. You can easily change your procedure to the 
following:


PROCEDURE 
set_expire_date ( p_user_group_id IN NUMBER DEFAULT 
NULL, 
p_product_id IN VARCHAR2 DEFAULT 
NULL, 
p_expire_date IN VARCHAR2 DEFAULT NULL)IS
local_date 
date; 
== added this
BEGIN dbms_output.enable(1); 
dbms_output.put_line('This is set_expire_date');
 local_date := 
to_Date(p_expire_date,'-MM-DD');  added 
this

 
dbms_output.put_line('Expire date is '||to_char(local_date, '-MM-DD')); == changed this 
EXCEPTION WHEN INVALID_NUMBER 
THEN dbms_output.put_line('Invalid Date 
format'); dbms_output.put_line('Format must be 
-MM-DD ('||to_char(sysdate, '-MM-DD')||')'); WHEN 
VALUE_ERROR THEN dbms_output.put_line('Invalid 
Date format'); dbms_output.put_line('Format 
must be -MM-DD ('||to_char(sysdate, '-MM-DD')||')');END 
set_expire_date;


Hope this helps
Tom Mercadante Oracle Certified Professional 

  -Original Message-From: Fink, Dan 
  [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 6:20 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  PL/SQL Date Format
  Okay, PL/SQL 
  programmers, a lowly dba is in need of your assistance. If you will show pity 
  on my poor self, who does not deserve even the mearest consideration, I will 
  be greatly indebted...
  
  I have a proc that 
  needs to process a date field. The users want to enter it in a specific format 
  (-MM-DD)that is not the same as the system format (DD-MON-YY). If 
  they do not enter the correct format, I need to raise an exception. The 
  parameter was set as DATE, but it would not allow me to enter the requested 
  format, so I changed it to VARCHAR2. When it was date, it would not accept the 
  requested format. When it is varchar2, PL/SQL does an implict conversion of 
  the date. Unfortunately, it is an incomplete conversion and the date is not 
  correct (see example below).
  
  
  
  SQL execute 
  qa_subs.set_expire_date(1,'TEST','01-JAN-01');This is 
  set_expire_dateExpire date is 0001-01-01
  
  SQL execute 
  qa_subs.set_expire_date(1,'TEST','2001-01-01');This is 
  set_expire_dateExpire date is 2001-01-01
  
  So I added a substr to extract the date 
  and try to convert it to numbers. Very 
  unelegant...
  
  PROCEDURE 
  set_expire_date ( p_user_group_id IN NUMBER DEFAULT 
  NULL, 
  p_product_id IN VARCHAR2 DEFAULT 
  NULL, 
  p_expire_date IN VARCHAR2 DEFAULT NULL)ISBEGIN 
  dbms_output.enable(1); dbms_output.put_line('This is 
  set_expire_date'); v_expire_year := substr(p_expire_date, 1, 
  4); v_expire_month := substr(p_expire_date, 
  6,2); v_expire_day := substr(p_expire_date, 
  9,2); v_expire_date := to_date(p_expire_date, 
  '-MM-DD'); dbms_output.put_line('Expire date is 
  '||to_char(v_expire_date, '-MM-DD')); 
  EXCEPTION WHEN INVALID_NUMBER 
  THEN dbms_output.put_line('Invalid Date 
  format'); dbms_output.put_line('Format must 
  be -MM-DD ('||to_char(sysdate, '-MM-DD')||')'); WHEN 
  VALUE_ERROR THEN 
  dbms_output.put_line('Invalid Date format'); 
  dbms_output.put_line('Format must be -MM-DD ('||to_char(sysdate, 
  '-MM-DD')||')');END set_expire_date;
  
  Is there a method 
  (other than altering the session before calling the proc) to force an input 
  value to be in a certain format? I've checked my docs and online and I'm 
  drawing a blank.
  
  With Humble 
  regards,
  
  Dan 
  Fink

RE: PL/SQL Date Format

2003-01-08 Thread Jared . Still

Ok, try this one.  It's a little smarter.  :)



create or replace function df1
( date_in varchar2 )
return date
is
   x_date exception;
   pragma exception_init(x_date, -1830);
   v_source_date_format varchar2(20) := '-mm-dd';

begin
   if  owa_pattern.match(date_in,'^\d{4}-\d{2}-\d{2}')
   then
  null;
   else
  raise_application_error(-2,'Hey! Thats a bad date!');
   end if;
   return to_date(date_in, v_source_date_format);
end;
/

show errors function df1

Jared






Jeremy Pulcifer [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 01/07/2003 05:38 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:RE: PL/SQL Date Format


Not good, Jared. Try this: 
SQL select df1('01-JAN-03') from dual; 
DF1('01-J 
- 
03-JAN-01 
Oops! I don't know how you could do this other than to parse the string 
like you did and look for invalid_num exceptions. Or force the app 
software to handle the data entry validation and convert it to a data 
format.
 -Original Message- 
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, January 07, 2003 4:53 PM 
 To: Multiple recipients of list ORACLE-L 
 Subject: Re: PL/SQL Date Format 
 
 
 How about: 
 
 create or replace function df1 
 ( date_in varchar2 ) 
 return date 
 is 
v_test_date date; 
x_date exception; 
pragma exception_init(x_date, -1830); 
v_source_date_format varchar2(20) := '-mm-dd'; 
 
 begin 
begin 
   v_test_date := to_date(date_in, v_source_date_format); 
exception 
when x_date then 
   raise_application_error(-2,'Hey! Thats a bad date!'); 
end; 
return v_test_date; 
 end; 
 / 
 
 show errors function df1 
 
 select df1('2003-01-07') from dual; 
 select df1('01-07-2003') from dual; 
 
 
 Jared 
 
 
 
 
 
 
 Fink, Dan [EMAIL PROTECTED] 
 Sent by: [EMAIL PROTECTED] 
  01/07/2003 03:20 PM 
  Please respond to ORACLE-L 
 
 
 To: Multiple recipients of list ORACLE-L 
 [EMAIL PROTECTED] 
 cc: 
 Subject:PL/SQL Date Format 
 
 
 Okay, PL/SQL programmers, a lowly dba is in need of your 
 assistance. If 
 you will show pity on my poor self, who does not deserve even 
 the mearest 
 consideration, I will be greatly indebted... 
 
 I have a proc that needs to process a date field. The users 
 want to enter 
 it in a specific format (-MM-DD) that is not the same as 
 the system 
 format (DD-MON-YY). If they do not enter the correct format, 
 I need to 
 raise an exception. The parameter was set as DATE, but it 
 would not allow 
 me to enter the requested format, so I changed it to 
 VARCHAR2. When it was 
 date, it would not accept the requested format. When it is varchar2, 
 PL/SQL does an implict conversion of the date. Unfortunately, 
 it is an 
 incomplete conversion and the date is not correct (see example below). 
 
 
 SQL execute qa_subs.set_expire_date(1,'TEST','01-JAN-01'); 
 This is set_expire_date 
 Expire date is 0001-01-01 
 
 SQL execute qa_subs.set_expire_date(1,'TEST','2001-01-01'); 
 This is set_expire_date 
 Expire date is 2001-01-01 
 
 So I added a substr to extract the date and try to convert it 
 to numbers. 
 Very unelegant... 
 
 PROCEDURE set_expire_date ( p_user_group_id IN NUMBER DEFAULT NULL, 
 p_product_id IN VARCHAR2 DEFAULT NULL, 
 p_expire_date IN VARCHAR2 DEFAULT 
 NULL) IS BEGIN 
dbms_output.enable(1); 
dbms_output.put_line('This is set_expire_date'); 
v_expire_year := substr(p_expire_date, 1, 4); 
v_expire_month := substr(p_expire_date, 6,2); 
v_expire_day := substr(p_expire_date, 9,2); 
v_expire_date := to_date(p_expire_date, '-MM-DD'); 
dbms_output.put_line('Expire date is '||to_char(v_expire_date, 
 '-MM-DD')); 
 
 EXCEPTION 
WHEN INVALID_NUMBER THEN 
   dbms_output.put_line('Invalid Date format'); 
   dbms_output.put_line('Format must be -MM-DD 
 ('||to_char(sysdate, 
 '-MM-DD')||')'); 
WHEN VALUE_ERROR THEN 
   dbms_output.put_line('Invalid Date format'); 
   dbms_output.put_line('Format must be -MM-DD 
 ('||to_char(sysdate, 
 '-MM-DD')||')'); 
 END set_expire_date; 
 
 Is there a method (other than altering the session before calling the 
 proc) to force an input value to be in a certain format? I've 
 checked my 
 docs and online and I'm drawing a blank. 
 
 With Humble regards, 
 
 Dan Fink 
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net 
 -- 
 Author: 
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
 San Diego, California-- Mailing list and web hosting services 
 - 
 To REMOVE yourself from this mailing list, send an E-Mail message 
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include

Re: PL/SQL Date Format

2003-01-08 Thread Vladimir Begun

Jared,

SELECT df1('2002-13-01') FROM dual; -- :)

CREATE OR REPLACE PROCEDURE set_expire_date (
  p_user_group_id  IN NUMBER DEFAULT NULL,
  p_product_id IN VARCHAR2 DEFAULT NULL,
  p_expire_dateIN VARCHAR2 DEFAULT NULL
)
IS
  ld_dummy DATE;
BEGIN
   ld_dummy := TO_DATE(p_expire_date, '-MM-DD');
   IF (TO_CHAR(ld_dummy, '-MM-DD') = p_expire_date)
   THEN
 dbms_output.put_line('Modified value: ' || TO_CHAR(ld_dummy, 
'-MM-DD'));
   ELSE
 dbms_output.put('Err:');
 dbms_output.put('p_expire_date=' || p_expire_date || '');
 dbms_output.put_line(',ld_dummy=' || TO_CHAR(ld_dummy, '-MM-DD'));
   END IF;
EXCEPTION
WHEN OTHERS THEN
  dbms_output.put_line('Something is wrong');
END set_expire_date;
/
SET SERVEROUTPUT ON
EXECUTE set_expire_date(1, 'TEST', '0001- 1-01');
EXECUTE set_expire_date(1, 'TEST', '01-01-01');
EXECUTE set_expire_date(1, 'TEST', '2001-13-01');
EXECUTE set_expire_date(1, 'TEST', '12-2002-01');
EXECUTE set_expire_date(1, 'TEST', '2002-12-01');
EXECUTE set_expire_date(1, 'TEST', '  01-01-01');
EXECUTE set_expire_date(1, 'TEST', NULL);
EXECUTE set_expire_date(1, 'TEST', '01-JAN-03');
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.

[EMAIL PROTECTED] wrote:
Ok, try this one.  It's a little smarter.  :)



create or replace function df1
( date_in varchar2 )
return date
is
   x_date exception;
   pragma exception_init(x_date, -1830);
   v_source_date_format varchar2(20) := '-mm-dd';

begin
   if  owa_pattern.match(date_in,'^\d{4}-\d{2}-\d{2}')
   then
  null;
   else
  raise_application_error(-2,'Hey! Thats a bad date!');
   end if;
   return to_date(date_in, v_source_date_format);
end;
/

show errors function df1

Jared


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
 INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: PL/SQL Date Format

2003-01-08 Thread Jared . Still

Hey, I'm a concepts guy!

He asked for valid formats, not valid dates. 

Just combine the code from my 2 posts, and your done.

:)

Jared






Vladimir Begun [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 01/08/2003 02:29 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:Re: PL/SQL Date Format


Jared,

SELECT df1('2002-13-01') FROM dual; -- :)

CREATE OR REPLACE PROCEDURE set_expire_date (
   p_user_group_id  IN NUMBER DEFAULT NULL,
   p_product_id IN VARCHAR2 DEFAULT NULL,
   p_expire_dateIN VARCHAR2 DEFAULT NULL
)
IS
   ld_dummy DATE;
BEGIN
ld_dummy := TO_DATE(p_expire_date, '-MM-DD');
IF (TO_CHAR(ld_dummy, '-MM-DD') = p_expire_date)
THEN
  dbms_output.put_line('Modified value: ' || TO_CHAR(ld_dummy, 
'-MM-DD'));
ELSE
  dbms_output.put('Err:');
  dbms_output.put('p_expire_date=' || p_expire_date || '');
  dbms_output.put_line(',ld_dummy=' || TO_CHAR(ld_dummy, 
'-MM-DD'));
END IF;
EXCEPTION
WHEN OTHERS THEN
   dbms_output.put_line('Something is wrong');
END set_expire_date;
/
SET SERVEROUTPUT ON
EXECUTE set_expire_date(1, 'TEST', '0001- 1-01');
EXECUTE set_expire_date(1, 'TEST', '01-01-01');
EXECUTE set_expire_date(1, 'TEST', '2001-13-01');
EXECUTE set_expire_date(1, 'TEST', '12-2002-01');
EXECUTE set_expire_date(1, 'TEST', '2002-12-01');
EXECUTE set_expire_date(1, 'TEST', '  01-01-01');
EXECUTE set_expire_date(1, 'TEST', NULL);
EXECUTE set_expire_date(1, 'TEST', '01-JAN-03');
-- 
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.

[EMAIL PROTECTED] wrote:
 Ok, try this one.  It's a little smarter.  :)
 
 
 
 create or replace function df1
 ( date_in varchar2 )
 return date
 is
x_date exception;
pragma exception_init(x_date, -1830);
v_source_date_format varchar2(20) := '-mm-dd';
 
 begin
if  owa_pattern.match(date_in,'^\d{4}-\d{2}-\d{2}')
then
   null;
else
   raise_application_error(-2,'Hey! Thats a bad date!');
end if;
return to_date(date_in, v_source_date_format);
 end;
 /
 
 show errors function df1
 
 Jared

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vladimir Begun
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: PL/SQL Date Format

2003-01-07 Thread Jared . Still

How about:

create or replace function df1
( date_in varchar2 )
return date
is
   v_test_date date;
   x_date exception;
   pragma exception_init(x_date, -1830);
   v_source_date_format varchar2(20) := '-mm-dd';

begin
   begin
  v_test_date := to_date(date_in, v_source_date_format);
   exception
   when x_date then
  raise_application_error(-2,'Hey! Thats a bad date!');
   end;
   return v_test_date;
end;
/

show errors function df1

select df1('2003-01-07') from dual;
select df1('01-07-2003') from dual;


Jared






Fink, Dan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
 01/07/2003 03:20 PM
 Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc: 
Subject:PL/SQL Date Format


Okay, PL/SQL programmers, a lowly dba is in need of your assistance. If 
you will show pity on my poor self, who does not deserve even the mearest 
consideration, I will be greatly indebted...
 
I have a proc that needs to process a date field. The users want to enter 
it in a specific format (-MM-DD) that is not the same as the system 
format (DD-MON-YY). If they do not enter the correct format, I need to 
raise an exception. The parameter was set as DATE, but it would not allow 
me to enter the requested format, so I changed it to VARCHAR2. When it was 
date, it would not accept the requested format. When it is varchar2, 
PL/SQL does an implict conversion of the date. Unfortunately, it is an 
incomplete conversion and the date is not correct (see example below).
 
 
SQL execute qa_subs.set_expire_date(1,'TEST','01-JAN-01');
This is set_expire_date
Expire date is 0001-01-01
 
SQL execute qa_subs.set_expire_date(1,'TEST','2001-01-01');
This is set_expire_date
Expire date is 2001-01-01
 
So I added a substr to extract the date and try to convert it to numbers. 
Very unelegant...
 
PROCEDURE set_expire_date ( p_user_group_id IN NUMBER DEFAULT NULL,
p_product_id IN VARCHAR2 DEFAULT NULL,
p_expire_date IN VARCHAR2 DEFAULT NULL)
IS
BEGIN
   dbms_output.enable(1);
   dbms_output.put_line('This is set_expire_date');
   v_expire_year := substr(p_expire_date, 1, 4);
   v_expire_month := substr(p_expire_date, 6,2);
   v_expire_day := substr(p_expire_date, 9,2);
   v_expire_date := to_date(p_expire_date, '-MM-DD');
   dbms_output.put_line('Expire date is '||to_char(v_expire_date, 
'-MM-DD'));
 
EXCEPTION
   WHEN INVALID_NUMBER THEN
  dbms_output.put_line('Invalid Date format');
  dbms_output.put_line('Format must be -MM-DD ('||to_char(sysdate, 
'-MM-DD')||')');
   WHEN VALUE_ERROR THEN
  dbms_output.put_line('Invalid Date format');
  dbms_output.put_line('Format must be -MM-DD ('||to_char(sysdate, 
'-MM-DD')||')');
END set_expire_date;
 
Is there a method (other than altering the session before calling the 
proc) to force an input value to be in a certain format? I've checked my 
docs and online and I'm drawing a blank.
 
With Humble regards,
 
Dan Fink


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: PL/SQL Date Format

2003-01-07 Thread Jeremy Pulcifer

Title: RE: PL/SQL Date Format





Not good, Jared. Try this:


SQL select df1('01-JAN-03') from dual;


DF1('01-J
-
03-JAN-01


Oops! I don't know how you could do this other than to parse the string like you did and look for invalid_num exceptions. Or force the app software to handle the data entry validation and convert it to a data format.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, January 07, 2003 4:53 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: PL/SQL Date Format
 
 
 How about:
 
 create or replace function df1
 ( date_in varchar2 )
 return date
 is
 v_test_date date;
 x_date exception;
 pragma exception_init(x_date, -1830);
 v_source_date_format varchar2(20) := '-mm-dd';
 
 begin
 begin
 v_test_date := to_date(date_in, v_source_date_format);
 exception
 when x_date then
 raise_application_error(-2,'Hey! Thats a bad date!');
 end;
 return v_test_date;
 end;
 /
 
 show errors function df1
 
 select df1('2003-01-07') from dual;
 select df1('01-07-2003') from dual;
 
 
 Jared
 
 
 
 
 
 
 Fink, Dan [EMAIL PROTECTED]
 Sent by: [EMAIL PROTECTED]
 01/07/2003 03:20 PM
 Please respond to ORACLE-L
 
 
 To: Multiple recipients of list ORACLE-L 
 [EMAIL PROTECTED]
 cc: 
 Subject: PL/SQL Date Format
 
 
 Okay, PL/SQL programmers, a lowly dba is in need of your 
 assistance. If 
 you will show pity on my poor self, who does not deserve even 
 the mearest 
 consideration, I will be greatly indebted...
 
 I have a proc that needs to process a date field. The users 
 want to enter 
 it in a specific format (-MM-DD) that is not the same as 
 the system 
 format (DD-MON-YY). If they do not enter the correct format, 
 I need to 
 raise an exception. The parameter was set as DATE, but it 
 would not allow 
 me to enter the requested format, so I changed it to 
 VARCHAR2. When it was 
 date, it would not accept the requested format. When it is varchar2, 
 PL/SQL does an implict conversion of the date. Unfortunately, 
 it is an 
 incomplete conversion and the date is not correct (see example below).
 
 
 SQL execute qa_subs.set_expire_date(1,'TEST','01-JAN-01');
 This is set_expire_date
 Expire date is 0001-01-01
 
 SQL execute qa_subs.set_expire_date(1,'TEST','2001-01-01');
 This is set_expire_date
 Expire date is 2001-01-01
 
 So I added a substr to extract the date and try to convert it 
 to numbers. 
 Very unelegant...
 
 PROCEDURE set_expire_date ( p_user_group_id IN NUMBER DEFAULT NULL,
 p_product_id IN VARCHAR2 DEFAULT NULL,
 p_expire_date IN VARCHAR2 DEFAULT 
 NULL) IS BEGIN
 dbms_output.enable(1);
 dbms_output.put_line('This is set_expire_date');
 v_expire_year := substr(p_expire_date, 1, 4);
 v_expire_month := substr(p_expire_date, 6,2);
 v_expire_day := substr(p_expire_date, 9,2);
 v_expire_date := to_date(p_expire_date, '-MM-DD');
 dbms_output.put_line('Expire date is '||to_char(v_expire_date, 
 '-MM-DD'));
 
 EXCEPTION
 WHEN INVALID_NUMBER THEN
 dbms_output.put_line('Invalid Date format');
 dbms_output.put_line('Format must be -MM-DD 
 ('||to_char(sysdate, 
 '-MM-DD')||')');
 WHEN VALUE_ERROR THEN
 dbms_output.put_line('Invalid Date format');
 dbms_output.put_line('Format must be -MM-DD 
 ('||to_char(sysdate, 
 '-MM-DD')||')');
 END set_expire_date;
 
 Is there a method (other than altering the session before calling the 
 proc) to force an input value to be in a certain format? I've 
 checked my 
 docs and online and I'm drawing a blank.
 
 With Humble regards,
 
 Dan Fink
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: 
 INET: [EMAIL PROTECTED]
 
 Fat City Network Services -- 858-538-5051 http://www.fatcity.com
 San Diego, California -- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') 
 and in the message BODY, include a line containing: UNSUB 
 ORACLE-L (or the name of mailing list you want to be removed 
 from). You may also send the HELP command for other 
 information (like subscribing).

RE: PL/SQL Date Format

RE: PL/SQL Date Format

Re: PL/SQL Date Format

Re: PL/SQL Date Format

Re: PL/SQL Date Format

RE: PL/SQL Date Format

6 matches

Site Navigation

Mail list logo

Footer information