Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 6 | Andrea | 1 | LOAD DATA |
| 2 | INFILE * |
||
| 3 | INSERT INTO TABLE S3_AA03G_REGIONI |
||
| 4 | Fields terminated by ";" Optionally enclosed by '"' |
||
| 5 | ( |
||
| 6 | AA03_COD_REG_ISTAT, |
||
| 7 | AA03_NOME |
||
| 8 | ) |
||
| 9 | BEGINDATA |
||
| 10 | "02";"VALLE D'AOSTA" |
||
| 11 | "03";"LOMBARDIA" |
||
| 12 | "04";"TRENTINO ALTO ADIGE" |
||
| 13 | "05";"VENETO" |
||
| 14 | "06";"FRIULI VENEZIA GIULIA" |
||
| 15 | "07";"LIGURIA" |
||
| 16 | "08";"EMILIA-ROMAGNA" |
||
| 17 | "09";"TOSCANA" |
||
| 18 | "10";"UMBRIA" |
||
| 19 | "11";"MARCHE" |
||
| 20 | "12";"LAZIO" |
||
| 21 | "13";"ABRUZZO" |
||
| 22 | "14";"MOLISE" |
||
| 23 | "15";"CAMPANIA" |
||
| 24 | "16";"PUGLIA" |
||
| 25 | "17";"BASILICATA" |
||
| 26 | "18";"CALABRIA" |
||
| 27 | "19";"SICILIA" |
||
| 28 | "20";"SARDEGNA" |
||
| 29 | "00";"FITTIZIA" |
||
| 30 | "01";"PIEMONTE" |