SELECT A . PLU, B . ARTICLE, REPLACE(C . NAME, CHR(9), ' ') AS NAME, 0 AS DEP, SUPERMAG.CLASSIFIER.NORMALIZECLASSIF(SUBSTR(D.TREE, 1, INSTR(D.TREE, '.'))) AS GROUP_ZN, SUBSTR(D.TREE, 1, INSTR(D.TREE, '.')) AS TREE, A . STOREUNIT FROM SUPERMAG . SLARTSCALEMAP A, SUPERMAG . SVSTOREUNITS B, SUPERMAG . SMCARD C, SUPERMAG.SACARDCLASS D WHERE (A.LOCID = :P_LOC) AND A.STATE = 0 AND (A.DEPID = :P_DEP) AND (A.STOREUNIT = B.BARCODE) AND (B.ARTICLE = C.ARTICLE) AND (C.IDCLASS = D.ID) ORDER BY 4 ASC, 5 ASC, 6 ASC, 3
SELECT username, default_tablespace, temporary_tablespace FROM dba_Users