DB API question - where is a stored procedure's return value?

Chris Angelico rosuav at gmail.com
Thu Mar 13 13:32:39 EDT 2014


On Fri, Mar 14, 2014 at 4:22 AM,  <random832 at fastmail.us> wrote:
> DUAL is an Oracle thing. It used to have two rows, in order to be used
> to duplicate results by doing a cartesian join to it. At some point,
> that was removed, but the name stuck.
>
> Most other servers allow SELECT without FROM.

Yeah, I usually use PostgreSQL which does. I don't remember what DB2
has. MySQL I think requires either DUAL or an actual real table.

ChrisA



More information about the Python-list mailing list