Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Auto-sorting table

AmericaJan 4 2008 — edited Jan 4 2008

I would like to have my table Food always sorted by field FoodName (for example "milk")

that after adding some records:

select * from table
=
select * from table order by field

Are there any ways to do it except trigger + stored procedure?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 1 2008

Added on Jan 4 2008

#general-database-discussions

7 comments

755 views