1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| SQL> with cte_jr_manuel as
commande inconnue début "with cte_j..." - reste de la ligne ignoré.
SQL> (
2 select rownum as rn, jr_manuel
3 from jr_caisse
4 where jr_manuel > 0
5 )
6 , cte_jr_mecano as
7 (
8 select rownum as rn, jr_mecano
9 from jr_caisse
10 where jr_mecano > 0
11 )
12 select ma.jr_manuel
13 , me.jr_mecano
14 from cte_jr_manuel ma
15 full join cte_jr_mecano me on me.rn = ma.rn;
, cte_jr_mecano as
*
ERROR à la ligne 6 :
ORA-00933: la commande SQL ne se termine pas correctement |
Partager