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 - 11 answers

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 - 4 answers

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 - 12 answers

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 - 16 answers

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 - 7 answers

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 - 2 answers

Help with using Crystal Reports to report on an Oracle database [more inside]
posted by toenail on Feb 15, 2011 - 3 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

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

Can I, should I, make a career change into database design? [more inside]
posted by argybarg on Sep 25, 2007 - 16 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