Oracle

ID #1089

Génération d'un SELECT de 10 ans mobile avec 12 mois

Génération pratique d'un SELECT de 10 ans mobile avec les 12 mois.Cette requête permet d'alimenter des valeures à zéros nécessaires pour certains affichages. 

 

SELECT T_ANNEE.ANNEE, T_MOIS.MOIS, T_MOIS.QTE
  FROM (    SELECT TO_CHAR (SYSDATE, 'YYYY') - LEVEL + 1 ANNEE
              FROM DUAL
        CONNECT BY LEVEL <= 11) T_ANNEE,
       (    SELECT LEVEL MOIS, 0 QTE
              FROM DUAL
        CONNECT BY LEVEL <= 12) T_MOIS

 

 

 

Tags: ajout modules java talend

Related entries:

Dernire mise jour: 2011-09-01 15:00
Auteur: Michel Preti
Rvision: 1.0

Digg it! Imprimer cet article Envoyer  un ami version PDF
Propose a translation for Propose a translation for
Merci de noter cette entre:

Moyenne des notes: 0 sur 5 (0 Votes)

compltement inutile 1 2 3 4 5 indispensable

Vous ne pouvez pas commenter cet enregistrement

Comment par Ec4ksJx1:
UFI the user friendly inratfece, was to become AFI (a for advanced, but was superceded by PL/SQL (AFI didn't arrive as pl/sql - that was another project altogether, but since plsql sort of removed the need for a semi-procedural scripting language, AFI 'died')and yes, sqlplus was an option. If you used it during version six, you were using the sqlplus option. just like row level locking was (an option) :)
Added at: 2015-10-19 03:08

Comment par HPe3GRAgJkKA:
Third Flower My spouse and i have alerady been now delighted that Albert could carry out his reports on account of the concepts he had through your online page. It really is now and again perplexing to only constantly be freely giving techniques which some people c
Added at: 2015-10-20 12:34

Comment par GNjc7yPV:
we like to honor a lot of other world-wide-web web-sites around the web, even if they aren?t lniekd to us, by linking to them. Under are some webpages worth checking out
Added at: 2015-12-21 08:52

Comment par 03V9Ua5xkX:
I am bemused/amused by the nebmur of men commenting on the technical accuracy of the comments being made regarding the joke; or about how they could have written it better. Sql programmers are as bad as plumbers : "I don't know who did this for you love but they should have done it like this instead" - sql testosterone! LMAO
Added at: 2015-12-21 13:58