SQL Syntax for SAP BW in Oracle

Aus Matts Wiki
Version vom 21. Dezember 2025, 14:20 Uhr von Matt (Diskussion | Beiträge) (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…“)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)

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“