Re: LinuxTag wrapup

Andreas Pflug wrote:
<snip>
> That's true, it's the question how much can be offered without too much 
> effort.
> I'm not too deep in oracle stuff, what comes to my mind is
> - outer join syntax (parser thing)
> - sequences usage (parser too)
> - maybe stored procedure call, with a wrapper to convert output 
> parameters to a composite return value.

There's also their "FROM DUAL" workaround (in common usage) as well.

i.e. SELECT NEXTVAL.foo FROM DUAL;

Because their SQL queries always seem to need a target object to select 
from.  i.e. "SELECT NEXTVAL.foo" isn't valid for Oracle 8/9.

Regards and best wishes,

Justin Clift


> There's certainly no point supporting any weird ddl command, so there's 
> still porting work to be done when migrating.
> 
> Regards,
> Andreas