SQL Syntax for SAP BW in Oracle

Aus Matts Wiki

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%'
Abgerufen von „https://otremba.net/w/index.php?title=SQL_Syntax_for_SAP_BW_in_Oracle&oldid=3768“