Join 3,562 readers in helping fund MetaFilter (Hide)

12 posts tagged with sql and oracle. (View popular tags)
Displaying 1 through 12 of 12. Subscribe:

SQL: How do I increment an alphanumeric field by + 1?

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

Is there a way to visually organize database tables (and saved queries and views)?

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

Learning Oracle and SQL

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

How to write an SQL query in unix?

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

Help me write this SQL job

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

[hɛlp mi si junikod ɪn maɪ deɪtəbeɪs, ɔr maɪ dætəbeɪs ivɛn]

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

Crystal Reports

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?

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

Help solve my SQL mystery

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

Best DBA certification?

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

Could I design databases for a living?

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

SELECT * FROM USERS WHERE CLUE > 0

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

Page: 1