Question

How to resolve error ORA-01861: literal does not match format string during insertion of JSON data in Oracle table?

score 156 · Answer 1 · 2023-12-20T12:57:57.360000

156

Views

How to resolve error ORA-01861: literal does not match format string during insertion of JSON data in Oracle table?

Published on 20 December 2023 at 12:57

score 118 · Answer 2 · 2023-10-30T21:53:22.773000

118

Views

Reference a user-defined type in a db<>fiddle session (when inserting a row)

Published on 30 October 2023 at 21:53

score 176 · Answer 3 · 2023-06-21T12:18:41.097000

176

Views

In Oracle 18c, why is max() much less efficient than order by with fetch first 1 rows only?

Published on 21 June 2023 at 12:18

score 43 · Answer 4 · 2023-05-09T16:50:07.363000

43

Views

Interpreting Combined Address Fields using known list of correct data - Efficiency Question

Published on 09 May 2023 at 16:50

score 182 · Answer 5 · 2023-04-17T12:40:39.110000

182

Views

How to add a months to a timestamp with time zone value while keeping the exact same hour

Published on 17 April 2023 at 12:40

score 81 · Answer 6 · 2023-04-15T20:43:16.443000

81

Views

Fill in rows per group for pivoting

Published on 15 April 2023 at 20:43

score 89 · Answer 7 · 2023-04-15T08:34:21.517000

89

Views

Assign GROUP_ID to rows based on start/end tags

Published on 15 April 2023 at 08:34

score 258 · Answer 8 · 2023-03-28T00:55:37.917000

258

Views

Use ROW_NUMBER() window function without specifying ORDER BY

Published on 28 March 2023 at 00:55

score 78 · Answer 9 · 2023-01-23T22:09:34.643000

78

Views

Oracle: Generate rows for missing years within range (sysyear + 9)

Published on 23 January 2023 at 22:09

score 123 · Answer 10 · 2023-01-21T06:51:47.670000

123

Views

How to get future and past dates in mm/dd/yyyy and dd/mm/yyyy format in Oracle SQL 18C?

Published on 21 January 2023 at 06:51

score 31 · Answer 11 · 2022-11-20T13:54:22.800000

Create a trigger that connects the class teacher and its department to the sub teacher and its department and if they dont match raise an error,

score 79 · Answer 12 · 2022-10-18T16:11:04.273000

79

Views

Select duplicates (including near-duplicate numbers)

Published on 18 October 2022 at 16:11

score 283 · Answer 13 · 2022-10-17T21:41:41.130000

283

Views

Get data from nested tables

Published on 17 October 2022 at 21:41

score 614 · Answer 14 · 2022-10-10T08:53:29.213000

614

Views

https request in Oracle 18c : "ORA-29024: Certificate validation failure"

Published on 10 October 2022 at 08:53

score 2k · Answer 15 · 2022-10-05T10:58:25.887000

2k

Views

Using CREATE SCHEMA AUTHORIZATION

Published on 05 October 2022 at 10:58

score 35 · Answer 16 · 2022-09-08T10:14:56.983000

35

Views

oracle SQL counter restarts when time difference is > x

Published on 08 September 2022 at 10:14

score 90 · Answer 17 · 2022-09-08T06:30:56.293000

90

Views

How to group by date and not datetime in Oracle?

Published on 08 September 2022 at 06:30

score 130 · Answer 18 · 2022-08-17T18:42:44.173000

130

Views

Select rows where related rows only have unmatched years

Published on 17 August 2022 at 18:42

score 341 · Answer 19 · 2022-07-19T03:54:23.893000

341

Views

Generate rows to fill in gaps between years, carry over value from previous year

Published on 19 July 2022 at 03:54

score 107 · Answer 20 · 2022-07-18T07:05:25.677000

107

Views

How to select maximum records from timestamp and do the operation using LISTAGG

Published on 18 July 2022 at 07:05

List Question

How to resolve error ORA-01861: literal does not match format string during insertion of JSON data in Oracle table?

Reference a user-defined type in a db<>fiddle session (when inserting a row)

In Oracle 18c, why is max() much less efficient than order by with fetch first 1 rows only?

Interpreting Combined Address Fields using known list of correct data - Efficiency Question

How to add a months to a timestamp with time zone value while keeping the exact same hour

Fill in rows per group for pivoting

Assign GROUP_ID to rows based on start/end tags

Use ROW_NUMBER() window function without specifying ORDER BY

Oracle: Generate rows for missing years within range (sysyear + 9)

How to get future and past dates in mm/dd/yyyy and dd/mm/yyyy format in Oracle SQL 18C?

Create a trigger that connects the class teacher and its department to the sub teacher and its department and if they dont match raise an error,

Select duplicates (including near-duplicate numbers)

Get data from nested tables

https request in Oracle 18c : "ORA-29024: Certificate validation failure"

Using CREATE SCHEMA AUTHORIZATION

oracle SQL counter restarts when time difference is > x

How to group by date and not datetime in Oracle?

Select rows where related rows only have unmatched years

Generate rows to fill in gaps between years, carry over value from previous year

How to select maximum records from timestamp and do the operation using LISTAGG

Trending Questions

Popular # Hahtags

Popular Questions