3 ms·
'select <star>' also doesn't always do what you expect. I recall a problem with some Oracle views that were based on 'select <star>' queries. What we didn't r
by ams6110 13y ago
'select <star>' also doesn't always do what you expect.
I recall a problem with some Oracle views that were based on 'select <star>' queries. What we didn't realize is that the '*' is evaluated when the view is compiled, and if you later add columns to the underlying tables the view did not automatically include them.
Edit: OK I don't know how to include a literal star in text here.
- TeMPOraL 13y agoTry typing 3 stars in a row: * :).
- ams6110 13y agoNo luck
- deleted 13y ago[deleted]
- nsmartt 13y agoThe following works without issues, for whatever reason: 'select *'
- thristian 13y agoI'm going to guess you need to backslash-escape your stars. EDIT: Nope, that wasn't it. shakes fist at crazy home-grown not-quite-Markdown
- sp332 13y agoIt works if you put a * space * around your stars. Or you can make a *literal* line by putting two spaces before it.