GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQorder by
Hello Tom,
I want to retrieve records from a table T ordered by column X (that is varchar2). There is an B-tree index on T.X.
select t.x from t order by x;
Returns:
A/AITANA
AB/AGRA
...
Z/VILLARROYA|02
Z/VILLARROYA|03
Z/ZARAGOCETA EB...
Sponsored Links
Read Next: Tuning
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
