Re: PL/SQL Editor

Gotta love that.

joe

Mercadante, Thomas F wrote:

>Bill,
>
>You said "One note about the Freeware version of TOAD - it has some internal
>thing
>that limits it to 5 concurrent connections to the same db, which is a
>problem for us in a dev shop."
>
>
>I got around this by replacing the v$session view with the following:
>Note the "REPLACE" statement in the select for the PROGRAM and MODULE
>columns:
>
>
>CREATE OR REPLACE VIEW V$SESSION ( SADDR,
>SID, SERIAL#, AUDSID, PADDR,
>USER#, USERNAME, COMMAND, OWNERID,
>TADDR, LOCKWAIT, STATUS, SERVER,
>SCHEMA#, SCHEMANAME, OSUSER, PROCESS,
>MACHINE, TERMINAL, PROGRAM, TYPE,
>SQL_ADDRESS, SQL_HASH_VALUE, PREV_SQL_ADDR, PREV_HASH_VALUE,
>MODULE, MODULE_HASH, ACTION, ACTION_HASH,
>CLIENT_INFO, FIXED_TABLE_SEQUENCE, ROW_WAIT_OBJ#, ROW_WAIT_FILE#,
>ROW_WAIT_BLOCK#, ROW_WAIT_ROW#, LOGON_TIME, LAST_CALL_ET,
>PDML_ENABLED, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER,
>RESOURCE_CONSUMER_GROUP, PDML_STATUS, PDDL_STATUS, PQ_STATUS
> ) AS SELECT
> SADDR
>, SID
>, SERIAL#
> ,AUDSID
> ,PADDR
> ,USER#
> ,USERNAME
> ,COMMAND
> ,OWNERID
> ,TADDR
> ,LOCKWAIT
> ,STATUS
> ,SERVER
> ,SCHEMA#
> ,SCHEMANAME
> ,OSUSER
> ,PROCESS
> ,MACHINE
> ,TERMINAL
> ,REPLACE(UPPER(PROGRAM),'TOAD','FROG') PROGRAM
> ,TYPE
> ,SQL_ADDRESS
> ,SQL_HASH_VALUE
> ,PREV_SQL_ADDR
> ,PREV_HASH_VALUE
> ,REPLACE(UPPER(MODULE),'T·O·A·D·','F~R~O~G') MODULE
> ,MODULE_HASH
> ,ACTION
> ,ACTION_HASH
> ,CLIENT_INFO
> ,FIXED_TABLE_SEQUENCE
> ,ROW_WAIT_OBJ#
> ,ROW_WAIT_FILE#
> ,ROW_WAIT_BLOCK#
> ,ROW_WAIT_ROW#
> ,LOGON_TIME
> ,LAST_CALL_ET
> ,PDML_ENABLED
> ,FAILOVER_TYPE
> ,FAILOVER_METHOD
> ,FAILED_OVER
> ,RESOURCE_CONSUMER_GROUP
> ,PDML_STATUS
> ,PDDL_STATUS
> ,PQ_STATUS FROM sys.V_$SESSION
>
>
>
>
>-bill
>
>-----Original Message-----
>Sent: Wednesday, August 28, 2002 8:18 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>PL/SQL Developer.
>
>http://www.allroundautomations.nl/plsqldev.html
>
>very very good.
>
>
>-----Mensaje original-----
>De: root_at_fatcity.com [mailto:root_at_fatcity.com]En nombre de Ofer Harel
>Enviado el: miércoles, 28 de agosto de 2002 9:13
>Para: Multiple recipients of list ORACLE-L
>Asunto: RE: PL/SQL Editor
>
>
>Try free Toad at http://www.toadsoft.com/downld.html
>
>regards
>
>Ofer Harel
>DBA team
>Barak ITC
>oharel_at_barak013.net.il
>
>
>
>-----Original Message-----
>[mailto:cosltemp-g.manoj_at_orbitech.co.in]
>Sent: Wednesday, August 28, 2002 8:33 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Hi All,
> which is the best PL/SQL editor available as a trial version .
> the editor should support Oracle sql,PL/SQL and may or may not
>support debugging.
> The tool should be support Win 9X OS and provide best
>performance .
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: jtesta_at_dmc-it.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).