Forum |  HardWare.fr | News | Articles | PC | S'identifier | S'inscrire | Shop Recherche
4271 connectés 

 
 

Sujet(s) à lire :
    - Who's who@Programmation
 

 Mot :   Pseudo :  
  Aller à la page :
 
 Page :   1  2  3  4  5  ..  15555  15556  15557  ..  27007  27008  27009  27010  27011  27012
Page Suivante
Page Précédente
Bas de page 
Auteur Sujet :

[blabla@olympe] Le topic du modo, dieu de la fibre et du monde

n°1844231
mareek
Et de 3 \o/
Posté le 28-01-2009 à 14:25:26  profilanswer
 

Reprise du message précédent :

cosmoschtroumpf a écrit :

Ben je sais pas, il me semblait pourtant que justement, les OEM ne mettaient jamais de basic parce que ça puait trop fort le bas de gamme ? En supposant que starter est effectivement destiné à certains pays seulement, pourquoi ils font pas juste home/pro/ultimate ? C'est pas la différence, assez faible, de prix entre la home basic et la home premium qui peut vraiment justifier ça, si ?


Je pensais comme toi jusqu'à ce que ma soeur se fasse offrir un Portable avec vista home basic. J'imagine que le but est double: gratter quelques euros sur une config au prix ultra serré et envoyer un message du genre "Vous achetez un truc bas de gamme, si vous voulez avoir la classe il va faloir passer à la caisse". l'autre avantage de la version basic c'est qu'elle doit être plus réactive sur les configs avec un chip graphique de merde vu qu'il n'y a pas de transparence sur les fenêtres.

Dr Alphonse a écrit :

Au fait c'est nouveau cette rédaction en mode wysiwyg ?


C'est là depuis un bout de temps mais je l'ai désactivé :o

mIRROR a écrit :

ca me rappelle que j ai vu le top gear qui a initié la haine de la caravane dans brainiac [:romf]


Mais de quoi tu parles [:heink]

Message cité 2 fois

---------------
"I wonder if the internal negative pressure in self pumping toothpaste tubes is adjusted for different market altitudes." John Carmack
mood
Publicité
Posté le 28-01-2009 à 14:25:26  profilanswer
 

n°1844232
cheval
Posté le 28-01-2009 à 14:28:44  profilanswer
 

Dion a écrit :


 
Comme Ted Kennedy a vu un noir a la maison blanche, Uriaiche a connu windev12 avant sa mort [:dawa]


il aura même vu windev14 ~[:dawa]~

n°1844234
cheval
Posté le 28-01-2009 à 14:29:13  profilanswer
 

kadreg a écrit :


 
il s'est fait sodomisé par un cheval ?


par un nom de boite mail oublié [:dawak]

n°1844236
skeye
Posté le 28-01-2009 à 14:31:20  profilanswer
 

Je suis con, j'ai voulu mater le code d'une vue créée par ma chef.[:psywalk]
 

Code :
  1. SELECT ... ,
  2. decode(substr(ltrim(to_char((99999999-(INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  3. '09999999'),' '),8,1),'1','a','2','b','3','c','4','d','5','f','6','h','7','k','8','m','9','n','p')||
  4. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  5. '09999999'),' '),3,1)||
  6. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  7. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  8. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  9. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  10. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  11. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  12. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  13. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  14. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  15. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  16. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  17. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  18. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  19. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  20. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(
  21. INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  22. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  23. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  24. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  25. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  26. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  27. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  28. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  29. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  30. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  31. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  32. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  33. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  34. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  35. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  36. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  37. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  38. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  39. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  40. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  41. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  42. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  43. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  44. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  45. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  46. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  47. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  48. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  49. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  50. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  51. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  52. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  53. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  54. decode(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  55. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),4,1),'1','a','2','b','3','c',
  56. '4','d','5','f','6','h','7','k','8','m','9','n','p')||
  57. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  58. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  59. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  60. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  61. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  62. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  63. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' ')
  64. ,7,1))),' '),1,1),
  65. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  66. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  67. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  68. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  69. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  70. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  71. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  72. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  73. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  74. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  75. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  76. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  77. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  78. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  79. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  80. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  81. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  82. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  83. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  84. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  85. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  86. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  87. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  88. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  89. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  90. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  91. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  92. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  93. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  94. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  95. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  96. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  97. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  98. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  99. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  100. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  101. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  102. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  103. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  104. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  105. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  106. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),1,1)||
  107. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  108. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),6,1)
  109. FROM ...


 
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]

