This functionality is only available for certain module packages.

You are here: EEC > BASE > Data sources > Data source objects > DatabaseDataSource > Oracle

Oracle

In an Oracle database, the column names are by default case-insensitive, i.e., uppercase / lowercase spelling does not matter. Internally, Oracle enters the column names in uppercase letters – and this is how they are also received in the EEC.

In this mode, it does not matter for SQL requests whether column and table names are spelled with uppercase or lowercase letters. When accessing the requested data, all column names must be entered in uppercase letters.

...perform('select * from Artikel ').collect( x | x.ARTIKELNUMMER)

Oracle is also capable of stating column names as case-sensitive by placing them in quotes in the Create Table statements or by selecting the Maintain Case-Sensitivity check box in the object browser when creating tables.

In this case, all SQL requests must also be placed between apostrophes:

..perform('select "Artikelnummer" from "Artikel"').collect(x | x.Artikelnummer)