Question

How can I sort a table by a column for numeric letter first, then case sensitive for alphabet letters

score 163 · Answer 1 · 2014-12-03 07:54:48

163

Views

How can I sort a table by a column for numeric letter first, then case sensitive for alphabet letters

Published on 03 December 2014 at 07:54

score 1.2k · Answer 2 · 2014-12-22 23:44:17

1.2k

Views

Making Oracle sorting case-insensitive?

Published on 22 December 2014 at 23:44

score 66 · Answer 3 · 2023-12-14 09:24:00

66

Views

MIN/MAX aggregate function with STRING in ORACLE

Published on 14 December 2023 at 09:24

score 269 · Answer 4 · 2018-11-12 20:14:21

269

Views

Character order of NLS_SORT WEST_EUROPEAN

Published on 12 November 2018 at 20:14

score 428 · Answer 5 · 2020-09-20 20:16:36

428

Views

weird behavior of regexp functions in oracle 19c

Published on 20 September 2020 at 20:16

score 90 · Answer 6 · 2014-07-23 11:29:38

90

Views

When i change NLS ora gives "ORA-00979: not a GROUP BY expression" error

Published on 23 July 2014 at 11:29

score 349 · Answer 7 · 2017-07-20 11:25:26

349

Views

Why lowercase 'i' mapped to '?' after doing NLS_UPPER

Published on 20 July 2017 at 11:25

score 125 · Answer 8 · 2023-07-10 09:20:49

125

Views

Alter session "on calling" a query via Oracle DB-Link

Published on 10 July 2023 at 09:20

score 2.4k · Answer 9 · 2020-05-12 14:33:09

2.4k

Views

Oracle nls_sort equivalent in postgres

Published on 12 May 2020 at 14:33

score 213 · Answer 10 · 2014-02-05 11:51:17

213

Views

oracle sorting with text as number

Published on 05 February 2014 at 11:51

score 1.6k · Answer 11 · 2009-08-13 12:50:50

1.6k

Views

Oracle's puzzling behaviour with NLS_SORT and a simple REGEXP_LIKE()

Published on 13 August 2009 at 12:50

score 677 · Answer 12 · 2015-07-29 06:23:57

677

Views

Oracle Db 11.2 NLS_SORT Index Range Scan Performance

Published on 29 July 2015 at 06:23

score 515 · Answer 13 · 2014-03-30 15:10:23

515

Views

Oracle dynamic NLS_SORT with openjpa

Published on 30 March 2014 at 15:10

score 237 · Answer 14 · 2018-08-22 13:37:51

237

Views

Ignore trailing whitespaces in comparisons using collation in Oracle 12c

Published on 22 August 2018 at 13:37

score 2.4k · Answer 15 · 2015-02-06 10:41:32

2.4k

Views

Change NLS_SORT for a single query

Published on 06 February 2015 at 10:41

score 176 · Answer 16 · 2021-07-29 07:58:00

176

Views

regexp_replace() - maybe collation issue

Published on 29 July 2021 at 07:58

score 144 · Answer 17 · 2016-03-16 10:03:00

144

Views

Linguistic Sorting and String Searching is fetching incorrect data in oracle

Published on 16 March 2016 at 10:03

score 149 · Answer 18 · 2014-10-24 14:52:29

149

Views

Linq to Sql NLSSORT

Published on 24 October 2014 at 14:52

score 160 · Answer 19 · 2017-05-10 12:46:56

160

Views

non-visible character in modified column

Published on 10 May 2017 at 12:46

score 305 · Answer 20 · 2020-11-10 14:21:53

305

Views

NLSSORT Oracle to Snowflake

Published on 10 November 2020 at 14:21

List Question

How can I sort a table by a column for numeric letter first, then case sensitive for alphabet letters

Making Oracle sorting case-insensitive?

MIN/MAX aggregate function with STRING in ORACLE

Character order of NLS_SORT WEST_EUROPEAN

weird behavior of regexp functions in oracle 19c

When i change NLS ora gives "ORA-00979: not a GROUP BY expression" error

Why lowercase 'i' mapped to '?' after doing NLS_UPPER

Alter session "on calling" a query via Oracle DB-Link

Oracle nls_sort equivalent in postgres

oracle sorting with text as number

Oracle's puzzling behaviour with NLS_SORT and a simple REGEXP_LIKE()

Oracle Db 11.2 NLS_SORT Index Range Scan Performance

Oracle dynamic NLS_SORT with openjpa

Ignore trailing whitespaces in comparisons using collation in Oracle 12c

Change NLS_SORT for a single query

regexp_replace() - maybe collation issue

Linguistic Sorting and String Searching is fetching incorrect data in oracle

Linq to Sql NLSSORT

non-visible character in modified column

NLSSORT Oracle to Snowflake

Trending Questions

Popular # Hahtags

Popular Questions