Message cité 7 fois

---------------
Can't buy what I want because it's free -
n°1844237
schnapsman​n
Zaford Beeblefect
Posté le 28-01-2009 à 14:32:15  profilanswer
 

skeye a écrit :

Je suis con, j'ai voulu mater le code d'une vue créée par ma chef.[:psywalk]
 

Code :
  1. SELECT ... ,
  2. decode(substr(ltrim(to_char((99999999-(INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  3. '09999999'),' '),8,1),'1','a','2','b','3','c','4','d','5','f','6','h','7','k','8','m','9','n','p')||
  4. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  5. '09999999'),' '),3,1)||
  6. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  7. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  8. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  9. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  10. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  11. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  12. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  13. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  14. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  15. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  16. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  17. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  18. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  19. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  20. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(
  21. INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  22. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  23. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  24. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  25. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  26. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  27. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  28. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  29. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  30. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  31. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  32. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  33. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  34. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  35. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  36. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  37. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  38. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  39. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  40. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  41. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  42. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  43. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  44. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  45. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  46. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  47. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  48. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  49. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  50. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  51. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  52. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  53. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  54. decode(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  55. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),4,1),'1','a','2','b','3','c',
  56. '4','d','5','f','6','h','7','k','8','m','9','n','p')||
  57. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  58. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  59. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  60. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  61. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  62. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  63. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' ')
  64. ,7,1))),' '),1,1),
  65. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  66. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  67. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  68. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  69. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  70. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  71. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  72. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  73. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  74. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  75. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  76. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  77. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  78. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  79. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  80. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  81. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  82. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  83. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  84. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  85. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  86. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  87. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  88. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  89. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  90. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  91. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  92. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  93. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  94. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  95. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  96. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  97. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  98. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  99. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  100. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  101. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  102. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  103. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  104. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  105. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  106. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),1,1)||
  107. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  108. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),6,1)
  109. FROM ...


 
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]


 [:cannot be unseen]

n°1844239
___alt
Posté le 28-01-2009 à 14:33:30  profilanswer
 

skeye a écrit :

Je suis con, j'ai voulu mater le code d'une vue créée par ma chef.[:psywalk]


 
LES MOTS ILS BRULENT MON CERVEAU [:cannot be unseen]


---------------
TRIPS RIGHT BUNCH F SHUTTLE TOM AND JERRY RIGHT YELLOW
n°1844240
skeye
Posté le 28-01-2009 à 14:33:57  profilanswer
 

'tain c'est pour générer un mot de passe.[:ciler]


---------------
Can't buy what I want because it's free -
n°1844241
BenO
Profil: Chercheur
Posté le 28-01-2009 à 14:34:39  profilanswer
 

WTF
 

Message cité 1 fois

---------------
Python Python Python
n°1844242
skeye
Posté le 28-01-2009 à 14:36:27  profilanswer
 

BenO a écrit :

WTF


c'est un peu là que j'en suis de ma réflexion aussi, oui.[:petrus75]


---------------
Can't buy what I want because it's free -
n°1844244
cosmoschtr​oumpf
dawa powered
Posté le 28-01-2009 à 14:39:26  profilanswer
 

mareek a écrit :

Je pensais comme toi jusqu'à ce que ma soeur se fasse offrir un Portable avec vista home basic. J'imagine que le but est double: gratter quelques euros sur une config au prix ultra serré et envoyer un message du genre "Vous achetez un truc bas de gamme, si vous voulez avoir la classe il va faloir passer à la caisse". l'autre avantage de la version basic c'est qu'elle doit être plus réactive sur les configs avec un chip graphique de merde vu qu'il n'y a pas de transparence sur les fenêtres.


dans premium tu peux désactiver la transparence des fenêtres :o
 

mareek a écrit :

Mais de quoi tu parles [:heink]


de top gear, ils aiment pas les caravanes :o

Message cité 1 fois

---------------
Android/Manettes/Metroidvania/Zelda/Indés/Retrogaming/VDS jeux
mood
Publicité
Posté le 28-01-2009 à 14:39:26  profilanswer
 

n°1844245
cosmoschtr​oumpf
dawa powered
Posté le 28-01-2009 à 14:40:04  profilanswer
 

