I'm pleased to announce the initial release of OraPIG,
the Oracle Python Interface Generator.
OraPIG generates Python wrapper classes for Oracle packages.
If you use Oracle and Python, this might be a pretty useful

Is there any way to make an Oracle-server enforce ANSI-compliant SQL?
I.e. to make it only accept ANSI-compliant SQL-statements, and raise
an error on anything that is not.
TIA,

How to do the following with Oracle 9:
1. allocate array of VARCHAR
2. allocate array of related index variables
3. call stored procedure from C++ and pass parameters from step 1 and

We have these expressions in our queries:  A + B / C .......
What they want is if any of the numbers are -99999 they should be
converted to a 0.  If they are all -99999 then the result of the
entire expression should be -99999.

Please forward your profiles at versatilehr.farook@gmail.com.
Location: Boston, MA.
Duration: 6+ Months
Rate: $40.00ph

Hi..i have this trouble ....
i have table A wich this data
cod_group           bill_type
  GROUPA          BILLTYPE1

WinDBPro. Ver 2.5
Works with any Windows Version
Complete DB one exe file only
One file : (120KB)

I think I answered the question with the title of this post, but it
leaves me wondering why Oracles upgrade assistant only works if the
database you are upgrading from is on the same machine. I know MS-SQL is
a different beast, but it does effortless upgrades from one machine to

oracle 10G
I apparently overlooked it in the manuals - so please be patient ...
How can I test if a record is empty?
I expected it to work like this:

When you have a loop and use the "EXIT WHEN" clause, can you use it
more than once?  What if you have multiple places in the code where
you might want to exit?
 LOOP

one of our customers has created an external view (view on external
base tables in a different schema / database type). we do a DESC on a
table or view to find out what the datatype is for a field using the
oracle account for our application.

My question is a little broad but maybe you already saw something like
this ;-)
Here is my scenario:
Let us have a large table which contains over 20 million records and

Find start and end execution time of a sql statement?
I am have databases with 10.2.0.3 and 9.2.0.8 on HP UNIX  11i and
Windows 200x.
I am not in a position to turn on sql tracing in production

Free Mock tests:
http://www.techfaq360.com/
ORACLE mock test.
Hibernate mock test.

This is a problem on 10gR2 (Windows 2000 server).
We have a table with a CLOB containing HTML documents.
We have created a text inded on it:
create index my_text_index