Before it sued Google for copying from Java, Oracle got rich copying IBM’s SQL Oracle's history highlights a possible downside to its stance on API copyrights.

The reason is, that array (or cursor) is constructed and populated in PL/SQL engine, SELECT statement execution is performed in SQL engine and Oracle must convert complete result set to switch between ...

Oracle配置wallfilter后，下面select case when语句报错 SELECT 1 FROM tableName WHERE 0 > ( SELECT CASE WHEN EXISTS ( SELECT 1 FROM dual ) THEN 1 WHEN 1 = 2 THEN 15 ELSE 1 END FROM dual ) 取消wall后，sql可正常执行。