I love these external tables.  It really gets rid of the old
UTL_FILE.GET_LINE.
Anyhow, is there a way to create an external table where the filename
is dynamic?  Basically the filename changes a couple of times during

We do not have experience in Oracle so if this question is posted in
the wrong area, please respond with the best location for this post...
We are looking for a query that we can run against each of our Oracle
servers that will show each database name, instance name, and all the

Hello everybody, i need your help. I got a oracle procedure that gives
an parameter cursor. I want to use the resultset on c#. Below my code
is written. When i want to call procedure from c#, i'm confused to
send parameter. Wichc typed parameter is sent from c# or how to solve

 I have a question on how composite index should be used. As an
example, my queries often select two leading columns, column_1 and
column_2 of a table. Should I create a composite index using column_1
and column_2,  or should I create two separated indexes for column_1

at least since Oracle 10.2.0 the Oracle Linux distribution contains an ODBC
driver which works with unixODBC. After installation of the Oracle Enterprise
Edition, the driver can be found at
$ORACLE_HOME/lib/libsqora.so.10.1

I was working as a trainer(contractor) for Oracle University Turkey
and for their education partners. One of their partners tried to force
me about a training that OUT(Oracle University Turkey) will not know
anything about the education(with photocopy books).

i am posting a sample of a result i am getting from the following
formula
------------------------------------------------------------------------------------------------------
select (to_char(salinv_1.inv_date, 'MM'))as "MM",

I am not trying to start a topic on windows versus unix/linux/solaris
for running oracle.
I can see that oracle certifies 11g on enterprise/business/ultimate
only so no I am not asking about if it is certified.

hi all, i have a sales table that i want to get the balance for some
specific condition products,
i am getting the wrong balance since i lack the knowledge of how to do
a recursive formula, you may know that the balance of FEB for instance

This is driving me crazy!
Ok, I have an external table that is tab delimited.  I am not
interested in all of the fields, jsut a few of them.  My table
definition is below.  But, it is not working!  Here is my definition

Please let me know if you have any resources with you for this
opportunity?
***Mail resume and contact details to sachi@ciits.com
***Mail resume and contact details to sachi@ciits.com

Let me present you with some of list of consultants
Name    Primary Skills    Total/US Exp
Manas Dey
Oracle Apps Distribution, Supply Chain Planning & Manufacturing R11i

A friend installed Oracle 9i at home.  After installation, he could not
locate Application Express; which I believe used to be called HTML/DB.
Any idea where it is located?  Sorry for being vague, but this is all I know

This is driving me crazy!
Ok, I have an external table that is tab delimited.  I am not
interested in all of the fields, jsut a few of them.  My table
definition is below.  But, it is not working!  Here is my definition

We went across the following problem on our 10.1.0.3 Oracle database
on windows 2003.
Problem :
After multiple updates on an index organized table with a function