Wikipedia:Reference desk/Archives/Computing/2024 July 19

Welcome to the Wikipedia Computing Reference Desk Archives
The page you are currently viewing is a transcluded archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages.

July 19

Oracle "plan" keyword

I am trying to find documentation on the "plan" keyword in Oracle. I am not looking for "explain plan." That is completely different. What I am looking for is the plan keyword in this context:

   select a.id
   from a, b
   plan a
   where a.date between begindate and enddate

I have two different Oracle documentation books in PDF. In both if I search for pages with "plan" that do not have "explain", I come up with zero results. Searching the web, I only find explain plan, which has nothing to do with that as far as I can see. 75.136.148.8 (talk) 20:04, 19 July 2024 (UTC)

Can you tell us where you saw that code and what version of the software it was designed for? When I tried it, the word "plan" was interpreted as an alias for the table b reference, and the following "a" was considered a syntax error. Here is a fiddle. -- Tom N talk/contrib 00:45, 21 July 2024 (UTC)

It is used extensively in samples of code for a slide deck for Oracle Health EHR. Nearly every snippet of code has that syntax. I avoided using the actual table names because every slide has a huge "Propietary: Do Not Distribute" watermark on it, but I don't think the table names make a difference. 75.136.148.8 (talk) 11:22, 21 July 2024 (UTC)