Re: Online tech books

2003-06-30 Thread Jan Pruner
/ - On a quiet Night, you can hear the Windows machines reboot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: MySQL in the future?

2003-06-18 Thread Jan Pruner
[EMAIL PROTECTED] http://jan.pruner.cz/ - On a quiet Night, you can hear the Windows machines reboot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Rule Based Optimizer

2003-06-11 Thread Jan Pruner
-- Author: Jan Pruner 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

Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???

2003-06-05 Thread Jan Pruner
(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: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Shit of the day

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

Re: Oracle 11i new features

2003-05-29 Thread Jan Pruner
-- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - On a quiet Night, you can hear the Windows machines reboot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network

Re: PL/SQL

2003-03-05 Thread Jan Pruner
/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: PLSQL stored procedure

2003-03-05 Thread Jan Pruner
and Object_id of that prodedure but i have no ideea how to get the rest :( please help, adrian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: MS SQL hasn't given up!

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

Re: MS SQL hasn't given up!

2003-02-28 Thread Jan Pruner
=5707 Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Count(*) last 30 seconds

2003-02-11 Thread Jan Pruner
-- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Count(*) last 30 seconds

2003-02-11 Thread Jan Pruner
work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Producing .mdb output from sqlplus or SQL or PL/SQL

2003-01-27 Thread Jan Pruner
Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Freeware tool to browse data in Oracle tables?

2003-01-21 Thread Jan Pruner
need this for regular users who need this tool to be quite simple... Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: SQL query without UNION clause

2002-12-19 Thread Jan Pruner
if you have received this message in error. Thank you. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner

[OT] Patch for PostgreSQL to perform hierarchical queries in Oracle's style.

2002-12-18 Thread Jan Pruner
http://gppl.terminal.ru/ JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re:

2002-12-18 Thread Jan Pruner
his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: password

2002-12-17 Thread Jan Pruner
PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: password

2002-12-17 Thread Jan Pruner
(like subscribing). -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City

OT: about the future of Borland's tools

2002-12-16 Thread Jan Pruner
If you use tools from Borland like Delphi, C++ Builder or Kylix http://delphi.about.com/library/weekly/aa112902a.htm JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: imp table by table

2002-12-10 Thread Jan Pruner
://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Daily job to populate table in another database

2002-12-10 Thread Jan Pruner
: http://www.orafaq.com -- Author: Jan Pruner 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: Something that might be of use

2002-12-05 Thread Jan Pruner
-- Author: Jan Pruner 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

Re:Slightly OT - Who would you take with you...

2002-11-26 Thread Jan Pruner
://www.orafaq.com -- Author: Jan Pruner 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: Oracle 10i features

2002-11-12 Thread Jan Pruner
/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Re: Oracle 10i features

2002-11-12 Thread Jan Pruner
command for other information (like subscribing). -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner

Re: Oracle Server with Linux client

2002-10-24 Thread Jan Pruner
and select to install only client software in installation GUI. Is there any difference in configuration of Net 8 (tnsnames.ora) No. JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Spool Oracle Tables into Excel Format

2002-09-23 Thread Jan Pruner
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Spool Oracle Tables into Excel Format

2002-09-23 Thread Jan Pruner
FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Consulting Position Available-Oracle DBA/Developer/NYC

2002-09-20 Thread Jan Pruner
Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Consulting Position Available-Oracle DBA/Developer/NYC

2002-09-20 Thread Jan Pruner
wrote: Jan Pruner wrote: Does anybody know what table is in MS SQL instead of Oracle DUAL? Thanks JP SQL Server does not have a dual table, pos... -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work

Re: Consulting Position Available-Oracle DBA/Developer/NYC

2002-09-20 Thread Jan Pruner
://www.orafaq.com -- Author: Jan Pruner 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: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

2002-09-20 Thread Jan Pruner
[EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: count(*)

2002-09-20 Thread Jan Pruner
Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: DUAL Was: Consulting Position Available-Oracle DBA/Developer/

2002-09-20 Thread Jan Pruner
[EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Here we go again!!

2002-09-10 Thread Jan Pruner
all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: How long did job run?

2002-09-05 Thread Jan Pruner
] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Changing sysdate

2002-09-04 Thread Jan Pruner
] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Changing sysdate[Scanned]

2002-09-04 Thread Jan Pruner
the sysdate? (Solaris 5.8, Oracle 8.1.7) TIA. K. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET

Re: ssh client for Windoze

2002-09-04 Thread Jan Pruner
his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Off-Topic - SQLServer2k Qs - FS Block Size Stripe Width

2002-09-02 Thread Jan Pruner
-- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services

Re: SQL*Plus in 10i

2002-08-30 Thread Jan Pruner
, It is too late for the pebbles to vote. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL

Re: HIPAA compliance and Win2k

2002-08-29 Thread Jan Pruner
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: LIST ADMIN: VIRUS Warning: Please Repsond

2002-08-29 Thread Jan Pruner
MUM, Eric is listening!!! :-)) On Thursday 29 August 2002 18:08, you wrote: Stop using MS products if you are seriously worried about viruses. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: PL/SQL Editor