skeye a écrit :

Je suis con, j'ai voulu mater le code d'une vue créée par ma chef.[:psywalk]
 

Code :
  1. SELECT ... ,
  2. decode(substr(ltrim(to_char((99999999-(INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  3. '09999999'),' '),8,1),'1','a','2','b','3','c','4','d','5','f','6','h','7','k','8','m','9','n','p')||
  4. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  5. '09999999'),' '),3,1)||
  6. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  7. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  8. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  9. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  10. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  11. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  12. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  13. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  14. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  15. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  16. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  17. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  18. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  19. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  20. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(
  21. INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  22. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  23. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  24. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  25. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  26. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  27. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  28. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  29. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  30. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  31. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  32. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  33. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  34. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  35. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  36. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  37. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  38. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  39. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  40. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  41. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  42. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  43. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  44. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  45. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  46. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  47. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  48. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  49. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  50. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  51. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  52. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  53. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  54. decode(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  55. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),4,1),'1','a','2','b','3','c',
  56. '4','d','5','f','6','h','7','k','8','m','9','n','p')||
  57. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  58. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  59. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  60. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  61. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  62. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  63. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' ')
  64. ,7,1))),' '),1,1),
  65. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  66. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  67. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  68. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  69. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  70. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  71. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  72. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  73. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  74. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  75. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  76. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  77. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  78. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  79. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  80. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  81. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  82. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  83. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  84. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  85. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  86. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  87. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  88. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  89. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  90. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  91. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  92. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  93. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  94. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  95. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  96. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  97. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  98. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  99. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  100. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  101. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  102. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  103. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  104. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  105. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  106. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),1,1)||
  107. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  108. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),6,1)
  109. FROM ...


 
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]


ah mais y'a pire que mon chef en fait [:pingouino]


---------------
Android/Manettes/Metroidvania/Zelda/Indés/Retrogaming/VDS jeux
n°1844246
mIRROR
Chevreuillobolchévik
Posté le 28-01-2009 à 14:40:55  profilanswer
 

mareek a écrit :

Mais de quoi tu parles [:heink]


 
tu connais pas brainiac ? une émission a la con genre est ce qu on nage plus vite dans le sirop d érable ou dans l eau et dans chaque épisode ils font exploser une caravane avec ou des explosifs différents ou des produits chimiques pour avoir une nouvelle couleur a chaque fois
sfun :o
 

Message cité 1 fois

---------------
« The enemy is the gramophone mind, whether or not one agrees with the record that is being played at the moment. » — George Orwell
n°1844249
mareek
Et de 3 \o/
Posté le 28-01-2009 à 14:51:24  profilanswer
 

cosmoschtroumpf a écrit :

dans premium tu peux désactiver la transparence des fenêtres :o


Je parle d'un mode spécifique à home basic qui est accéléré par le chipset graphique  (ce qui règle les problèmes de trainées laissées par les fenêtres) mais avec des fenêtres opaques:
http://www.winsupersite.com/showca [...] std_ux.asp

cosmoschtroumpf a écrit :

de top gear, ils aiment pas les caravanes :o


En même temps qui aime les caravanes à part les (vieux) beaufs ? :o


---------------
"I wonder if the internal negative pressure in self pumping toothpaste tubes is adjusted for different market altitudes." John Carmack
n°1844250
masklinn
í dag viðrar vel til loftárása
Posté le 28-01-2009 à 14:52:33  profilanswer
 

skeye a écrit :

Je suis con, j'ai voulu mater le code d'une vue créée par ma chef.[:psywalk]
 

Code :
  1. SELECT ... ,
  2. decode(substr(ltrim(to_char((99999999-(INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  3. '09999999'),' '),8,1),'1','a','2','b','3','c','4','d','5','f','6','h','7','k','8','m','9','n','p')||
  4. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  5. '09999999'),' '),3,1)||
  6. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  7. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  8. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  9. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  10. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  11. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  12. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  13. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  14. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  15. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  16. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  17. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  18. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  19. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  20. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(
  21. INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  22. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  23. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  24. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  25. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  26. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  27. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  28. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  29. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  30. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  31. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  32. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  33. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  34. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  35. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  36. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  37. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  38. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  39. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  40. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  41. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  42. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  43. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  44. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  45. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  46. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  47. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  48. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  49. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  50. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  51. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  52. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  53. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  54. decode(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  55. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),4,1),'1','a','2','b','3','c',
  56. '4','d','5','f','6','h','7','k','8','m','9','n','p')||
  57. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  58. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  59. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  60. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  61. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  62. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  63. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' ')
  64. ,7,1))),' '),1,1),
  65. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  66. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  67. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  68. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  69. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  70. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  71. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  72. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  73. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  74. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  75. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  76. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  77. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  78. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  79. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  80. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  81. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  82. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  83. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  84. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  85. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  86. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  87. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  88. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  89. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  90. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  91. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  92. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  93. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  94. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  95. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  96. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  97. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  98. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  99. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  100. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  101. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  102. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  103. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  104. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  105. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  106. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),1,1)||
  107. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  108. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),6,1)
  109. FROM ...


 
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]


