Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Trivia question - not of any practical use.

Trivia question - not of any practical use.

From: Charu Joshi <joshic_at_mahindrabt.com>
Date: Thu, 24 Oct 2002 08:24:04 -0800
Message-ID: <F001.004F27D2.20021024082404@fatcity.com>


Dear Listers,

Given below is a script that I execute from within SQL*Plus for WinNT:

temp.sql:



set echo off
set pagesize 0
set feedback off
SELECT * FROM tab WHERE ROWNUM < 10;
set pagesize 1000
set feedback on
set echo on

While running it always displays 'SQL>set echo off' before muffling the echo. Is there any way to stop this line from appearing?

I vaguely remember that in some language you could put @ in front of the 'set echo off' command to suppress it. Is there something similar possible.

TIA. Regards,
Charu.

-----Original Message-----
Sent: Thursday, October 24, 2002 12:26 PM To: Multiple recipients of list ORACLE-L

the firewall should use sqlnet proxy. most firewalls support it and if this one doesn't scrap it! only the initial connection is made on port 1521.

>>> adar76_at_inter.net.il 10/24/02 05:44AM >>>
we had the same problem and we found that oracle use the standard port only to make the initial connection. All the traffic after that is done on different ports. So you need to open the range that oracle use in the firewall.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, October 24, 2002 8:13 AM

> Environment:
> Oracle 8.1.6
> AIX server behind a firewall
> db is accessed by a Windows application running on a IIS web server
> sitting outside the firewall
> db uses port 1521
>
>
> After a flurry of email between the Unix admin and the 4 software vendors
> concerned, all the fingers are now pointing at "that damn oracle
> database". The Unix admin is asking two questions:
>
> 1) what Oracle is doing with the four ports 20,000 - 20,003
> 2) can he shut them down?
>
>
> Any ideas are appreciated.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Don
> INET: dondealy_at_teleport.com
>
> 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: ListGuru_at_fatcity.com (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.com
--
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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: ListGuru_at_fatcity.com (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.com
--
Author: Gene Sais
  INET: Gsais_at_co.palm-beach.fl.us

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: ListGuru_at_fatcity.com (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).

*********************************************************
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Charu Joshi
  INET: joshic_at_mahindrabt.com

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: ListGuru_at_fatcity.com (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).
Received on Thu Oct 24 2002 - 11:24:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US