Informix (Lazy Universal)

1.create View 444 (...) As SELECT ... from ...

2.insert into select.......union Select not supported please write separately

4.GBase 8t The default case is insensitive, but the content in quotation marks is case-sensitive; Oracle defaults to be insensitive inside and outside quotes.

A trigger of 5.GBase 8t can trigger only one event

6.create or replace remove or replace

Null in 7.GBase 8t is treated as the minimum value in the sort, while in Oracle, NULL is used as the maximum value in the sort

8. Support cascading queries (start with connect by) low efficiency write recursion better

9. Row Career Strsum ()

Informix (Lazy Universal)