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'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 -
What DBA certification should I pursue? MS, Oracle, something else? [more inside]
posted by davar
on Jan 15, 2008 -
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 -
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 -