TechQA.

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

0

Answer

156

Views

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

156 views Asked by radha At 20 December 2023 at 12:57

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

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

118 views Asked by User1974 At 30 October 2023 at 21:53

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

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

176 views Asked by Michel Jung At 21 June 2023 at 12:18

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

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

43 views Asked by KXross At 09 May 2023 at 16:50

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

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

182 views Asked by D. Mika At 17 April 2023 at 12:40

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

Fill in rows per group for pivoting

81 views Asked by User1974 At 15 April 2023 at 20:43

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

Assign GROUP_ID to rows based on start/end tags

89 views Asked by User1974 At 15 April 2023 at 08:34

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

Use ROW_NUMBER() window function without specifying ORDER BY

258 views Asked by User1974 At 28 March 2023 at 00:55

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

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

78 views Asked by User1974 At 23 January 2023 at 22:09

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

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

123 views Asked by adityarajsahoo At 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,

31 views Asked by Mary Murphy At 20 November 2022 at 13:54

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

Select duplicates (including near-duplicate numbers)

79 views Asked by User1974 At 18 October 2022 at 16:11

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

Get data from nested tables

283 views Asked by Martín At 17 October 2022 at 21:41

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

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

614 views Asked by elongez At 10 October 2022 at 08:53

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

Using CREATE SCHEMA AUTHORIZATION

2k views Asked by Андрей Марченко At 05 October 2022 at 10:58

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

oracle SQL counter restarts when time difference is > x

35 views Asked by Jdbfkfo At 08 September 2022 at 10:14

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

How to group by date and not datetime in Oracle?

90 views Asked by coredev At 08 September 2022 at 06:30

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

Select rows where related rows only have unmatched years

130 views Asked by User1974 At 17 August 2022 at 18:42

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

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

341 views Asked by User1974 At 19 July 2022 at 03:54

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

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

107 views Asked by Vicky At 18 July 2022 at 07:05

TechQA.

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

Popular Questions

Trending Questions