2002-08-28 Thread Jan Pruner
his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: PL/SQL Editor

2002-08-28 Thread Jan Pruner
://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: how to startup in restricted mode ?

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

Re: List of all zip codes,city,state to load into table.

2002-08-21 Thread Jan Pruner
,states to load into a table. I have searched but cannot find anything to download. Anyone have a URL that I can get this info. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

Re: PL/SQL Editor.

2002-08-15 Thread Jan Pruner
of New Jobs http://www.hotjobs.com -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL

Re: Finding out last 10 records

2002-08-14 Thread Jan Pruner
If you have a sequence column in table ála primary key: select * from (select * from table order by sequence desc) where rownum 11; Bu you don't have it - no way how to determine last 10 inserted records in table. Jan Pruner - Original Message - From: Santosh Varma

Re: Finding out last 10 records

2002-08-14 Thread Jan Pruner
No, it will not work. You cannot use ROWID to sort records to get 'insert-order'. It is wrong. And you have to use dynamic view if you want ORDER BY and use ROWNUM. Jan Pruner -Original Message- Sent: Wednesday, August 14, 2002 9:13 AM To: Multiple recipients of list ORACLE-L Hi

Re: how to check the existence of a dir on remote server

2002-08-12 Thread Jan Pruner
://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Free ware databases: which are worth the money?

2002-08-02 Thread Jan Pruner
We're using PostgreSQL. Great DB RDBMS with very good performance. Others I know are SAP DB Interbase Look at http://freshmeat.net/ and try to search for RDBMS. Best regards Jan Pruner On Friday 02 August 2002 12:33, you wrote: Hi, we are investigating some

Re: Special characters once again !

2002-08-01 Thread Jan Pruner
] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: How to insert Special Characters ?

2002-07-31 Thread Jan Pruner
: http://www.orafaq.com -- Author: Jan Pruner 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

Re: TRANSLATE

2002-07-31 Thread Jan Pruner
/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: OT: plot by elitists confirmed...

2002-07-31 Thread Jan Pruner
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: fyi: oracle tech support link to free .zip utility

2002-07-19 Thread Jan Pruner
been portability and | non-MSDOS functionality. ... -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan

Re: Storage of numeric data

2002-07-16 Thread Jan Pruner
] -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services

Re: TOra: Toolkit for Oracle

2002-07-14 Thread Jan Pruner
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

OT - Oracle U. defends OCP title

2002-07-11 Thread Jan Pruner
http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci837964,00.html JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: C++ classes

2002-07-07 Thread Jan Pruner
reliable C++ class library to access Oracle DB Vishal _ There is always a better job for you at Monsterindia.com. Go now http://monsterindia.rediff.com/jobs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan

Re: Unable to connect to an Oracle Instance

2002-07-03 Thread Jan Pruner
his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Remove numbers from string

2002-07-01 Thread Jan Pruner
Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Remove numbers from string

2002-07-01 Thread Jan Pruner
('abc123def432' ,'A0123456789','A') replaced FROM DUAL; JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Sql query

2002-06-26 Thread Jan Pruner
one doesnt exist in table2. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: NOT IN performance problem

2002-06-25 Thread Jan Pruner
Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Jan Pruner
and regards, Santosh -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City

Re: RTFM/ SUPPORT, etc WASRe: Index Constraint

2002-06-25 Thread Jan Pruner
://fifaworldcup.yahoo.com -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City

Re: RE: Difference Between DBMS/RDBMS

2002-06-25 Thread Jan Pruner
] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: AW: off topic: anyone form Amsterdam, Holland / other major europ

