News for hackers. Stuff that matters.

A comment on The History of Scott/Tiger.

Re:The History of Scott/Tiger by smitty1e on Friday August 26, 2022 @03:58AM (#32604439)
How about naming a one-row, one col table 'dual' to get a SELECT going where the db demand something in the FROM clause?

Was that a Scott flourish?

I've done that with other dbs than Oracle.

[ Parent | on HN ]
Re:The History of Scott/Tiger by hibbelig on Saturday August 27, 2022 @07:33AM (#32617885)
Why is it called "dual" if there is only one item in it? I guess it's a joke of some sort, but I'm not getting it :-/
[ Parent | on HN ]
Re:The History of Scott/Tiger by chasil on Friday August 26, 2022 @05:50AM (#32605237)
...and the column is named DUMMY.

All hell breaks loose if you insert or delete from this table.

I made a DUAL table in Rdb.

[ Parent | on HN ]