Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help! Sorting->Updating Table

Help! Sorting->Updating Table

From: <sjoshi_at_ingr.com>
Date: Wed, 23 Feb 2000 20:01:13 GMT
Message-ID: <891ea5$aqn$1@nnrp1.deja.com>


Hello
 I have this problem. I have a table (spec_list) with (character) field spec_type. Now the data in the table is unsorted and I want to sort the data with any specType I add to come first when I do a select * from speec_list.
 I'm wondering how I can do this regulary, since there is not date field in the table and I always want it to show newly added fields first. Is there a way to sort/update the table ??

thanks
Sunit

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 23 2000 - 14:01:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US