RE: SUPPRESS SQL STATEMENTS

I run the following script, and the -S option solved the problem I had (I even had the line # out in the script and re-invoked it). If the username/pw is on a separate line as shown below, the ps command does not display the userid/pw info. # Set environment variables#!/bin/ksh # Set local

RE: SUPPRESS SQL STATEMENTS

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

SUPPRESS SQL STATEMENTS

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

Sql query : select max timestamp value from table

I have multiple timestamps values for single ip in a table, I need the max(timestamp)for each ip I select out. example: timestamp ip 2003-09-29 13:20:23 68.209.182.42003-09-29 13:20:44 68.209.182.42003-10-02 12:53:38 68.209.182.42003-10-02 12:35:06 68.75.94.1582003-10-02 12:52:03 68.97.33.69 Thus

UNIX : script help/input

Anybody with a quick and dirty (elegant would be nice too), to munge output from a nslookup output file to a delimited file? 'File content: Server: dns1.mci.comAddress: 199.249.19.1 Name: WCOM-4NXZGAPWY5.mcilink.comAddress: 166.50.73.209 Delimited file should have the following line(s); (using |

Re: UNIX : script help/input

Mladen, It worked! Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin).Mladen Gogala [EMAIL PROTECTED] wrote: #!/usr/bin/perl -wuse strict;use bytes;my ($NAME,$IP,@LB);while () {chomp;@LB=split /\s+/;if ($LB[0] =~ /^name:/i) {$NAME=$LB[1];}if ($LB[0] =~

RE: PL/SQL Question:Eliminate duplicate rows

://www.orafaq.net -- Author: Johan Muller 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

PL/SQL Question:Eliminate duplicate rows

: http://www.orafaq.net -- Author: Johan Muller 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

Can contracting rates beat minmum wage soon? (OT)

, direct and contract-to-hire. Requirements: SAP, UNIX, Solaris, Oracle Travel required: none Telecommute: no -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Sql question : use of SUBSTR/INSTR functions

coding skills. I probably have to attack the IP with decode, and any input will be very welcome. Running V 8.1.6. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: oracle-dba.com domain

http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItemitem=2057533249 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark LeithSent: Friday, September 27, 2002 9:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle-dba.com domain anyone

9i QUESTIONS: STANDBY DATABASE IMPLEMENTATION

usual can't remember much (in fact remember zero is a lot closer - just another senior moment I guess). TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

OT: Where are bill rates going?

reply (I have several in mind but would like to remain courteous at this stage). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

SQL : where clause to include data for the previous 24 hours

event_date (to_date(substr(sysdate,0,22),'/MM/DD HH24:MI:SS') + 6/24) - 1. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

UNIX SCRIPT ISSUE - URGENT

position after a string on line 13 which you guessed it: is called 'IP Address:'. Is their a way vi could be used to achieve the same result? Any input would be appreciated, Johan Muller __ Do You Yahoo!? Make international calls for as low as $.04

RE: Data load options

. ** __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller INET