https://otremba.net/w/index.php?action=history&feed=atom&title=SQL_Syntax_for_SAP_BW_in_OracleSQL Syntax for SAP BW in Oracle - Versionsgeschichte2026-04-28T08:31:53ZVersionsgeschichte dieser Seite in Matts WikiMediaWiki 1.43.0https://otremba.net/w/index.php?title=SQL_Syntax_for_SAP_BW_in_Oracle&diff=3768&oldid=prevMatt: Die Seite wurde neu angelegt: „This article contains examples for different SQL statements on Oracle servers to read data from a SAP BW database. == String Operations == Get first five characters for all rows from specified column: SELECT DISTINCT SUBSTR("/BIC/ZCONTRNO",1,5) FROM "/BIC/AZCONTR0100" Return one column for all records from a table starting with a given character in a particular column: SELECT "/BIC/ZCONTRNO" FROM "/BIC/AZCONTR0100" WHERE "/BIC/ZCONTRNO" LIKE '7%' Kat…“2025-12-21T13:20:53Z<p>Die Seite wurde neu angelegt: „This article contains examples for different SQL statements on Oracle servers to read data from a SAP BW database. == String Operations == Get first five characters for all rows from specified column: SELECT DISTINCT SUBSTR("/BIC/ZCONTRNO",1,5) FROM "/BIC/AZCONTR0100" Return one column for all records from a table starting with a given character in a particular column: SELECT "/BIC/ZCONTRNO" FROM "/BIC/AZCONTR0100" WHERE "/BIC/ZCONTRNO" LIKE '7%' Kat…“</p>
<p><b>Neue Seite</b></p><div>This article contains examples for different SQL statements on Oracle servers to read data from a SAP BW database.<br />
<br />
== String Operations ==<br />
Get first five characters for all rows from specified column:<br />
SELECT DISTINCT SUBSTR("/BIC/ZCONTRNO",1,5) FROM "/BIC/AZCONTR0100"<br />
Return one column for all records from a table starting with a given character in a particular column:<br />
SELECT "/BIC/ZCONTRNO" FROM "/BIC/AZCONTR0100" WHERE "/BIC/ZCONTRNO" LIKE '7%'<br />
[[Kategorie:SAP]]<br />
[[Kategorie:SQL]]</div>Matt