I'm on Win2K SP4, running 10Gr2.
I have a new database, and a default listener. I wish to create a
second and third listener, listening on different ports.
I initially tried manually placing the entries in the listener.ora file

Anyone here use Python rather than PL/SQL for writing DBA
administrative scripts, etc? Is there a good module out there for
Python that interfaces with Oracle?
I know some PL/SQL from a while ago, but am now learning Python for

Is there a better way of doing the following query?
SELECT TESTASMAKE MAKE, MAX(total_cnt) Total, MAX(pass_cnt) Pass,
TO_CHAR(ROUND(((MAX(pass_cnt)/MAX(total_cnt))*100),3))||'%' Pass_Pct,
MAX(rej_cnt) Rejected,

Hi, this is probably a real simple question... If I can get
a connection to the DBMS via SQL-PLUS, with the tnsnames.ora
entry listing the service name, not the SID, is there a query
I can run to get the SID? I want to make an oracle thin JDBC connection,

this is what i use currently as password that contains special
characters (Oracle 8.1.7) :
alter user toto Identified By "@toto!;"
I would like to insert a " in the password :

hi, all,
   I am testing online redefinition in oracle 9.2, and I found it used
too much rbs segment. While redefine (start_redef_table), for my 2GB
table, it used 1.4GB rollback segment.

I want to be master in writing queries.  Could any one give me the path
where I can get these kind of Q&A ?
Ideally what I am expecting is, the page/link should contain few tables
with sample data.  Then based on the data a query list should be there,

Can someone please explain or point out links to the latch process in
shared pool. What I have understood so far is the steps are as follows:
1. In the process of searching a SQL text,
It will first get data dictionary latch,

I have a table of closing prices and I want to write a query that
returns for each row the  EARLIEST FUTURE date where the closing price
has gone up at least 20% from the current row.
I want to search only future dates in the next month (or next 20 rows

I have a server with AS 10 and 9i database. I have a ton of Linux
package updates and patches to make to the server.  Do I have to shut
down AS and/or the DB before I make the updates?
Thanks,

I'm trying to make a ldap-bind against AD from within Oracle. My problem
here is, I do not have the full DN and can't have a proxy user to do the
search for the full-dn. My question is: Does anyone of you know a
possibility to just do a bind with '<domain>\<username>'?

I'm using VC++ 6.0 with OLE DB to access data in Oracle 9i.
The problem is calling stored procedures in Oracle that returns data.
Oracle stored procedures can't return recordsets (like stored
procedures in SQL Server can), and i cna't get some return recordsets

Anyone have sample VB code that returns set of connection strings
defined in local tnsnames.ora ? thx in advance

Dear Oracle Experts,
I'M searching for a query to find out whether sequences for auto
iteration of primary key columns do exist on a table or not.
Does anyone know how to get that information ?

I was recently looking over someone elses code and noticed that they
were using CLOB's in PLSQL just like varchars, eg:
declare
 v_clob clob;