My boss wants me to find out how to convert our server room full of Oracle / Sun Solaris machines, into vmware Guest Machine instances running Red Hat Enterprise Linux. [more inside]
posted by shipbreaker
on Jun 11, 2014 -
Is there a term for a seer/diviner/oracle that is only able to see into the past? I'm willing to grab one from a non-English language if there is a word that means specifically "a seer who can only see the past", but English is prefered. Antiquated terms are OK. Bonus points for interesting etymological details (or links to interesting etymological details). [more inside]
posted by NoraReed
on Jul 16, 2013 -
I feel like the best way for me to improve my very basic understanding of PL/SQL would be a book or website designed for an audience of programmers who know Java or C# or VB.NET. Is there such a thing? [more inside]
posted by kitcat
on May 16, 2013 -
My SO has a degree in IT and Computing but he has not been working for 2.5 years (combination of travel, language studying, and personal things). He has recently started job hunting but feels he is lacking in the certification department. Most jobs near us seem to want Oracle certification. Is it worth doing an Oracle course? Or is there something else (perhaps something up-and-coming) that he should look into? With a gap on his CV he is worried he is unemployable. [more inside]
posted by Small Pockets
on Mar 14, 2013 -
I have a Mac with OSX Mountain Lion. My university uses Oracle Calendar 9.0.4. In the past, I have set up syncing to my iCloud calendar using my iPad with SyncML pro, so I know I can do this, in principle. What I'd like to do is find a way of syncing to my iCloud calendar without
an iOS device - preferably an OSX application. Why is this so hard to figure out how to do? [more inside]
posted by Philosopher Dirtbike
on Feb 18, 2013 -
What IT/programming/technology type conferences should I try to go to this year (June 2012 - June 2013)? I have to come up with a list of 3 by Thursday for my manager! [more inside]
posted by The Supreme Dominar
on Apr 10, 2012 -
I'm a bit of a SQL novice but learning at a decent clip. I'm using SQL (Aqua Data Studio, if that matters to you) to update a couple of fields in an Oracle database table. I'd like to do this across a range of one of the fields. One field is a numeric field (trans_id - a transaction id) that I need to increase by 1 -- I think have that part licked. The next field is alphanumeric (calendar_name - represents the name of a week) and also needs to be incremented by one. The doozy (for me) is the alphanumeric field. Who's the guru? [more inside]
posted by brokeaspoke
on Feb 4, 2012 -
I have a wonderful (Oracle) SQL database and I use Navicat Lite to crunch around in it. My problem is that I'm staring at lists of 50+ tables, 60+ saved queries, 10+ views, etc. Is there anything I can do to somehow organise things in a visually pleasing and/or functional way? [more inside]
posted by iamkimiam
on Feb 2, 2012 -
Hey all. I need to learn the basic principles of SQL and Oracle databases. I'm looking for web resources and books. Got any favorites? What's out there?
Thanks in advance.
posted by Stagger Lee
on Dec 5, 2011 -
I'd like to perform an SQL query with outer joins, from text files on my PC, using only a unix emulator. Is this possible on my PC? How would I write and execute it? [more inside]
posted by RobinFiveWords
on Sep 13, 2011 -
If someone was offered a sales position to work for either Oracle or Dell, which would you recommend and why? [more inside]
posted by gttommy
on Jun 30, 2011 -
What's the best way to write this SQL job? I have a table with browser session information collected. I want to clear this table and store the information in another table. [more inside]
posted by zephyr_words
on May 31, 2011 -
I'm using Navicat Lite to connect to my Oracle research database (Mac OSX). Much of my data is in IPA (International Phonetic Alphabet). These are unicode symbols. Is there a way to display the IPA/Unicode in Navicat? Or some other GUI? Or is there some addon/code/plugin/whatever that will show me the symbols? [more inside]
posted by iamkimiam
on Mar 8, 2011 -
Databases: I've got a problem with Oracle and ERWin when using multi-column constraints. Please help. [more inside]
posted by NortonDC
on Dec 9, 2010 -
Why do the specs of some non-x86 processors seem so much better than those of the latest Intel chips, even though Intel's manufacturing is more cutting-edge? [more inside]
posted by Xezlec
on Dec 7, 2010 -
Ages ago on the webs, there was a forum which purported to be AI, but which wasn't. It consisted of many philosophers, answering questions. Where is it? Is there an Archive? [more inside]
posted by tomierna
on Jun 1, 2010 -
Oracle / Storage geeks: What are the alternatives to exadata for high-performance I/O with a rac system? [more inside]
posted by H. Roark
on Nov 26, 2009 -
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 -
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 -
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 -
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 -
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 -
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 -
I have a month to cram for a vendor certification.... any vendor certification. Which one should I go after?
posted by Slap*Happy
on Mar 4, 2008 -
What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted by davar
on Jan 15, 2008 -
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 -
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 -
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 -
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 -
Can a person experienced in Oracle Forms 10 easily move to Oracle EBusiness Suite? [more inside]
posted by pivotal
on Mar 11, 2007 -
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 -
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 -
This switcher is looking for OS X equivalents of two can't-live-without Windows apps.
posted by neilkod
on May 13, 2005 -
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 -
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 -