Best practices for storing OracleDB/mysql/ldap/smtp/etc... system passwords for enterprise application integration use? [more inside]
posted by bottlebrushtree on Oct 8, 2009 - 9 answers

Currently Microsoft-only, but wanting to change our software soon to support Oracle as well. What are we getting ourselves into? [more inside]
posted by relucent on Jun 5, 2009 - 10 answers

Oracle Views: Are calculated columns always evaluated even when they are not considered in a query? [more inside]
posted by NailsTheCat on Apr 21, 2009 - 7 answers

How can I get the IN function to work in my SQL? [more inside]
posted by urbanwhaleshark on Feb 19, 2009 - 12 answers

Inserting a date into MySQL? Is there a to_date() equivalent to convert a string to a datetime? [more inside]
posted by exhilaration on Feb 5, 2009 - 4 answers

Greek translation filter: I got a t-shirt from Delphi with a Greek phrase embroidered on it a few years ago and I have forgotten what the phrase means. It seems to say "EN OIDA OTI OYDEN OIDA," though the "O's" are diamond shaped on the shirt and the "D's" are rendered more like slightly askew triangles. Any guesses? [more inside]
posted by Curry on Jan 2, 2009 - 5 answers

How do you upgrade the Oracle client in Linux RHEL 4 (64-bit) from 10.2.0.1 to 10.2.0.4? [more inside]
posted by idb on Nov 18, 2008 - 3 answers

My company system has an application that uses Oracle Text for querying large text fields in a natural query language -- I'm a big fan. Oracle Text supports the use of structured thesauri for queries too. This works well but I'm not sure what the best way to implement this is. [more inside]
posted by NailsTheCat on Jun 9, 2008 - 2 answers

Can you help structure my oracle database appropriately? [more inside]
posted by urbanwhaleshark on May 1, 2008 - 10 answers

I have a month to cram for a vendor certification.... any vendor certification. Which one should I go after? [more inside]
posted by Slap*Happy on Mar 4, 2008 - 5 answers

What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted by davar on Jan 15, 2008 - 3 answers

Can a total newbie very quickly teach himself to do (all of the) Billing for a small consulting firm? [more inside]
posted by GeckoDundee on Dec 17, 2007 - 4 answers

There's a Batman panel I have a clear, but possibly flawed memory of.. where is it from?

Likely written well after, but taking place shortly after The Killing Joke, I have a clear image of Barbara Gordon, in the hospital, talking to Batman (or possibly Bruce Wayne), realizing she'll never walk again, never be batgirl again, that this incident has derailed her entire planned existence, and essentially saying something to the effect of "I've heard when the police pulled up, you were standing there laughing with the man who did this to me, and I wanted to know.. were you laughing at me?" Where is this from? It can't just be in my head, can it?
posted by John Kenneth Fisher on Dec 11, 2007 - 2 answers

Can I, should I, make a career change into database design? [more inside]
posted by argybarg on Sep 25, 2007 - 16 answers

Career-wise, is it a smart move to take a mysql position after building up ten years of Oracle experience? [more inside]
posted by anonymous on Sep 18, 2007 - 6 answers

I am currently dealing with an Oracle-based application that on many of the screens returns data in what I call "hysterical order" (seemingly random to the casual observer). In fact, the application applies no ORDER BY logic to the underlying data, which ORACLE returns in an undefined order (actually the order the data was entered). This is useless in practice. I don't have the ability to change the application in any way, but I do have access to the database. I am aware that it is non-standard in relational database theory to be able to specify a default ordering for tables, but in Oracle, are there in practice, any modifications I could make to the underlying tables that will not cause the app to break, but will allow me to specify the default order of the data when there is no ORDER BY used? I can identify a column in each table which should be the default order. It is a long time since I was a DBA, so I am a little rusty on current Oracle practice and capabilities.
posted by blue_wardrobe on May 11, 2007 - 28 answers

Can a person experienced in Oracle Forms 10 easily move to Oracle EBusiness Suite? [more inside]
posted by pivotal on Mar 11, 2007 - 3 answers

What is the wise way for a medium or large businesses to implement ERP software? [more inside]
posted by rongorongo on Oct 30, 2006 - 4 answers

SAP / Oracle, these are the big expensive systems I want to avoid in a new business system. What other options are there for a small to medium sales comapany? [more inside]
posted by Frasermoo on Aug 17, 2006 - 9 answers

Oracle 10g Administrator self-study: this book or this one?
posted by bingo on Jan 6, 2006 - 5 answers

I'm playing (oracle) DBA for a day over the next two weeks and need to create public synonyms for all tables in a schema. How would I go about doing so? [more inside]
posted by furtive on Jul 27, 2005 - 7 answers

This switcher is looking for OS X equivalents of two can't-live-without Windows apps. [more inside]
posted by neilkod on May 13, 2005 - 6 answers

Any resources, online or print, that can give me a good grounding in Oracle databases - admin/design.

Need to gen up for an electronic records management system that my company wants to buy.
posted by the cuban on Dec 14, 2004 - 1 answer

How easy is it to get Movable Type to work with Oracle? I would like to use this at work but it wouldn't be acceptable with a MySQL or Berkeley DB. How difficult would it be? Should I just wait and hope that it's supported with Movable Type version 3?
posted by adoran2 on Apr 28, 2004 - 4 answers