Re:Ask HN: How do you test SQL?
by jph00 on Tuesday January 31, 2023 @06:59PM
(#34604196)
CTE==Common Table Expression. It's not specific to any particular language. It's basically like a view, except you can define them the same place as you use them, and they can be recursive.
[ Parent
| on HN ]
Re:Ask HN: How do you test SQL?
by jimmygrapes on Tuesday January 31, 2023 @07:40PM
(#34604605)
Thank you for the clarification, that actually makes sense in context!
... Although also now I'm a little. put off because you reminded me of working with DOS-based SAP interfaces and Oracle's Java-based attempts to make "interactive views" circa 2006 :/