=> http://thedailywtf.com/ nao


---------------
I mean, true, a cancer will probably destroy its host organism. But what about the cells whose mutations allow them to think outside the box by throwing away the limits imposed by overbearing genetic regulations? Isn't that a good thing?
n°1844251
sligor
Posté le 28-01-2009 à 14:53:57  profilanswer
 

skeye a écrit :

Je suis con, j'ai voulu mater le code d'une vue créée par ma chef.[:psywalk]
 

Code :
  1. SELECT ... ,
  2. decode(substr(ltrim(to_char((99999999-(INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  3. '09999999'),' '),8,1),'1','a','2','b','3','c','4','d','5','f','6','h','7','k','8','m','9','n','p')||
  4. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  5. '09999999'),' '),3,1)||
  6. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  7. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  8. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  9. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  10. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  11. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  12. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  13. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  14. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  15. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  16. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  17. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  18. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  19. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  20. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(
  21. INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  22. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  23. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  24. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  25. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  26. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  27. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  28. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  29. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  30. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  31. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  32. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  33. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  34. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  35. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  36. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  37. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  38. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  39. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  40. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  41. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  42. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  43. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  44. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  45. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  46. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  47. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  48. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  49. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  50. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  51. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  52. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  53. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  54. decode(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  55. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),4,1),'1','a','2','b','3','c',
  56. '4','d','5','f','6','h','7','k','8','m','9','n','p')||
  57. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  58. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  59. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  60. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  61. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  62. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  63. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' ')
  64. ,7,1))),' '),1,1),
  65. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  66. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  67. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  68. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  69. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  70. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  71. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  72. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  73. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  74. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  75. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  76. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  77. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  78. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  79. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  80. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  81. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  82. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  83. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  84. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  85. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  86. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  87. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  88. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  89. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  90. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  91. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  92. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  93. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  94. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  95. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  96. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  97. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  98. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  99. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  100. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  101. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  102. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  103. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  104. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  105. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  106. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),1,1)||
  107. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  108. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),6,1)
  109. FROM ...


 
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]


 
les femmes ça ferait mieux de faire la cuisine et de s'occuper des gosses :o

n°1844252
lorill
Posté le 28-01-2009 à 14:57:43  profilanswer
 

skeye a écrit :

Je suis con, j'ai voulu mater le code d'une vue créée par ma chef.[:psywalk]

 
Code :
  1. SELECT ... ,
  2. decode(substr(ltrim(to_char((99999999-(INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  3. '09999999'),' '),8,1),'1','a','2','b','3','c','4','d','5','f','6','h','7','k','8','m','9','n','p')||
  4. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  5. '09999999'),' '),3,1)||
  6. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  7. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  8. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  9. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  10. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  11. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  12. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  13. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  14. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  15. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  16. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  17. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  18. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  19. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  20. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(
  21. INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  22. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  23. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  24. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  25. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  26. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  27. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  28. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  29. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  30. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  31. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  32. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  33. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  34. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  35. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  36. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  37. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  38. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  39. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  40. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  41. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  42. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  43. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  44. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  45. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  46. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  47. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  48. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  49. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  50. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  51. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  52. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  53. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  54. decode(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  55. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),4,1),'1','a','2','b','3','c',
  56. '4','d','5','f','6','h','7','k','8','m','9','n','p')||
  57. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  58. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  59. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  60. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  61. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  62. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  63. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' ')
  64. ,7,1))),' '),1,1),
  65. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  66. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  67. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  68. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  69. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  70. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  71. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  72. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  73. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  74. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  75. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  76. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  77. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  78. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  79. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  80. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  81. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  82. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  83. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  84. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  85. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  86. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  87. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  88. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  89. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  90. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  91. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  92. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  93. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  94. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  95. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  96. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  97. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  98. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  99. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  100. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  101. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  102. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  103. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  104. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  105. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  106. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),1,1)||
  107. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  108. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),6,1)
  109. FROM ...
 

