oracle

cx_Oracle - How do I access Oracle from Python?

How do I get started? ...

cx_Oracle - what is the best way to iterate over a result set?

There are several ways, what is the best one? ...

SQL Case Statement Syntax?

What is the full correct syntax for the SQL Case statement? ...

How do I find the high water mark (for sessions) on Oracle 9i

How can I find the high water mark (the historical maximum number of concurrent users) in an oracle database (9i). ...

What is a good way to open large files across a WAN?

I have an application deployed into multiple zones and there are some issues with opening larger documents (20-50MB) across the WAN. Currently the documents are stored in Zone 1 (Americas) and a link stored in the database to the docs. I have heard some things about blobs in oracle and store binary in sql server 2005. And then per...

Oracle - What TNS Names file am I using?

Sometimes I get Oracle connection problems because I can't figure out which tnsnames.ora file my database client is using. What's the best way to figure this out? ++happy for various platform solutions. ...

How big would such a database be?

I'm trying to figure out how big a certain database would be (it hasn't been created yet). I know how many rows and what the tables will be. Is there a feature in Oracle that will tell me the size of such a theoretical database? Is there a known math formula I can use? I know there is a feature to determine the size of an existing databa...

Oracle SQL Developer not responsive when trying to view tables (or suggest an Oracle Mac client)

I just get the beach ball all day long (it's been doing nothing for hours). It's not taking CPU, not reading from disk, not using the network. I'm using Java 1.6 on Mac OS X 10.5.4. It worked once, now even restarts of the computer won't help. Activity Monitor says it's "(Not Responding)". Only thing that I can do is kill -9 that sucker...

How to make Pro*C cope with #warning directives?

When I try to precompile a *.pc file that contains a #warning directive I recieve the following error: PCC-S-02014, Encountered the symbol "warning" when expecting one of the followin g: (bla bla bla). Can I somehow convince Pro*C to ignore the thing if it doesn't know what to do with it? I can't remove the #warning directive as it's u...

SQL/Query tools?

I haven't really done a ton of database work in a few years and have become unaccustomed with the tools available. Back a few years ago I was working with oracle databases and was using primarily TOAD with a little bit of MS Access as my tools of choice to prototype the queries I was using in my applications. I really loved TOAD in tha...

What is the difference between oracle's 'yy' and 'rr' date mask?

Example: select ename from emp where hiredate = todate('01/05/81','dd/mm/yy') and select ename from emp where hiredate = todate('01/05/81','dd/mm/rr') return different results ...

What Content Management does your workplace use?

I noticed a lack of Content Management tags all up in the pool. So here is a quick and dirty survey to get things started. 1) What UCM solution is your company using? 2) How big is your company? 3) Are you happy with the implementation? ME: 1) The company I work for uses Oracle ECM (formerly Stellent UCM). 2) We have somewhere over 1...

Best way to encapsulate complex Oracle PL/SQL cursor logic as a view?

I've written PL/SQL code to denormalize a table into a much-easer-to-query form. The code uses a temporary table to do some of its work, merging some rows from the original table together. The logic is written as a pipelined table function, following the pattern from the linked article. The table function uses a PRAGMA AUTONOMOUS_TRANSA...

Automate Syncing Oracle Tables With MySQL Tables

The university I work at uses Oracle for the database system. We currently have programs we run at night to download what we need into some local Access tables for our testing needs. Access is getting to small for this now and we need something bigger. Also, the nightly jobs require constant maintance to keep working (because of network ...

What strategies have you employed to improve web application performance?

Any personal experience in overcoming web application performance hurdles? Any recommended strategies for improving the performance of a data-driven web application? My development team works on a web application (JSP reports, HTML, JavaScript) that uses an Oracle database (PL/SQL). The key functionality the application delivers is ...

Resources for an Oracle beginner

Can anyone recommend some good resources that highlight the differences between Oracle and the AS/400 database? I am trying to help someone with a lot of AS/400 experience implement an Oracle installation, and they need some guidance. A book or online resource would be ideal. ...

Develop on local Oracle instance

I want our team to develop against local instances of an Oracle database. With MS SQL, I can use SQL Express Edition. What are my options? ...

MS SQL Server 2008 "linked server" to Oracle : schema not showing

I have a Windows 2008 Server (x64) running Microsoft SQL 2008 (x64) and I'm creating a Linked Server connection to an Oracle server. I'm able to make the connection, but I cannot see any information regarding which schema a table belongs to. In SQL 2005, my linked servers show the schema information as I would expect. Does anyone know...

Oracle write to file

I am running oracle and have a query which pulls some results from the database. I would like to write the results as a text file. How would I go about doing this? My prefered way would be by using UTL_FILE. Would some one have an example of how to do this? ...

When do you use table clusters?

How do you determine when to use table clusters? There are two types, index and hash, to use for different cases. In your experience, have the introduction and use of table clusters paid off? If none of your tables are set up this way, modifying them to use table clusters would add to the complexity of the set up. But would the expected...