|
|
 |
|
|
Thread Tools | Display Modes |
Oct 19th, 2007, 11:39 PM
|
#1 |
|
Troll
Join Date: Apr 2005
Location: Texas
Posts: 732
Rep Power: 4
 |
Storing an ordered list in Oracle
Surely there is some kind of built in feature for maintaining the order of a set of items?
Here's what I don't want, but I have a feeling I'll end up having to do anyway. 1. Linked list. Too much logic to replicate in any app using the database. Even just displaying the items in order would require processing of the query results. 2. Numeric indexes. Items will frequently be inserted, not just added. Displaying or paginating the sequence could be done with one query and no special processing. Shifting items down for an insert could be done with one extra query. This is actually potentially better than 1, though. Seems like I'm having to reinvent the wheel here, so surely I'm missing something.
__________________
MD5(sig) = bcef75433db02e9ad9bf81d6f7c5c270 |
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| linked list problems | bl00dninja | C++ | 6 | Feb 17th, 2008 10:30 AM |
| singly-linked list templaste class in C++ w/ example driver | bl00dninja | Show Off Your Open Source Projects | 0 | Sep 11th, 2006 1:05 AM |
| Singly Linked List Help | Firebar | Java | 3 | May 22nd, 2005 10:56 AM |
| User-defined creatNode and deleteNode functions for a doubly-linked list | jgs | C | 2 | Apr 28th, 2005 8:53 AM |
| airport Log program using 3D linked List : problem reading from file | gemini_shooter | C++ | 0 | Mar 2nd, 2005 4:12 PM |
Linear Mode