[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]

 

y'a toujours des cons pour tout quoter  [:dawa]


Message édité par lorill le 28-01-2009 à 14:58:06
n°1844253
___alt
Posté le 28-01-2009 à 14:58:07  profilanswer
 

NON AUX QUOTES DE PORC [:what has been seen]


---------------
TRIPS RIGHT BUNCH F SHUTTLE TOM AND JERRY RIGHT YELLOW
n°1844254
sligor
Posté le 28-01-2009 à 15:01:02  profilanswer
 

Franck Leboeuf (Citation extraite de son roman "On me tape" )

Citation :


C'est toujours les mêmes qui s'amusent...  


 
je préfère les quotes de boeuf  :o

n°1844255
kadreg
profil: Utilisateur
Posté le 28-01-2009 à 15:04:31  profilanswer
 

vous pouvez eviter de quoter, le proxy de thales explose sinon :o

Message cité 1 fois

---------------
brisez les rêves des gens, il en restera toujours quelque chose...  -- laissez moi troller sur discu !
n°1844256
seabee
Posté le 28-01-2009 à 15:05:40  profilanswer
 

skeye a écrit :

Je suis con, j'ai voulu mater le code d'une vue créée par ma chef.[:psywalk]
 

Code :
  1. SELECT ... ,
  2. decode(substr(ltrim(to_char((99999999-(INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  3. '09999999'),' '),8,1),'1','a','2','b','3','c','4','d','5','f','6','h','7','k','8','m','9','n','p')||
  4. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),
  5. '09999999'),' '),3,1)||
  6. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  7. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  8. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  9. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  10. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  11. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  12. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  13. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  14. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  15. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  16. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  17. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  18. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  19. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  20. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(
  21. INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  22. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  23. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  24. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  25. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  26. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  27. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  28. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  29. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  30. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  31. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  32. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  33. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  34. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  35. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  36. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  37. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  38. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  39. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  40. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  41. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  42. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  43. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  44. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  45. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  46. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  47. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  48. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  49. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  50. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  51. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),5,1))+
  52. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  53. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  54. decode(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  55. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),4,1),'1','a','2','b','3','c',
  56. '4','d','5','f','6','h','7','k','8','m','9','n','p')||
  57. decode(to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  58. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  59. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  60. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1)),
  61. 0,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  62. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  63. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' ')
  64. ,7,1))),' '),1,1),
  65. 1,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  66. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  67. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  68. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  69. 2,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  70. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  71. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  72. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  73. 3,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  74. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  75. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  76. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  77. 4,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  78. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  79. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  80. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  81. 5,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  82. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  83. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  84. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  85. 6,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  86. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  87. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  88. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  89. 7,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  90. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  91. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+TO_NUMBER(
  92. TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  93. 8,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  94. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  95. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  96. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  97. 9,substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  98. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  99. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  100. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),1,1),
  101. substr(ltrim((to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  102. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),2,1))+
  103. to_number(substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  104. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),7,1))),' '),2,1))||
  105. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  106. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),1,1)||
  107. substr(ltrim(to_char((99999999 - (INDIVIDU.COD_IND+
  108. TO_NUMBER(TO_CHAR(INDIVIDU.DATE_NAI_IND,'MMYYYYDD')))),'09999999'),' '),6,1)
  109. FROM ...


 
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]
[:pingouino][:pingouino][:pingouino]


Y'a comme une sorte de magie oldskoul qui se dégage de ce code.

n°1844257
sligor
Posté le 28-01-2009 à 15:05:59  profilanswer
 

kadreg a écrit :

vous pouvez eviter de quoter, le proxy de thales explose sinon :o


tu bosses chez un trafiquant d'armes  [:wiids]


Message édité par sligor le 28-01-2009 à 15:06:27
n°1844259
Dion
Acceuil
Posté le 28-01-2009 à 15:17:01  profilanswer
 

Citation :

Which browsers are supported?
Offline Gmail currently works on Internet Explorer 7, Firefox 2, and Firefox 3. Support for other browsers is coming soon.


 
Sous Chrome à jour :

