The Toronto Stock Exchange was formed on 25 October 1861.

On 24 October 1901, Annie Taylor became the first person to go over the Niagara Falls in a barrel successfully.

This uses the window clause, added in Oracle Database 21c, to find the name of the first person to go over Niagara, sorted by fall (date).

On 23 October 1868, the Meiji era began in Japan.

This uses the temporal period meiji_era to get the emperor on this date.

On 22 October 1975, Venera 9 became the first craft to land on Venus.

On 21 October 1973, Fred Dryer became the only NFL player to date to score two safeties in one game.

It's Clean Your Virtual Desktop Day!

This uses direct join syntax, added in release 23ai, to remove rows from the icons table that have a row with the same location in the desktop table.

On 19 October 1900, Max Planck produced his law of black-body radiation.

This uses the OLD and NEW clauses, added in release 23ai, to get the values for energy before and after the update.

On 18 October 1356, the Saint Luke's Day Earthquake - one of the deadliest in Europe - struck Basel, Switzerland.

This truncates the partition of the Switzerland table that contains the value “Basel”. The CASCADE clause applies this operation to any reference partitioned child tables.

On 17 October 1814, a vat of fermenting porter burst at Meux & Co's Horse Shoe Brewery, leading to a flood of beer in London.

This uses the window clause, added in release 21c, to define a window named “london”.

On 16 October 1793, Marie Antoinette, the wife of King Louis XVI and the last queen of France, was executed by guillotine.

This uses direct join syntax, added in release 23ai, to remove rows from the queens table that are wives of the Louis XVI.

On 15 October 1932, Tata Airlines, now Air India, was founded.

It's Ada Lovelace Day! She was a mathematician and writer and is widely considered the first programmer.

On 13 October 54, Roman Emperor Claudius died.

On 12 October 1822, Pedro I was proclaimed the first Emperor of Brazil.

On 11 October 1852, the University of Sydney was inaugurated.

This creates a global application context. These enable you to store name-value pairs in memory.

On 10 October 1846, Triton, Neptune's largest moon, was discovered by William Lassell.

FIRST_VALUE is a window function that returns the expression for row 1 in each partition according to the sort. So this finds the name of the largest moon (by radius) for each planet.

It's Hangeul Day (Korean: 한글날) in South Korea. This celebrates the invention of the Korean alphabet in the 15th century.

This uses the third parameter of TO_DATE to specify the language of the input string to be converted into a date.

On 8 October 1645, Hôtel-Dieu de Montréal, the first hospital in Montreal, Canada, was founded by Jeanne Mance.

On 7 October 1912, the first transaction was made on the Helsinki Stock Exchange.

This starts a read-write transaction; the name will appear in the v$transaction view.

On 6 October 2010, Instagram launched.

On 5 October 1910, Portugal became a republic following a coup which overthrew the monarchy.

On 4 October 1958, the Fifth French Republic was established.

On 3 October 1971, Billie Jean King became the first woman to earn more than $100,000 in one year when she won a tournament in Phoenix.

On 2 October 2004, the first Parkrun—a series of 5km running events—was held in London. These were initially named UK Time Trials.

This creates a conditional check constraint. If the type is parkrun, the distance must be five. For other events, the case expression returns null. This evaluates to unknown, so you can set any distance for other event types because check constraints only reject rows that evaluate to false.

On 1 October 1975, Muhammad Ali defeated Joe Frazier in a boxing bout billed as the Thrilla in Manila.

On 30 September 1985, Charles Richter, inventor of the Richter scale, died.

This creates a usecase domain, added in Oracle Database 23ai, to describe values in the Richter scale.

On 29 September 2024, asteroid 2024 PT5 was temporarily captured by Earth's gravity, forming a mini-moon.

This adds a foreign key from the moons table to the earth table. It lists no columns of earth, so the foreign key defaults to referencing earth's primary key.

It's Ask a Stupid Question Day! It's said there's no such thing as a stupid question, so ask away!

This statement returns the rows from calendar with no row in questions that matches the dt with the type “stupid”.

On 27 September 1590, Pope Urban VII died, ending the shortest recognized papacy.

This statement finds rows from popes with the smallest difference between end_dt and start_dt.

On 26 September 1973, Concorde flew from Washington DC to Paris, Orly in a record breaking time of 3 hours 33 minutes.

The first Chicago marathon was held on 25 September 1977.

On 24 September 1869, a gold panic broke out in the US after its price fell from $160 to $138.

This uses the OLD and NEW clauses of RETURN[ING], added in release 23ai, to get the gold price before and after the update.

Nintendo Koppai, which later became Nintendo Co., Ltd., was founded on 23 September 1889.

It's Miniature Golf Day!

This creates a view that LOWERs (minifies) the golf course names :)

On 20 September 1983, the RSA encryption algorithm was patented.

This creates a multicolumn use case domain for the keys this algorithm uses. Remember that you should never share your private key when using RSA encryption!

The first Glastonbury festival was held on 19 September 1970.

This query returns the row for the festival located at latitude = 51.149722, longitude = -2.586944 - Glastonbury!

It's Chilean Homeland Holidays! On 18 September 1810, Chile formed the Government Junta of Chile. This started the process of gaining independence from Spain.

This statement splits Sanitago from the partition Spain into the partition Chile.

On 17 September 1991, Linus Torvalds released the first version (0.01) of Linux.

It's Collect Rocks Day!

This statement uses the COLLECT function to combine rows into a nested table array.

On 15 September 1835, Charles Darwin reached the Galápagos Islands on the second voyage of the HMS Beagle.

This uses the COLLATE operator with the BINARY_AI collation to give case- and accent-insensitive comparisons.

On 14 September 1999, Nauru, Kiribati, and Tonga joined the United Nations.

This uses the table-values constructor, added in release 23ai, to do a multi-row insert and add all three rows in one statement.

It's Roald Dahl Day! This celebrates the birth of the popular children's books author.

This statement sorts crocodiles from largest to smallest and returns all those that are the biggest (The Enormous Crocodile(s)).

On 12 September 1958, Jack Kilby demonstrated the first integrated circuit at Texas Instruments.

Happy 2nd Birthday to SQuizL! Thanks for playing; we hope this brings a little SQL joy into your life.

This statement finds the name of all quizzes where 24 months (2 years) have elapsed between their first and last quiz.

On 10 September 2008, the first beam was sent by the Large Hadron Collider at CERN.

This creates an enumeration domain of the hadron types.

On 9 September 2009, the Dubai Metro began operation. Initially, there was only the red line; the green line was opened in 2011.

This uses the table values construct to load both rows in one statement.

On 8 September 1946, Bulgaria held a referendum on whether to abolish its monarchy. Its citizens overwhelmingly voted to do so, with over 95% voting in favour.

On 7 Sept 1923, the International Criminal Police Organization – INTERPOL was formed.

The JSON data type was added in Oracle Database 21c.

On 6 September 1766, John Dalton, a chemist credited as being the first person to use symbols to represent chemical elements, was born.

The IF EXISTS syntax was added in release 23ai. This statement will run without error if there is no table named chemical_elements.