How to convert UNIX epochs to datetime values in Oracle Database (and back again!)
Oracle | All Things SQL Blog
by
4d ago
Learn how to convert UNIX epochs to datetime values in Oracle Database and vice-versa, turn epochs in datetimes in non-UTC time zones, deal with the year 2038 problem ..read more
Visit website
Announcing the 2022 Oracle Dev Gym Championships
Oracle | All Things SQL Blog
by
3w ago
Announcing the 2022 Oracle Dev Gym Championships ..read more
Visit website
Percentage calculations using SQL Window Functions
Oracle | All Things SQL Blog
by
2M ago
An overview of SQL Window Functions and their powerful capabilities illustrated on fictional movie actor salaries ..read more
Visit website
Avoid writing SQL inside loops for fast database code #JoelKallmanDay
Oracle | All Things SQL Blog
by
4M ago
Learn how to write fast SQL by using set-based processing ..read more
Visit website
How to group rows into 5, 10 or 15-minute intervals with Oracle SQL
Oracle | All Things SQL Blog
by
6M ago
Learn how to count rows in time intervals of 5, 10 or 15 minutes or any other size using Oracle Database. Find out how to deal with gaps in the times and other non-standard grouping needs ..read more
Visit website
OGB Appreciation Day: SQL Pattern Matching (match_recognize) Use Cases
Oracle | All Things SQL Blog
by
6M ago
An overview of business problems you can solve using SQL pattern matching, including: Finding consecutive rows; Grouping rows into batches, with unknown gaps in between; Solving bin packing problems; Searching for sequences of events ..read more
Visit website
New quizzes page, quiz author, and daily featured quizzes on Oracle Dev Gym
Oracle | All Things SQL Blog
by
8M ago
I’m excited to announce a host of updates to Oracle Dev Gym: An updated quizzes page, a new quizmaster, and daily featured quizzes. These continue Oracle Dev Gym’s traditions of showcasing Oracle APEX, community involvement, and regular quiz taking as a key way to learn ..read more
Visit website
Announcing the winners of the 2021 Oracle Dev Gym Championships
Oracle | All Things SQL Blog
by
1y ago
For the past few weeks, players competed for top honours in the annual Oracle Dev Gym Championships. These tested contender's knowledge of Oracle Database and Logic. The final results are in, so it's time to announce the winners ..read more
Visit website
Last week on AskTom
Oracle | All Things SQL Blog
by
1y ago
Its been an interesting week on AskTom. Here's a couple of question that seem like odd scenarios, but ultimately (as is often the case) have simple and straightforward explanations. 1) Different object counts after import Neil posted as question, where he had performed an export in version 9i of the ..read more
Visit website
How to write SELECT * EXCEPT queries in Oracle Database
Oracle | All Things SQL Blog
by
1y ago
Remove columns by name or type from query results using Polymorphic Table Functions or SQL Macros ..read more
Visit website

Follow Oracle | All Things SQL Blog on Feedspot

Continue with Google
OR