Citation :

Version 0.5.8.0 de Google Gears


Citation :

Offline Gmail requires Google Gear version 0.3.11 or newer. You will need upgrade Gears, and the installer will restart your browser.


 
Ils ont sous traité à Thal*s ?


---------------
When it comes to business/legal topics, just assume almost everyone commenting has no idea what they’re taking about and have no background in these subjects because that’s how it really is. Harkonnen 8-> Elmoricq 8====>
n°1844260
drasche
Posté le 28-01-2009 à 15:22:48  profilanswer
 

mIRROR a écrit :

tu connais pas brainiac ? une émission a la con genre est ce qu on nage plus vite dans le sirop d érable ou dans l eau et dans chaque épisode ils font exploser une caravane avec ou des explosifs différents ou des produits chimiques pour avoir une nouvelle couleur a chaque fois
sfun :o


Dans mon esprit c'est un ennemi de Superman :o

Message cité 1 fois

---------------
Whichever format the fan may want to listen is fine with us – vinyl, wax cylinders, shellac, 8-track, iPod, cloud storage, cranial implants – just as long as it’s loud and rockin' (Billy Gibbons, ZZ Top)
n°1844274
___alt
Posté le 28-01-2009 à 16:14:34  profilanswer
 

ENTERTAIN ME :fou:

Message cité 2 fois

---------------
TRIPS RIGHT BUNCH F SHUTTLE TOM AND JERRY RIGHT YELLOW
n°1844276
kadreg
profil: Utilisateur
Posté le 28-01-2009 à 16:16:43  profilanswer
 

http://hfr-rehost.net/preview/i40.tinypic.com/v62kcj.jpg


---------------
brisez les rêves des gens, il en restera toujours quelque chose...  -- laissez moi troller sur discu !
n°1844277
mareek
Et de 3 \o/
Posté le 28-01-2009 à 16:19:15  profilanswer
 

___alt a écrit :

ENTERTAIN ME :fou:


http://www.youtube.com/watch?v=kPQR-OsH0RQ


---------------
"I wonder if the internal negative pressure in self pumping toothpaste tubes is adjusted for different market altitudes." John Carmack
n°1844278
mIRROR
Chevreuillobolchévik
Posté le 28-01-2009 à 16:21:27  profilanswer
 

drasche a écrit :


Dans mon esprit c'est un ennemi de Superman :o


haha jle supporte pas j ai acheté deux supeman un hors série sexy dessiné par chépuki et celui ou il se fait remettre le slip a l endroit par apocalypse  [:aztechxx]


---------------
« The enemy is the gramophone mind, whether or not one agrees with the record that is being played at the moment. » — George Orwell
n°1844280
drasche
Posté le 28-01-2009 à 16:25:05  profilanswer
 

___alt a écrit :

ENTERTAIN ME :fou:


http://www.deezer.com/track/60033


---------------
Whichever format the fan may want to listen is fine with us – vinyl, wax cylinders, shellac, 8-track, iPod, cloud storage, cranial implants – just as long as it’s loud and rockin' (Billy Gibbons, ZZ Top)
n°1844281
uriel
blood pt.2
Posté le 28-01-2009 à 16:25:38  profilanswer
 

superman et apocalypse :??:
 
 ça fait un mec de chez DC et un de Marvel, y a pas eu beaucoup de crossover comme ça et je connais pas celui là, t'es sûr que c'est pas Hulk?

Message cité 1 fois

---------------
IVG en france
n°1844282
uriel
blood pt.2
Posté le 28-01-2009 à 16:25:47  profilanswer
 

[:sinking]


---------------
IVG en france
n°1844284
mareek
Et de 3 \o/
Posté le 28-01-2009 à 16:26:47  profilanswer
 

qqn a essayé gmail offline (à part dion) ?


---------------
"I wonder if the internal negative pressure in self pumping toothpaste tubes is adjusted for different market altitudes." John Carmack
n°1844285
uriel
blood pt.2
Posté le 28-01-2009 à 16:28:33  profilanswer
 

qui est offline regulierement ici?

Message cité 6 fois

---------------
IVG en france
n°1844286
skeye
Posté le 28-01-2009 à 16:29:17  profilanswer
 

uriel a écrit :

qui est offline regulierement ici?


:D :D :D


