List Question
20 TechQA 2023-12-20T12:57:57.360000Reference a user-defined type in a db<>fiddle session (when inserting a row)
118 views
Asked by User1974
In Oracle 18c, why is max() much less efficient than order by with fetch first 1 rows only?
176 views
Asked by Michel Jung
Interpreting Combined Address Fields using known list of correct data - Efficiency Question
43 views
Asked by KXross
How to add a months to a timestamp with time zone value while keeping the exact same hour
182 views
Asked by D. Mika
Fill in rows per group for pivoting
81 views
Asked by User1974
Assign GROUP_ID to rows based on start/end tags
89 views
Asked by User1974
Use ROW_NUMBER() window function without specifying ORDER BY
258 views
Asked by User1974
Oracle: Generate rows for missing years within range (sysyear + 9)
78 views
Asked by User1974
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
Select duplicates (including near-duplicate numbers)
79 views
Asked by User1974
Get data from nested tables
283 views
Asked by Martín
https request in Oracle 18c : "ORA-29024: Certificate validation failure"
614 views
Asked by elongez
Using CREATE SCHEMA AUTHORIZATION
2k views
Asked by Андрей Марченко
oracle SQL counter restarts when time difference is > x
35 views
Asked by Jdbfkfo
How to group by date and not datetime in Oracle?
90 views
Asked by coredev
Select rows where related rows only have unmatched years
130 views
Asked by User1974
Generate rows to fill in gaps between years, carry over value from previous year
341 views
Asked by User1974
How to select maximum records from timestamp and do the operation using LISTAGG
107 views
Asked by Vicky