SQL> clear scr SQL> SELECT * from pokemon 2 where name LIKE '%chu' 3 ; POKEDEXID NAME ---------- -------------------- 25 Pikachu 26 Raichu 172 Pichu 1000 CS365chu SQL> SELECT * from pokemon 2 where name LIKE 'P%c%'; POKEDEXID NAME ---------- -------------------- 25 Pikachu 47 Parasect 54 Psyduck 172 Pichu 204 Pineco 261 Poochyena 417 Pachirisu 7 rows selected. SQL> select table_name from user_tables; TABLE_NAME ------------------------------ HEAVY LEAGUES ATTENDANCE BEERS BARS ALLELES PNEXT SPECIES ATTRIBUTES TYPES ANEW TABLE_NAME ------------------------------ POKEMON EVOLUTION REACTORS DRAGONS EARTHQUAKES LOCATION EMPLOYEE BIGQUAKES COMBO TOURNAMENT EMPLOYEES TABLE_NAME ------------------------------ TALL TOP100 24 rows selected. SQL> select * from top100; POKEDEXID NAME ---------- -------------------- 1 Bulbasaur 2 Ivysaur 3 Venusaur 4 Charmander 5 Charmeleon 6 Charizard 7 Squirtle 8 Wartortle 9 Blastoise 10 Caterpie 11 Metapod POKEDEXID NAME ---------- -------------------- 12 Butterfree 13 Weedle 14 Kakuna 15 Beedrill 16 Pidgey 17 Pidgeotto 18 Pidgeot 19 Rattata 20 Raticate 21 Spearow 22 Fearow POKEDEXID NAME ---------- -------------------- 23 Ekans 24 Arbok 25 Pikachu 26 Raichu 27 Sandshrew 28 Sandslash 29 Nidoran??? 30 Nidorina 31 Nidoqueen 33 Nidorino 34 Nidoking POKEDEXID NAME ---------- -------------------- 35 Clefairy 36 Clefable 37 Vulpix 38 Ninetales 39 Jigglypuff 40 Wigglytuff 41 Zubat 42 Golbat 43 Oddish 44 Gloom 45 Vileplume POKEDEXID NAME ---------- -------------------- 46 Paras 47 Parasect 48 Venonat 49 Venomoth 50 Diglett 51 Dugtrio 52 Meowth 53 Persian 54 Psyduck 55 Golduck 56 Mankey POKEDEXID NAME ---------- -------------------- 57 Primeape 58 Growlithe 59 Arcanine 60 Poliwag 61 Poliwhirl 62 Poliwrath 63 Abra 64 Kadabra 65 Alakazam 66 Machop 67 Machoke POKEDEXID NAME ---------- -------------------- 68 Machamp 69 Bellsprout 70 Weepinbell 71 Victreebel 72 Tentacool 73 Tentacruel 74 Geodude 75 Graveler 76 Golem 77 Ponyta 78 Rapidash POKEDEXID NAME ---------- -------------------- 79 Slowpoke 80 Slowbro 81 Magnemite 82 Magneton 84 Doduo 85 Dodrio 86 Seel 87 Dewgong 88 Grimer 89 Muk 90 Shellder POKEDEXID NAME ---------- -------------------- 91 Cloyster 92 Gastly 93 Haunter 94 Gengar 95 Onix 96 Drowzee 97 Hypno 98 Krabby 99 Kingler 100 Voltorb 98 rows selected. SQL> select * from tall; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon 16 rows selected. SQL> select * from heavy; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arceus Alpha normal Snorlax Sleeping normal Hariyama Arm Thrust fighting Groudon Continent ground Hippowdon Heavyweight ground Rhyperior Drill ground Golurk Automaton ground Golem Megaton rock Probopass Compass rock Gigalith Compressed rock NAME GENUS TYPE -------------------- -------------------- -------------------- Terrakion Cavern rock Giratina Renegade ghost Steelix Iron Snake steel Aggron Iron Armor steel Metagross Iron Leg steel Dialga Temporal steel Cobalion Iron Will steel Heatran Lava Dome fire Kyogre Sea Basin water Palkia Spatial water Wailord Float Whale water NAME GENUS TYPE -------------------- -------------------- -------------------- Torterra Continent grass Glalie Face ice Mamoswine Twin Tusk ice Beartic Freezing ice Reshiram Vast White dragon Zekrom Deep Black dragon Kyurem Boundary dragon 29 rows selected. SQL> (select * from tall) 2 MINUS 3 (select * from heavy) 4 ; NAME GENUS TYPE -------------------- -------------------- -------------------- Arbok Cobra poison Dragonair Dragon dragon Gyarados Atrocious water Ho-Oh Rainbow fire Lugia Diving psychic Milotic Tender water Onix Rock Snake rock Rayquaza Sky High dragon 8 rows selected. SQL> SQL> (select * from tall) 2 MINUS 3 ( 4 select * from heavy) 5 order by type 6 ; order by type * ERROR at line 5: ORA-00904: "TYPE": invalid identifier SQL> (select * from tall 2 order by type) 3 MINUS 4 ( 5 select * from heavy) 6 ; order by type) * ERROR at line 2: ORA-00907: missing right parenthesis SQL> SQL> (select * from tall 2 ) 3 MINUS 4 ( 5 select * from heavy) 6 order by 3 7 ; NAME GENUS TYPE -------------------- -------------------- -------------------- Dragonair Dragon dragon Rayquaza Sky High dragon Ho-Oh Rainbow fire Arbok Cobra poison Lugia Diving psychic Onix Rock Snake rock Gyarados Atrocious water Milotic Tender water 8 rows selected. SQL> select * from heavy 2 order by 1; NAME GENUS TYPE -------------------- -------------------- -------------------- Aggron Iron Armor steel Arceus Alpha normal Beartic Freezing ice Cobalion Iron Will steel Dialga Temporal steel Gigalith Compressed rock Giratina Renegade ghost Glalie Face ice Golem Megaton rock Golurk Automaton ground Groudon Continent ground NAME GENUS TYPE -------------------- -------------------- -------------------- Hariyama Arm Thrust fighting Heatran Lava Dome fire Hippowdon Heavyweight ground Kyogre Sea Basin water Kyurem Boundary dragon Mamoswine Twin Tusk ice Metagross Iron Leg steel Palkia Spatial water Probopass Compass rock Regigigas Colossal normal Reshiram Vast White dragon NAME GENUS TYPE -------------------- -------------------- -------------------- Rhyperior Drill ground Snorlax Sleeping normal Steelix Iron Snake steel Terrakion Cavern rock Torterra Continent grass Wailord Float Whale water Zekrom Deep Black dragon 29 rows selected. SQL> select * from tall order by 2; NAME GENUS TYPE -------------------- -------------------- -------------------- Gyarados Atrocious water Arbok Cobra poison Regigigas Colossal normal Groudon Continent ground Lugia Diving psychic Dragonair Dragon dragon Wailord Float Whale water Steelix Iron Snake steel Ho-Oh Rainbow fire Giratina Renegade ghost Onix Rock Snake rock NAME GENUS TYPE -------------------- -------------------- -------------------- Kyogre Sea Basin water Rayquaza Sky High dragon Palkia Spatial water Dialga Temporal steel Milotic Tender water 16 rows selected. SQL> select * from tall order by 3,1; NAME GENUS TYPE -------------------- -------------------- -------------------- Dragonair Dragon dragon Rayquaza Sky High dragon Ho-Oh Rainbow fire Giratina Renegade ghost Groudon Continent ground Regigigas Colossal normal Arbok Cobra poison Lugia Diving psychic Onix Rock Snake rock Dialga Temporal steel Steelix Iron Snake steel NAME GENUS TYPE -------------------- -------------------- -------------------- Gyarados Atrocious water Kyogre Sea Basin water Milotic Tender water Palkia Spatial water Wailord Float Whale water 16 rows selected. SQL> SQL> (select name as MYNAME from tall 2 ) 3 MINUS 4 ( 5 select name as MYNAME from heavy) 6 order by MYNAME 7 ; MYNAME -------------------- Arbok Dragonair Gyarados Ho-Oh Lugia Milotic Onix Rayquaza 8 rows selected. SQL> SQL> (select name as MYNAME from tall 2 ) 3 MINUS 4 ( 5 select name from heavy) 6 order by MYNAME 7 ; MYNAME -------------------- Arbok Dragonair Gyarados Ho-Oh Lugia Milotic Onix Rayquaza 8 rows selected. SQL> select * from tall; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon 16 rows selected. SQL> update tall set type = 'firewater' where type = 'water'; 5 rows updated. SQL> select *from tall; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin firewater Palkia Spatial firewater Gyarados Atrocious firewater NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale firewater Milotic Tender firewater Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon 16 rows selected. SQL> select * from tall; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin firewater Palkia Spatial firewater Gyarados Atrocious firewater NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale firewater Milotic Tender firewater Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon 16 rows selected. SQL> delete from heavy where genus LIKE 2 'Sea %'; delete from heavy where genus LIKE * ERROR at line 1: ORA-00060: deadlock detected while waiting for resource SQL> select *from heavy; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arceus Alpha normal Snorlax Sleeping normal Hariyama Arm Thrust fighting Groudon Continent ground Hippowdon Heavyweight ground Rhyperior Drill ground Golurk Automaton ground Golem Megaton rock Probopass Compass rock Gigalith Compressed rock NAME GENUS TYPE -------------------- -------------------- -------------------- Terrakion Cavern rock Giratina Renegade ghost Steelix Iron Snake steel Aggron Iron Armor steel Metagross Iron Leg steel Dialga Temporal steel Cobalion Iron Will steel Heatran Lava Dome fire Kyogre Sea Basin water Palkia Spatial water Wailord Float Whale water NAME GENUS TYPE -------------------- -------------------- -------------------- Torterra Continent grass Glalie Face ice Mamoswine Twin Tusk ice Beartic Freezing ice Reshiram Vast White dragon Zekrom Deep Black dragon Kyurem Boundary dragon 29 rows selected. SQL> update heavy set type = 'ice cream' where type = 'ice'; 3 rows updated. SQL> select * from heavy; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arceus Alpha normal Snorlax Sleeping normal Hariyama Arm Thrust fighting Groudon Continent ground Hippowdon Heavyweight ground Rhyperior Drill ground Golurk Automaton ground Golem Megaton rock Probopass Compass rock Gigalith Compressed rock NAME GENUS TYPE -------------------- -------------------- -------------------- Terrakion Cavern rock Giratina Renegade ghost Steelix Iron Snake steel Aggron Iron Armor steel Metagross Iron Leg steel Dialga Temporal steel Cobalion Iron Will steel Heatran Lava Dome fire Kyogre Sea Basin water Palkia Spatial water Wailord Float Whale water NAME GENUS TYPE -------------------- -------------------- -------------------- Torterra Continent grass Glalie Face ice cream Mamoswine Twin Tusk ice cream Beartic Freezing ice cream Reshiram Vast White dragon Zekrom Deep Black dragon Kyurem Boundary dragon 29 rows selected. SQL> run 1* select * from heavy NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arceus Alpha normal Snorlax Sleeping normal Hariyama Arm Thrust fighting Groudon Continent ground Hippowdon Heavyweight ground Rhyperior Drill ground Golurk Automaton ground Golem Megaton rock Probopass Compass rock Gigalith Compressed rock NAME GENUS TYPE -------------------- -------------------- -------------------- Terrakion Cavern rock Giratina Renegade ghost Steelix Iron Snake steel Aggron Iron Armor steel Metagross Iron Leg steel Dialga Temporal steel Cobalion Iron Will steel Heatran Lava Dome fire Kyogre Sea Basin waterfowl Palkia Spatial waterfowl Wailord Float Whale waterfowl NAME GENUS TYPE -------------------- -------------------- -------------------- Torterra Continent grass Glalie Face ice cream Mamoswine Twin Tusk ice cream Beartic Freezing ice cream Reshiram Vast White dragon Zekrom Deep Black dragon Kyurem Boundary dragon 29 rows selected. SQL> delete from heavy; 29 rows deleted. SQL> select * from heavy; no rows selected SQL> rollback; Rollback complete. SQL> select * from heavy; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arceus Alpha normal Snorlax Sleeping normal Hariyama Arm Thrust fighting Groudon Continent ground Hippowdon Heavyweight ground Rhyperior Drill ground Golurk Automaton ground Golem Megaton rock Probopass Compass rock Gigalith Compressed rock NAME GENUS TYPE -------------------- -------------------- -------------------- Terrakion Cavern rock Giratina Renegade ghost Steelix Iron Snake steel Aggron Iron Armor steel Metagross Iron Leg steel Dialga Temporal steel Cobalion Iron Will steel Heatran Lava Dome fire Kyogre Sea Basin waterfowl Palkia Spatial waterfowl Wailord Float Whale waterfowl NAME GENUS TYPE -------------------- -------------------- -------------------- Torterra Continent grass Glalie Face ice Mamoswine Twin Tusk ice Beartic Freezing ice Reshiram Vast White dragon Zekrom Deep Black dragon Kyurem Boundary dragon 29 rows selected. SQL> select * from tall; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon 16 rows selected. SQL> insert into tall values ('Kobe Bryant', 'Athlete', 'baller'); 1 row created. SQL> insert into tall(Name) values('Shaq'); 1 row created. SQL> select * from tall; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon Kobe Bryant Athlete baller Shaq 18 rows selected. SQL> set NULL NULL SQL> run 1* select * from tall NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon Kobe Bryant Athlete baller Shaq NULL NULL 18 rows selected. SQL> select * from tall where genus = 'Tender'; NAME GENUS TYPE -------------------- -------------------- -------------------- Milotic Tender water SQL> select * from tall where genus = NULL; no rows selected SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> select * from tall where 1 = 2-1; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon Kobe Bryant Athlete baller Shaq NULL NULL 18 rows selected. SQL> select * from tall where NULL = NULL; no rows selected SQL> select * from tall where NULL <> NULL; no rows selected SQL> SQL> SQL> SQL> SQL> SQL> insert into tall(name) values('Tollachu'); 1 row created. SQL> select * from tall; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon Kobe Bryant Athlete baller Shaq NULL NULL Tollachu NULL NULL 19 rows selected. SQL> select * from tall where genus IS NULL; NAME GENUS TYPE -------------------- -------------------- -------------------- Shaq NULL NULL Tollachu NULL NULL SQL> select * from tall where genus is NOT Null; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon Kobe Bryant Athlete baller 17 rows selected. SQL> select * from pokemon where name = 'Snorelax'; no rows selected SQL> select * from pokemon where name = 'Snorlax'; POKEDEXID NAME ---------- -------------------- 143 Snorlax SQL> SQL> SELECT p2.name, a2.height, a1.height 2 FROM Pokemon p1, Attributes a1, 3 Pokemon p2, Attributes a2 4 WHERE p1.Name = 'Snorlax' and 5 p1.pokedexid = a1.pokedexid and 6 a2.height > a1.height and 7 a2.pokedexid = p2.pokedexid 8 ; NAME HEIGHT HEIGHT -------------------- ---------- ---------- Arbok 35 21 Onix 88 21 Kangaskhan 22 21 Gyarados 65 21 Lapras 25 21 Dragonair 40 21 Dragonite 22 21 Feraligatr 23 21 Steelix 92 21 Lugia 52 21 Ho-Oh 38 21 NAME HEIGHT HEIGHT -------------------- ---------- ---------- Hariyama 23 21 Wailord 145 21 Seviper 27 21 Milotic 62 21 Kyogre 45 21 Groudon 35 21 Rayquaza 70 21 Torterra 22 21 Abomasnow 22 21 Rhyperior 24 21 Mamoswine 25 21 NAME HEIGHT HEIGHT -------------------- ---------- ---------- Dusknoir 22 21 Dialga 54 21 Palkia 42 21 Regigigas 37 21 Giratina 45 21 Arceus 32 21 Serperior 33 21 Scolipede 25 21 Jellicent 22 21 Beartic 26 21 Golurk 28 21 NAME HEIGHT HEIGHT -------------------- ---------- ---------- Reshiram 32 21 Zekrom 29 21 Kyurem 30 21 36 rows selected. SQL> select * from tall; NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon Kobe Bryant Athlete baller Shaq NULL NULL Tollachu NULL NULL 19 rows selected. SQL> set feedback 0 SQL> run 1* select * from tall NAME GENUS TYPE -------------------- -------------------- -------------------- Regigigas Colossal normal Arbok Cobra poison Groudon Continent ground Onix Rock Snake rock Giratina Renegade ghost Steelix Iron Snake steel Dialga Temporal steel Ho-Oh Rainbow fire Kyogre Sea Basin water Palkia Spatial water Gyarados Atrocious water NAME GENUS TYPE -------------------- -------------------- -------------------- Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon Kobe Bryant Athlete baller Shaq NULL NULL Tollachu NULL NULL SQL> clear scvr SP2-0158: unknown CLEAR option "scvr" SQL> clear scr SQL> select count(*) 2 from tall; COUNT(*) ---------- 19 SQL> select count(*) as 'TALL POKEMON' 2 from tall; select count(*) as 'TALL POKEMON' * ERROR at line 1: ORA-00923: FROM keyword not found where expected SQL> select count(*) as "TALL Pokemon" 2 from tall; TALL Pokemon ------------ 19 SQL> clear scr SQL> select name, count(*) from tall; select name, count(*) from tall * ERROR at line 1: ORA-00937: not a single-group group function SQL> select * from attributes; POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 1 7 69 64 2 10 130 141 3 20 1000 208 4 6 85 65 5 11 190 142 6 17 905 209 7 5 90 66 8 10 225 143 9 16 855 210 10 3 29 53 11 7 99 72 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 12 11 320 160 13 3 32 52 14 6 100 71 15 10 295 159 16 3 18 55 17 11 300 113 18 15 395 172 19 3 35 57 20 7 185 116 21 3 20 58 22 12 380 162 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 23 20 69 62 24 35 650 147 25 4 60 82 26 8 300 122 27 6 120 93 28 10 295 163 29 4 70 59 30 8 200 117 31 13 600 194 33 9 195 118 34 14 620 195 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 35 6 75 68 36 13 400 129 37 6 99 63 38 11 199 178 39 5 55 76 40 10 120 109 41 8 75 54 42 16 550 171 43 5 54 78 44 8 86 132 45 12 186 184 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 46 3 54 70 47 10 295 128 48 10 300 75 49 15 125 138 50 2 8 81 51 7 333 153 52 4 42 69 53 10 320 148 54 8 196 80 55 17 766 174 56 5 280 74 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 57 10 320 149 58 7 190 91 59 19 1550 213 60 6 124 77 61 10 200 131 62 13 540 185 63 9 195 75 64 13 565 145 65 15 480 186 66 8 195 75 67 15 705 146 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 68 16 1300 193 69 7 40 84 70 10 64 151 71 17 155 191 72 9 455 105 73 16 550 205 74 4 200 73 75 10 1050 134 76 14 3000 177 77 10 300 152 78 17 950 192 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 79 12 360 99 80 16 785 164 81 3 60 89 82 10 600 161 84 14 392 96 85 18 852 158 86 11 900 100 87 17 1200 176 88 9 300 90 89 12 300 157 90 3 40 97 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 91 15 1325 203 92 13 1 95 93 16 1 126 94 15 405 190 95 88 2100 108 96 10 324 102 97 16 756 165 98 4 65 115 99 13 600 206 100 5 104 103 101 12 666 150 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 102 4 25 98 103 20 1200 212 104 4 65 87 105 10 450 124 106 15 498 139 107 14 502 140 108 12 655 127 109 6 10 114 110 12 95 173 111 10 1150 135 112 19 1200 204 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 113 11 346 255 114 10 350 166 115 22 800 175 116 4 80 83 117 12 250 155 118 6 150 111 119 13 390 170 120 8 345 106 121 11 800 207 122 13 545 136 123 15 560 187 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 124 14 406 137 125 11 300 156 126 13 445 167 127 15 550 200 128 14 884 211 129 9 100 20 130 65 2350 214 131 25 2200 219 132 3 40 61 133 3 65 92 134 10 290 196 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 135 8 245 197 136 9 250 198 137 8 365 130 138 4 75 99 139 10 350 199 140 5 115 99 141 13 405 199 142 18 590 202 143 21 4600 154 144 17 554 215 145 16 526 216 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 146 20 600 217 147 18 33 67 148 40 165 144 149 22 2100 218 150 20 1220 220 151 4 40 64 152 9 64 64 153 12 158 141 154 18 1005 208 155 5 79 65 156 9 190 142 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 157 17 795 209 158 6 95 66 159 11 250 143 160 23 888 210 161 8 60 57 162 18 325 116 163 7 212 58 164 16 408 162 165 10 108 54 166 14 356 134 167 5 85 54 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 168 11 335 134 169 18 750 204 170 5 120 90 171 12 225 156 172 3 20 42 173 3 30 37 174 3 10 39 175 3 15 74 176 6 32 114 177 2 20 73 178 15 150 171 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 179 6 78 59 180 8 133 117 181 14 615 194 182 4 58 184 183 4 85 58 184 8 285 153 185 12 380 135 186 11 339 185 187 4 5 74 188 6 10 136 189 8 30 176 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 190 8 115 94 191 3 18 52 192 8 85 146 193 12 380 147 194 4 85 52 195 14 750 137 196 9 265 197 197 10 270 197 198 5 21 107 199 20 795 164 200 7 10 147 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 201 5 50 61 202 13 285 177 203 15 415 149 204 6 72 60 205 12 1258 118 206 15 140 125 207 11 648 108 208 92 4000 196 209 6 78 63 210 14 487 178 211 5 39 100 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 212 18 1180 200 213 6 205 80 214 15 540 200 215 9 280 132 216 6 88 124 217 18 1258 189 218 7 350 78 219 8 550 154 220 4 65 78 221 11 558 160 222 6 50 113 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 223 6 120 78 224 9 285 164 225 9 160 183 226 21 2200 168 227 17 505 168 228 6 108 114 229 14 350 204 230 18 1520 207 231 5 335 124 232 11 1200 189 233 6 325 180 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 234 14 712 165 235 12 580 106 236 7 210 91 237 14 480 138 238 4 60 87 239 6 235 106 240 7 214 117 241 12 755 200 242 15 468 255 243 19 1780 216 244 21 1980 217 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 245 20 1870 215 246 6 720 67 247 12 1520 144 248 20 2020 218 249 52 2160 220 250 38 1990 220 251 6 50 64 252 5 50 65 253 9 216 141 254 17 522 208 255 4 25 65 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 256 9 195 142 257 19 520 209 258 4 76 65 259 7 280 143 260 15 819 210 261 5 136 55 262 10 370 128 263 4 175 60 264 5 325 128 265 3 36 54 266 6 100 72 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 267 10 284 161 268 7 115 72 269 12 316 161 270 5 26 74 271 12 325 141 272 15 550 181 273 5 40 74 274 10 280 141 275 13 596 181 276 3 23 59 277 7 198 162 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 278 6 95 64 279 12 280 164 280 4 66 70 281 8 202 140 282 16 484 208 283 5 17 63 284 8 36 128 285 4 45 65 286 12 392 165 287 8 240 83 288 14 465 126 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 289 20 1305 210 290 5 55 65 291 8 120 155 292 8 12 95 293 6 163 68 294 10 405 126 295 15 840 184 296 10 864 87 297 23 2538 184 298 2 20 33 299 10 970 108 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 300 6 110 65 301 11 326 138 302 5 110 98 303 6 115 98 304 4 600 96 305 9 1200 152 306 21 3600 205 307 6 112 91 308 13 315 153 309 6 152 104 310 15 402 168 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 311 4 42 120 312 4 42 120 313 7 177 146 314 6 177 146 315 3 20 152 316 4 103 75 317 17 800 168 318 8 208 88 319 18 888 175 320 20 1300 137 321 145 3980 206 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 322 7 240 88 323 19 2200 175 324 5 804 161 325 7 306 89 326 9 715 164 327 11 50 85 328 7 150 73 329 11 153 126 330 20 820 197 331 4 513 97 332 13 774 177 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 333 4 12 74 334 11 206 188 335 13 403 165 336 27 525 165 337 10 1680 150 338 12 1540 150 339 4 19 92 340 9 236 158 341 6 115 111 342 11 328 161 343 5 215 58 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 344 15 1080 189 345 10 238 99 346 15 604 199 347 7 125 99 348 15 682 199 349 6 74 61 350 62 1620 213 351 3 8 145 352 10 220 132 353 6 23 97 354 11 125 179 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 355 8 150 97 356 16 306 179 357 20 1000 169 358 6 10 147 359 12 470 174 360 6 140 44 361 7 168 74 362 15 2565 187 363 8 395 75 364 11 876 128 365 14 1506 192 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 366 4 525 142 367 17 270 178 368 18 226 178 369 10 234 198 370 6 87 110 371 6 421 89 372 11 1105 144 373 15 1026 218 374 6 952 103 375 12 2025 153 376 16 5500 210 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 377 17 2300 217 378 18 1750 216 379 19 2050 215 380 14 400 211 381 20 600 211 382 45 3520 218 383 35 9500 218 384 70 2065 220 385 3 11 215 386 17 608 215 387 4 102 64 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 388 11 970 141 389 22 3100 208 390 5 62 65 391 9 220 142 392 12 550 209 393 4 52 66 394 8 230 143 395 17 845 210 396 3 20 56 397 6 155 113 398 12 249 172 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 399 5 200 58 400 10 315 116 401 3 22 54 402 10 255 159 403 5 95 60 404 9 305 117 405 14 420 194 406 2 12 68 407 9 145 204 408 9 315 99 409 16 1025 199 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 410 5 570 99 411 13 1495 199 412 2 34 61 413 5 65 159 414 9 233 159 415 3 55 63 416 12 385 188 417 4 39 120 418 7 295 75 419 11 335 178 420 4 33 68 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 421 5 93 133 422 3 63 73 423 9 299 176 424 12 203 186 425 4 12 127 426 12 150 204 427 4 55 84 428 12 333 178 429 9 44 187 430 9 273 187 431 5 39 71 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 432 10 438 183 433 2 6 74 434 4 192 79 435 10 380 209 436 5 605 72 437 13 1870 188 438 5 150 68 439 6 130 78 440 6 244 255 441 5 19 107 442 10 1080 168 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 443 7 205 67 444 14 560 144 445 19 950 218 446 6 1050 94 447 7 202 72 448 12 540 204 449 8 495 95 450 20 3000 198 451 8 120 114 452 13 615 204 453 7 230 83 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 454 13 444 181 455 14 270 164 456 4 70 90 457 12 240 156 458 10 650 108 459 10 505 131 460 22 1355 214 461 11 340 199 462 12 1800 211 463 17 1400 193 464 24 2828 217 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 465 20 1286 211 466 18 1386 199 467 16 680 199 468 15 380 220 469 19 515 198 470 10 255 196 471 8 259 196 472 20 425 192 473 25 2910 207 474 9 340 185 475 16 520 208 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 476 14 3400 198 477 22 1066 210 478 13 266 187 479 3 3 132 480 3 3 210 481 3 3 210 482 3 3 210 483 54 6830 220 484 42 3360 220 485 17 4300 215 486 37 4200 220 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 487 45 7500 220 488 15 856 210 489 4 31 165 490 3 14 215 491 15 505 210 492 2 21 64 493 32 3200 255 494 4 40 270 495 6 81 28 496 8 160 145 497 33 630 238 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 498 5 99 28 499 10 555 146 500 16 1500 238 501 5 59 28 502 8 245 145 503 15 946 238 504 5 116 51 505 11 270 147 506 4 41 55 507 9 147 130 508 12 610 221 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 509 4 101 56 510 11 375 156 511 6 105 63 512 11 305 174 513 6 110 63 514 10 280 174 515 6 135 63 516 10 290 174 517 6 233 58 518 11 605 170 519 3 21 53 POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 520 6 150 125 521 12 290 215 522 8 298 59 523 16 795 174 524 4 180 56 525 9 1020 137 526 17 2600 227