2002-06-11 Thread Jan Pruner
(like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network

Re: AW: off topic: anyone form Amsterdam, Holland / other major e

2002-06-11 Thread Jan Pruner
Yes, it is still the case. You still can get relatively easy an IT job in Germany. I get my job in Switzerland in 97 through personal contact, but worked as reine oekonomische Director. So I don't know how is IT market there. Sorry. Jan Pruner On Tuesday 11 June 2002 19:13, you wrote: I'd

Re: Case tool

2002-06-07 Thread Jan Pruner
: http://www.casestudio.com/enu/default.html ? Your opinion, please? Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Re: How do YOU use Java in the DB?

2002-06-07 Thread Jan Pruner
ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

Re: Case tool

2002-06-07 Thread Jan Pruner
opinion, please? Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: Newline char in oracle files

2002-06-07 Thread Jan Pruner
until the England/Argentina match is over :-) TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Re: Textfile into oracle

2002-06-06 Thread Jan Pruner
. Is it possible to import a file like that into oracle table, Please help me with some hints. (See attached file: try.xls) Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services

Re: NLS_NUMERIC_CHARACTERS

2002-06-06 Thread Jan Pruner
to convert this to a number format 34566.45 using to_number function without replacing ',' with '.' using replace function. I dont want to use alter session. Thanks Manoj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City

Re: updated rows count

2002-05-30 Thread Jan Pruner
='0296'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: updated rows count

2002-05-30 Thread Jan Pruner
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re:Numeric comparison in DECODE statement

2002-05-20 Thread Jan Pruner
] || ))) */ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: SQLPlus was Oracle - can you imagine ;-)

2002-05-17 Thread Jan Pruner
SQLPLUS related issues can you imagine;-) Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL

Re: Telephone Alerts

2002-05-13 Thread Jan Pruner
. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Oracle Presentation for Beginners!

2002-05-09 Thread Jan Pruner
for other information (like subscribing). __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City

Fwd: Re: DB Size

2002-05-04 Thread Jan Pruner
: How big is (what is the size of your) Database ? Thaking you, --- CSW --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

Re: DB Size

2002-05-03 Thread Jan Pruner
: How big is (what is the size of your) Database ? Thaking you, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: Oracle - Access

2002-05-03 Thread Jan Pruner
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: stored procedure status

2002-05-01 Thread Jan Pruner
( err_code, 'Hello World'); IF (err_code=0) THEN RETURN; END IF; ... END; Jan Pruner On Wed 1. May 2002 09:43, you wrote: Hi list, I have writeen a stored procedure to execute a set of stored procedures. I want to know is there any way to stop the procedure after any of stoed procedure

Re: VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!

2002-04-30 Thread Jan Pruner
Computers, PO Box 26259, Manama, Bahrain. Ph. 973-700777 Fax.973-701211 Email. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!

2002-04-30 Thread Jan Pruner
Box 26259, Manama, Bahrain. Ph. 973-700777 Fax.973-701211 Email. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re:

2002-04-30 Thread Jan Pruner
? But he surely want to do it now, not in 15 years. :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: VIRUS!!! VIRUS!!! VIRUS!!!!! BE CAREFUL!!!

2002-04-30 Thread Jan Pruner
about Sircam, Klez.K etc. Jan Pruner On Tue 30. April 2002 18:53, you wrote: JP and list, My mail server detected a virus in the original message and deleted it. JP is your response to a valid message that you read? Ron ROR mô¿ôm [EMAIL PROTECTED] 04/30/02 08:43AM Use non-Windoze

Re: what is wrong with this export?

2002-04-30 Thread Jan Pruner
://www.orafaq.com -- Author: Jan Pruner 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

Re: export tables from sql Server to Oracle

2002-04-30 Thread Jan Pruner
__ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: Storing formated data in oracle table

2002-04-29 Thread Jan Pruner
to health and wellness -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Cronjob

2002-04-25 Thread Jan Pruner
this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET

Re: What is Oracle made from ?

2002-04-17 Thread Jan Pruner
written in C ? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: MySQL vs. Oracle database

2002-04-17 Thread Jan Pruner
religious wars?;-) MySQL versus Oracle? Hmm, put server off during import and you will see what is the different. :-))) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Re: Get the Latest Date

2002-04-12 Thread Jan Pruner
the latest date, rather than checking for the latest date in the client logic. Is there any function in Oracle which would return the latest date ? Thank You, Gavin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat

Re: subtract minute from date/time

2002-04-11 Thread Jan Pruner
select to_number(to_char(sysdate, 'MI')) from dual; JP On Thu 11. April 2002 13:08, you wrote: I want to subtract a minute from a date/time How can I do this? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City

  1   2   3   >