When put in a chart don't show all hours from day. I made a table from 1 to 24
Group by hour in Oracle
problem
solution
I found a simple method like this
SELECT LEVEL - 1 AS time_hour
FROM dual
CONNECT BY LEVEL <= 24
Author: Dumitru Maros
Last Edit:
July 3, 2024
1 Thanks received
Join in! I'm building here a library of useful solutions to software development problems. If you like this project, create an account or add a bookmark, then come back here to write a post yourself when you run into something that might be useful to others... >> read more
Last Edit | July 3, 2024 |
Created | July 2, 2024 |
Views | 61 |
Tags |
Oracle
SQL
|
Your Comment
Feel free to post additional info or improvement suggestions.