execute Sybase procedures from Oracle SQL Developer

Oracle SQL Developer provides access to data and code from other database systems than Oracle If you run Sybase procedures (or Microsoft SQL Server I suppose), you cannot use the BEGIN / DECLARE / EXEC in anonymous blocks begin print ‘HELLO’ end Error starting at line : 1 in command – begin print ‘HELLO’ end […]

on analytics and superaggregation

When I wrote my book, I did not expect having the advanced Oracle sql features available on other dabatase engine. This week-end I downloaded for fun a try of db2, v9.7. 1) download db2 linux64bit trial on ibm.com 2) install enterprise edition (next-next-install principle) 3) create the instance 4) create the sample database (where database […]