Oracle SQL syntax between Standard/enterprise and Express

Question

I have a question in different Oracle versions. In their download page, there is Standard/Enterprise, and there is Express. Other than performance and other infrastructure tools, do the two different versions support the same set of SQL script keywords? For example, if I generate DDL tables from standard, is there a chance it may not work on Express (data type, function name, etc may not be supported on Express)?

thanks

Answer 1

From the programmer's point of view, Express, Standard and Enterprise editions are the same. The only difference between them are in licensing and scalability.

See this OraFAQ article for the details.

Answer 2

Mostly they work, but with some restrictions.

For example, Standard and Express Edition don't support bitmap indexes or compressed tables. Express edition doesn't have Java but is otherwise close enough to Standard Edition. Express Edition is 10gR2, so any 11g (R1 or R2) stuff won't work.

Anything from a cheaper edition would work in a more expensive one.