Oracle
ID #1120
Table de multiplication avec un SELECT
Voici un exemple pour construire un SQL pour générer une table de multiplication :
SELECT
LEVEL * 1 AS "x01",
LEVEL * 2 AS "x02",
LEVEL * 3 AS "x03",
LEVEL * 4 AS "x04",
LEVEL * 5 AS "x05",
LEVEL * 6 AS "x06",
LEVEL * 7 AS "x07",
LEVEL * 8 AS "x08",
LEVEL * 9 AS "x09",
LEVEL * 10 AS "x10"
FROM dual CONNECT BY LEVEL <= 10
Tags: table multiplication sql oracle
Related entries:
Dernière mise à jour: 2014-04-29 10:13
Auteur: Michel Preti
Révision: 1.0
Vous ne pouvez pas commenter cet enregistrement