RE: String manipulation

2004-01-27 Thread John Flack
Title: String manipulation I wrote a PL/SQL package with functions you can use for this. Find it athttp://www.smdi.com/employee/johnf/list.pks andhttp://www.smdi.com/employee/johnf/list.pkb. I wrote it so that only the first call parses the string. Subsequent calls use the already parsed

RE: Nextval in trigger

2004-01-26 Thread John Flack
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: John Flack INET: [EMAIL PROTECTED] Fat City Network

RE: commit for triggers

2004-01-23 Thread John Flack
: http://www.orafaq.net -- Author: John Flack 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

RE: commit for triggers

2004-01-23 Thread John Flack
: John Flack 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

RE: tnsnames.ora not working ?

2004-01-21 Thread John Flack
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: John

RE: 9iAS Calender Servlet

2004-01-21 Thread John Flack
, 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: John Flack INET: [EMAIL PROTECTED] Fat City

RE: tnsnames.ora not working ?

2004-01-20 Thread John Flack
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender

RE: Need info on HP Proliant ML 350, on installing Oracle 8i and 9i, urgent.. please

2004-01-09 Thread John Flack
8.1.6.0.0 and 9i on server HP proliant ML 350, with os of windows 2000. I need to get this working by 2 days. So I really need help on this, thanks. Regards Wendry. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services

RE: seperate external procedure listeners for different SIDs

2004-01-09 Thread John Flack
://www.orafaq.net -- Author: John Flack 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

RE: DBA tasks

2004-01-08 Thread John Flack
to fight all those fires. Oh, and if you have no activity on the database, that sucker just flies. Combine the two, and you don't have to work 45 hours a week. HTH, Bambi. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City

RE: seperate external procedure listeners for different SIDs

2004-01-08 Thread John Flack
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: John Flack INET: [EMAIL PROTECTED] Fat City Network

RE: seperate external procedure listeners for different SIDs

2004-01-08 Thread John Flack
, (because, for example I wanted them to run as 2 different application users rather than oracle or use 2 different sets of .so files), I could not do it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services

RE: seperate external procedure listeners for different SIDs

2004-01-08 Thread John Flack
FAQ: http://www.orafaq.net -- Author: John Flack 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

RE: 8i pl/sql question

2003-12-16 Thread John Flack
-dead now and can not seem to find if it can be done and/or how it can be done. TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: How to refresh

2003-12-16 Thread John Flack
import. Is there a tried and true way to just refresh the table data without losing anything else and without having all the problems with triggers and constraints? Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat

RE: long raw risk

2003-12-10 Thread John Flack
defences against (potential) performance problems. Anyone been-there-done-that ? Regards, PdV -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: OS calls with java stored procedures

2003-12-09 Thread John Flack
: http://www.orafaq.net -- Author: John Flack 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

RE: A brief detour....;-)

2003-12-09 Thread John Flack
and assembler (IBM mainframe) in the early 70's. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: can't see a SQL generated by Crystal Report

2003-12-09 Thread John Flack
--- Yechiel Adar [EMAIL PROTECTED] wrote: Are you sure that Crystal does not do any local processing on the data? Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: tis a puzzlement...

2003-12-05 Thread John Flack
] 1916 General theory of relativity. Gravity is a warping of space-time. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: java package to run OS command

2003-12-04 Thread John Flack
://www.orafaq.net -- Author: John Flack 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

RE: java package to run OS command

2003-12-04 Thread John Flack
: http://www.orafaq.net -- Author: John Flack 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

RE: java package to run OS command

2003-12-04 Thread John Flack
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 8.1.7 + redhat AS 2.1 = trouble

2003-08-26 Thread John Flack
Title: 8.1.7 + redhat AS 2.1 = trouble There may be the same issues as with 8.1.7 on RH 7.1 - look on Metalink for those work arounds and try them on your AS 2.1. Basically, it has to do with 8.1.7 expecting the standard C libraries from RH 6.2 which were changed for RH 7.1 and

RE: OT - Linux books ??

2003-08-26 Thread John Flack
://www.orafaq.net -- Author: John Flack 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

RE: Query results to .csv

2003-08-25 Thread John Flack
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Making my firts job

2003-08-22 Thread John Flack
Simple: TRUNC(SYSDATE) + 1 + 1/60/60/24 TRUNC(SYSDATE) is midnight today. +1 is midnight tomorrow. +1/60/60/24 is one second past midnight- 1/60th of a minute, which is 1/60th of an hour, which is 1/24th of a day. -Original Message-From: Teresita Castro [mailto:[EMAIL

RE: Business Rules approach to design?

2003-08-22 Thread John Flack
. anyone have an opinion? (see jared, now we have a database design post). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list