---------------
Can't buy what I want because it's free -
n°1844287
___alt
Posté le 28-01-2009 à 16:30:02  profilanswer
 

uriel a écrit :

qui est offline regulierement ici?


 
Touché.


---------------
TRIPS RIGHT BUNCH F SHUTTLE TOM AND JERRY RIGHT YELLOW
n°1844288
mareek
Et de 3 \o/
Posté le 28-01-2009 à 16:30:11  profilanswer
 

uriel a écrit :

qui est offline regulierement ici?


nraynaud quand son voisin coupe sa livebox et harko quand un arbre tombe sur sa ligne téléphone :o


---------------
"I wonder if the internal negative pressure in self pumping toothpaste tubes is adjusted for different market altitudes." John Carmack
n°1844289
Dion
Acceuil
Posté le 28-01-2009 à 16:30:36  profilanswer
 

uriel a écrit :

qui est offline regulierement ici?


Harko et les usagers du RER A


---------------
When it comes to business/legal topics, just assume almost everyone commenting has no idea what they’re taking about and have no background in these subjects because that’s how it really is. Harkonnen 8-> Elmoricq 8====>
n°1844293
Jubijub
Parce que je le VD bien
Posté le 28-01-2009 à 16:31:29  profilanswer
 

kadreg a écrit :

vous pouvez eviter de quoter, le proxy de thales explose sinon :o


 
il préfère de face ?
 


---------------
Jubi Photos : Flickr - 500px
n°1844299
mIRROR
Chevreuillobolchévik
Posté le 28-01-2009 à 16:54:00  profilanswer
 

uriel a écrit :

superman et apocalypse :??:
 
 ça fait un mec de chez DC et un de Marvel, y a pas eu beaucoup de crossover comme ça et je connais pas celui là, t'es sûr que c'est pas Hulk?


certain  
http://media.comicvine.com/uploads/0/2/80537-3816-68545-3-superman_super.jpg
1992 apparemment, c'est le dernier épisode avant son lifting

Message cité 2 fois

---------------
« The enemy is the gramophone mind, whether or not one agrees with the record that is being played at the moment. » — George Orwell
n°1844300
uriel
blood pt.2
Posté le 28-01-2009 à 16:55:36  profilanswer
 

mIRROR a écrit :


certain  
http://media.comicvine.com/uploads [...] _super.jpg
1992 apparemment, c'est le dernier épisode avant son lifting


[:romf] je connaissais pas, je vais regarder

Message cité 1 fois

---------------
IVG en france
n°1844301
Taiche
(╯°□°）╯︵ ┻━┻
Posté le 28-01-2009 à 16:56:25  profilanswer
 

uriel a écrit :

qui est offline regulierement ici?


1 Point Ramasse Tes Dents [:arcueid brunestud]


---------------
Everyone thinks of changing the world, but no one thinks of changing himself  |  It is the peculiar quality of a fool to perceive the faults of others and to forget his own  |  Early clumsiness is not a verdict, it’s an essential ingredient.
n°1844302
drasche
Posté le 28-01-2009 à 16:59:04  profilanswer
 

mIRROR a écrit :

certain  
http://media.comicvine.com/uploads [...] _super.jpg
1992 apparemment, c'est le dernier épisode avant son lifting


Je crois que tu parles de Doomsday :o Sur wikipedia FR, je vois que le nom est resté identique à la traduction en FR, tandis que Apocalypse est un perso de la série X-Men dont le nom de change pas non plus de l'anglais au français :o

Message cité 2 fois

---------------
Whichever format the fan may want to listen is fine with us – vinyl, wax cylinders, shellac, 8-track, iPod, cloud storage, cranial implants – just as long as it’s loud and rockin' (Billy Gibbons, ZZ Top)
mood
Publicité
Posté le   profilanswer
 

 Page :   1  2  3  4  5  ..  15555  15556  15557  ..  27007  27008  27009  27010  27011  27012
Page Suivante
Page Précédente
Haut de page 

Aller à :
Ajouter une réponse
 

Sujets relatifs
Plus de sujets relatifs à : [blabla@olympe] Le topic du modo, dieu de la fibre et du monde

Forum MesDiscussions.Net, Version 2010.2
(c) 2000-2011 Doctissimo
Page générée en 0.424 secondes

Copyright © 1997-2025 Groupe LDLC (Signaler un contenu illicite / Données personnelles)