Re: Datawarehousing help

2002-05-06 Thread Pat Hildebrand
on ease of use, understandability, quality of the product, etc > > Thanks > > Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

Re: Converting EBCDIC to ASCII

2001-08-17 Thread Pat Hildebrand
One problem that we encountered with using dd to convert EBCDIC to ASCII (in a completely different situation so it might not apply here) is that brackets came out as the characters having octal values 342 and 343 in ASCII. Pat -- Please see the official ORACLE-L FAQ: http

Re: How do they get the answer?

2001-08-21 Thread Pat Hildebrand
salary > increase. > (D) A syntax error will occur. > > Answer: > (C) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

listener supports no services

2001-08-29 Thread Pat Hildebrand
store their data locally. A TAR has been opened with Oracle but at this point we looking for all suggestions. TIA Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: listener supports no services

2001-08-31 Thread Pat Hildebrand
We have found our problem. It was a patch that didn't link properly and just coincidence that it appeared that the machine could no longer be found when the ip-address was changed. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: Why is this code not working?

2001-12-11 Thread Pat Hildebrand
CT 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

Re: Formatting of listserv messages

2002-02-02 Thread Pat Hildebrand
ifornia-- Public Internet access / Mailing Lists > > 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

Re: Dropping table space where name is lower case

2002-02-20 Thread Pat Hildebrand
removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Dieg

virus question

2001-06-27 Thread Pat Hildebrand
same attachment. At this point I haven't received any but since I frequently receive messages out of order that does prove anything. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Ne

Re: How to search all tables for a particular field?

2001-07-19 Thread Pat Hildebrand
in caps. If you mean all that a particular user can use replace dba with all and run query as that user. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-505

Re: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-01 Thread Pat Hildebrand
at is on the tape and where it came from? Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-

Re: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-02 Thread Pat Hildebrand
ffering from too much bit rot. > > CP/M was the other OS in contention. > And the DEC rainbow shipped with both DOS and CP/M. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network

Re: SQL Question

2001-08-02 Thread Pat Hildebrand
e official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: OT -- suggestions to ensure nerdiness in potential IT staff

2001-08-03 Thread Pat Hildebrand
Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Intern

OT (fwd) Looking to resurrect .ZZZ archive file from Kaypro/CPM days

2001-08-03 Thread Pat Hildebrand
tter at all - > seems to fall outside the range of history covered on the web.) > > I would be grateful if anyone out there could offer some answeres, > insights, or suggestions regarding this matter. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat

Re: New York/East Coast !!!!

2001-09-11 Thread Pat Hildebrand
www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from thi

Re: Create excelfile from pl/sql

2001-09-24 Thread Pat Hildebrand
> > Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Anyone else had a Virus alert for Stephane Faroult's email ?

2002-11-25 Thread Pat Hildebrand
(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 O

OAS Mac IE with secure server

2002-12-09 Thread Pat Hildebrand
S configuration problem am sorry for what could turn out to be an off topic post. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

Re: Orawomen

2003-01-08 Thread Pat Hildebrand
to get a little more on topic. In a database class when I said that relational databases made sense to me the responses was "you're a mathematician, aren't you?" Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pat Hildebrand

Re: To Anyone involved in Web apps

2003-01-21 Thread Pat Hildebrand
t; opinions you wish to contribute will be helpful. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list a

Re: Restricting the range of values in a field

2003-01-30 Thread Pat Hildebrand
to trap an > unwanted value. > > > Thanks > > -- > Aidan Whitehall <[EMAIL PROTECTED]> > Macromedia ColdFusion Developer -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services--

Re: DBMS_JOB

2003-02-18 Thread Pat Hildebrand
every 15 minutes, > unless the time of day is between X and Y (for example 00:00am > 03:00am)? > > All help appreciated! Pointers to RTFM more than welcome! ;) > > Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pat Hildebrand INET: [EMAIL PR

Re: Where is the sql stored for a stored procedure?

2003-02-20 Thread Pat Hildebrand
E-L FAQ: http://www.orafaq.net > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ---------

RE: DBA tools on NT - PERL

2002-08-15 Thread Pat Hildebrand
ot a problem but standards for cataloging it were. It was in this context that I heard about perl. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: mixed case text

2002-09-12 Thread Pat Hildebrand
ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: oracle sysdate problem ??

2002-09-12 Thread Pat Hildebrand
te,'mm/dd/yy hh:mm:ss am') ^^ should be mi > from dual; > Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Cal

Re: How to pass string with a ' to PL/SQL

2003-06-10 Thread Pat Hildebrand
=20 > RETURN rt_addressinfo; > > EXCEPTION=20 > WHEN OTHERS THEN return rt_addressinfo; > END fu_sales_analysis_address; > > FUNCTION fu_sales_analysis_wtn (in_customerinfoid IN NUMBER) > RETURN pkg_cursors.ref_cursor IS rt_wtn pkg_cursors.ref_cursor; &

Re: NOT IN performance problem

2002-06-25 Thread Pat Hildebrand
CTED] (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

Re: Input truncated to 1 characters

2001-05-03 Thread Pat Hildebrand
You are missing a newline after the / at the end of the procedure. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Oracle error -20001

2001-05-11 Thread Pat Hildebrand
body are valid. Any help in unraveling this would be greaterly appreciated. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: strange problem

2001-05-14 Thread Pat Hildebrand
role this is the expected result. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mail

Re: Mean/Median

2001-05-14 Thread Pat Hildebrand
than some of the others. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acces

Re: job offer from SAUDI ARABIA

2001-05-18 Thread Pat Hildebrand
and I don't think they would be amused by Dad's "Middle American Mongrel." What one thing can I put down? Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services

Re: Last Fri. of the Month ?

2001-02-22 Thread Pat Hildebrand
7, 'Friday') from dual; Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Pub

Re: questions: security on the unix

2001-02-23 Thread Pat Hildebrand
a > > Mitchell > > Are you set uid all the way down to and including the mount point to be able to run as oracle and therefore have the necessary permissions? Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand

Re: Select won't work for view create

2001-04-05 Thread Pat Hildebrand
Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

Re: Thanks and another book request

2001-02-02 Thread Pat Hildebrand
has to repeat because people don't believe her. Pat -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Hildebrand INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califor