- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 8.1.7 order by
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 05:45 AM
тАО07-05-2002 05:45 AM
Oracle 8.1.7 order by
Please look this:
SQL>
1 select * from jah
2* order by campo asc
C
-
A
a
Z
z
1
7
9
7 filas seleccionadas.
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 06:04 AM
тАО07-05-2002 06:04 AM
Re: Oracle 8.1.7 order by
select * from test
order by ca asc
--------
1
A
a
select * from test
order by ca desc
------
a
A
1
HTH
Victor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 06:20 AM
тАО07-05-2002 06:20 AM
Re: Oracle 8.1.7 order by
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 06:26 AM
тАО07-05-2002 06:26 AM
Re: Oracle 8.1.7 order by
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-05-2002 06:54 AM
тАО07-05-2002 06:54 AM
Re: Oracle 8.1.7 order by
ALTER SESSION
SET NLS_SORT = XSpanish;
Oracle sorts character values based on their position in the Spanish linguistic sort sequence.
alternatively
ALTER SESSION
SET NLS_SORT = ANSI;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2002 03:01 AM
тАО07-08-2002 03:01 AM
Re: Oracle 8.1.7 order by
Regarding my last reply (July 05, 14:26) about NLS_LANG, Any suggestion about?
Regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО07-08-2002 06:26 AM
тАО07-08-2002 06:26 AM
Re: Oracle 8.1.7 order by
the order is which the data is displayed is determined by NLS_SORT which can be set at the session level or in the initialisation file. For example ...
SQL> alter session set nls_sort = binary;
Session altered.
SQL>
SQL> select ianchar from ian order by ianchar asc;
I
-
0
9
A
B
a
b
6 rows selected.
SQL> alter session set nls_sort = FRENCH;
Session altered.
SQL> select ianchar from ian order by ianchar asc;
I
-
A
a
B
b
0
9
6 rows selected.
SQL>