Articles in - SQL

Page 1 of 212

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

How to use REF CURSOR in PL/SQL?

Here is a simple example to implement REF CURSOR in PL/SQL programming....Read full story

Return to top

Date Dimension SQL Scripts – MS SQL Server

MS SQL Server scripts to create Date Dimension....Read full story

Return to top

SQL Interview Questions – Part 2

Some common interview questions related to SQLs....Read full story

Return to top

Simple Star Schema Model for Sales Fact

Simple Data Model to illustrate a Sales Fact Star Schema....Read full story

Return to top

Date Dimension SQL Scripts – MySQL

Simple MySQL Scripts to create Date Dimension....Read full story

Return to top

Page 1 of 212