Wikipedia:Reference desk/Archives/Computing/2024 July 19
Appearance
Computing desk | ||
---|---|---|
< July 18 | << Jun | July | Aug >> | July 20 > |
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
[edit]Oracle "plan" keyword
[edit]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)