Oracle | All Things SQL Blog
1000 FOLLOWERS
This is the Oracle SQL blog celebrating the joy and power of Oracle SQL with the Oracle Developer Advocate team. Follow to get daily Oracle SQL tips from the Oracle Developer Advocates for SQL.
Oracle | All Things SQL Blog
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
Oracle | All Things SQL Blog
2M ago
An overview of SQL Window Functions and their powerful capabilities illustrated on fictional movie actor salaries ..read more
Oracle | All Things SQL Blog
4M ago
Learn how to write fast SQL by using set-based processing ..read more
Oracle | All Things SQL Blog
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
Oracle | All Things SQL Blog
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
Oracle | All Things SQL Blog
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
Oracle | All Things SQL Blog
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
Oracle | All Things SQL Blog
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
Oracle | All Things SQL Blog
1y ago
Remove columns by name or type from query results using Polymorphic Table Functions or SQL Macros ..read more