Posts tagged ‘Oracle’

Combine multiple Rows to a Column – Oracle

Oracle SQL to convert multiple rows of result set to a single column. CREATE TABLE FRUITS ( NAME VARCHAR2(20)); INSERT INTO FRUITS VALUES ('APPLE'); INSERT INTO FRUITS VALUES ('BANANA'); INSERT INTO FRUITS VALUES ('CHERRY'); SELECT SUBSTR (SYS_CONNECT_BY_PATH (NAME , ','), 2) FRUITS_LIST FROM (SELECT NAME , ROW_NUMBER () OVER (ORDER BY NAME ) RN, COUNT [...]...Read full story

Return to top

Date Dimension SQL Scripts – Oracle

SQL Scripts to create Date Dimension in Oracle....Read full story

Return to top

Common Mistakes in Oracle PL/SQL Programming

Common Mistakes in Oracle PL/SQL Programming by Steven Feuerstein....Read full story

Return to top