SQL> set linesize 150 SQL> set pagesize 25 SQL> select table_name from user_tables; TABLE_NAME ------------------------------ LEAGUES ATTENDANCE BEERS BARS ALLELES PNEXT SPECIES ATTRIBUTES TYPES ANEW POKEMON EVOLUTION REACTORS EARTHQUAKES LOCATION EMPLOYEE BIGQUAKES TOURNAMENT EMPLOYEES 19 rows selected. SQL> select * from pokemon; POKEDEXID NAME ---------- -------------------- 1 Bulbasaur 2 Ivysaur 3 Venusaur 4 Charmander 5 Charmeleon 6 Charizard 7 Squirtle 8 Wartortle 9 Blastoise 10 Caterpie 11 Metapod 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 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 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 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 101 Electrode 102 Exeggcute 103 Exeggutor 104 Cubone 105 Marowak 106 Hitmonlee 107 Hitmonchan 108 Lickitung 109 Koffing 110 Weezing 111 Rhyhorn 112 Rhydon POKEDEXID NAME ---------- -------------------- 113 Chansey 114 Tangela 115 Kangaskhan 116 Horsea 117 Seadra 118 Goldeen 119 Seaking 120 Staryu 121 Starmie 122 Mr. Mime 123 Scyther 124 Jynx 125 Electabuzz 126 Magmar 127 Pinsir 128 Tauros 129 Magikarp 130 Gyarados 131 Lapras 132 Ditto 133 Eevee 134 Vaporeon POKEDEXID NAME ---------- -------------------- 135 Jolteon 136 Flareon 137 Porygon 138 Omanyte 139 Omastar 140 Kabuto 141 Kabutops 142 Aerodactyl 143 Snorlax 144 Articuno 145 Zapdos 146 Moltres 147 Dratini 148 Dragonair 149 Dragonite 150 Mewtwo 151 Mew 152 Chikorita 153 Bayleef 154 Meganium 155 Cyndaquil 156 Quilava POKEDEXID NAME ---------- -------------------- 157 Typhlosion 158 Totodile 159 Croconaw 160 Feraligatr 161 Sentret 162 Furret 163 Hoothoot 164 Noctowl 165 Ledyba 166 Ledian 167 Spinarak 168 Ariados 169 Crobat 170 Chinchou 171 Lanturn 172 Pichu 173 Cleffa 174 Igglybuff 175 Togepi 176 Togetic 177 Natu 178 Xatu POKEDEXID NAME ---------- -------------------- 179 Mareep 180 Flaaffy 181 Ampharos 182 Bellossom 183 Marill 184 Azumarill 185 Sudowoodo 186 Politoed 187 Hoppip 188 Skiploom 189 Jumpluff 190 Aipom 191 Sunkern 192 Sunflora 193 Yanma 194 Wooper 195 Quagsire 196 Espeon 197 Umbreon 198 Murkrow 199 Slowking 200 Misdreavus POKEDEXID NAME ---------- -------------------- 201 Unown 202 Wobbuffet 203 Girafarig 204 Pineco 205 Forretress 206 Dunsparce 207 Gligar 208 Steelix 209 Snubbull 210 Granbull 211 Qwilfish 212 Scizor 213 Shuckle 214 Heracross 215 Sneasel 216 Teddiursa 217 Ursaring 218 Slugma 219 Magcargo 220 Swinub 221 Piloswine 222 Corsola POKEDEXID NAME ---------- -------------------- 223 Remoraid 224 Octillery 225 Delibird 226 Mantine 227 Skarmory 228 Houndour 229 Houndoom 230 Kingdra 231 Phanpy 232 Donphan 233 Porygon2 234 Stantler 235 Smeargle 236 Tyrogue 237 Hitmontop 238 Smoochum 239 Elekid 240 Magby 241 Miltank 242 Blissey 243 Raikou 244 Entei POKEDEXID NAME ---------- -------------------- 245 Suicune 246 Larvitar 247 Pupitar 248 Tyranitar 249 Lugia 250 Ho-Oh 251 Celebi 252 Treecko 253 Grovyle 254 Sceptile 255 Torchic 256 Combusken 257 Blaziken 258 Mudkip 259 Marshtomp 260 Swampert 261 Poochyena 262 Mightyena 263 Zigzagoon 264 Linoone 265 Wurmple 266 Silcoon POKEDEXID NAME ---------- -------------------- 267 Beautifly 268 Cascoon 269 Dustox 270 Lotad 271 Lombre 272 Ludicolo 273 Seedot 274 Nuzleaf 275 Shiftry 276 Taillow 277 Swellow 278 Wingull 279 Pelipper 280 Ralts 281 Kirlia 282 Gardevoir 283 Surskit 284 Masquerain 285 Shroomish 286 Breloom 287 Slakoth 288 Vigoroth POKEDEXID NAME ---------- -------------------- 289 Slaking 290 Nincada 291 Ninjask 292 Shedinja 293 Whismur 294 Loudred 295 Exploud 296 Makuhita 297 Hariyama 298 Azurill 299 Nosepass 300 Skitty 301 Delcatty 302 Sableye 303 Mawile 304 Aron 305 Lairon 306 Aggron 307 Meditite 308 Medicham 309 Electrike 310 Manectric POKEDEXID NAME ---------- -------------------- 311 Plusle 312 Minun 313 Volbeat 314 Illumise 315 Roselia 316 Gulpin 317 Swalot 318 Carvanha 319 Sharpedo 320 Wailmer 321 Wailord 322 Numel 323 Camerupt 324 Torkoal 325 Spoink 326 Grumpig 327 Spinda 328 Trapinch 329 Vibrava 330 Flygon 331 Cacnea 332 Cacturne POKEDEXID NAME ---------- -------------------- 333 Swablu 334 Altaria 335 Zangoose 336 Seviper 337 Lunatone 338 Solrock 339 Barboach 340 Whiscash 341 Corphish 342 Crawdaunt 343 Baltoy 344 Claydol 345 Lileep 346 Cradily 347 Anorith 348 Armaldo 349 Feebas 350 Milotic 351 Castform 352 Kecleon 353 Shuppet 354 Banette POKEDEXID NAME ---------- -------------------- 355 Duskull 356 Dusclops 357 Tropius 358 Chimecho 359 Absol 360 Wynaut 361 Snorunt 362 Glalie 363 Spheal 364 Sealeo 365 Walrein 366 Clamperl 367 Huntail 368 Gorebyss 369 Relicanth 370 Luvdisc 371 Bagon 372 Shelgon 373 Salamence 374 Beldum 375 Metang 376 Metagross POKEDEXID NAME ---------- -------------------- 377 Regirock 378 Regice 379 Registeel 380 Latias 381 Latios 382 Kyogre 383 Groudon 384 Rayquaza 385 Jirachi 386 Deoxys 387 Turtwig 388 Grotle 389 Torterra 390 Chimchar 391 Monferno 392 Infernape 393 Piplup 394 Prinplup 395 Empoleon 396 Starly 397 Staravia 398 Staraptor POKEDEXID NAME ---------- -------------------- 399 Bidoof 400 Bibarel 401 Kricketot 402 Kricketune 403 Shinx 404 Luxio 405 Luxray 406 Budew 407 Roserade 408 Cranidos 409 Rampardos 410 Shieldon 411 Bastiodon 412 Burmy 413 Wormadam 414 Mothim 415 Combee 416 Vespiquen 417 Pachirisu 418 Buizel 419 Floatzel 420 Cherubi POKEDEXID NAME ---------- -------------------- 421 Cherrim 422 Shellos 423 Gastrodon 424 Ambipom 425 Drifloon 426 Drifblim 427 Buneary 428 Lopunny 429 Mismagius 430 Honchkrow 431 Glameow 432 Purugly 433 Chingling 434 Stunky 435 Skuntank 436 Bronzor 437 Bronzong 438 Bonsly 439 Mime Jr. 440 Happiny 441 Chatot 442 Spiritomb POKEDEXID NAME ---------- -------------------- 443 Gible 444 Gabite 445 Garchomp 446 Munchlax 447 Riolu 448 Lucario 449 Hippopotas 450 Hippowdon 451 Skorupi 452 Drapion 453 Croagunk 454 Toxicroak 455 Carnivine 456 Finneon 457 Lumineon 458 Mantyke 459 Snover 460 Abomasnow 461 Weavile 462 Magnezone 463 Lickilicky 464 Rhyperior POKEDEXID NAME ---------- -------------------- 465 Tangrowth 466 Electivire 467 Magmortar 468 Togekiss 469 Yanmega 470 Leafeon 471 Glaceon 472 Gliscor 473 Mamoswine 474 Porygon-Z 475 Gallade 476 Probopass 477 Dusknoir 478 Froslass 479 Rotom 480 Uxie 481 Mesprit 482 Azelf 483 Dialga 484 Palkia 485 Heatran 486 Regigigas POKEDEXID NAME ---------- -------------------- 487 Giratina 488 Cresselia 489 Phione 490 Manaphy 491 Darkrai 492 Shaymin 493 Arceus 494 Victini 495 Snivy 496 Servine 497 Serperior 498 Tepig 499 Pignite 500 Emboar 501 Oshawott 502 Dewott 503 Samurott 504 Patrat 505 Watchog 506 Lillipup 507 Herdier 508 Stoutland POKEDEXID NAME ---------- -------------------- 509 Purrloin 510 Liepard 511 Pansage 512 Simisage 513 Pansear 514 Simisear 515 Panpour 516 Simipour 517 Munna 518 Musharna 519 Pidove 520 Tranquill 521 Unfezant 522 Blitzle 523 Zebstrika 524 Roggenrola 525 Boldore 526 Gigalith 527 Woobat 528 Swoobat 529 Drilbur 530 Excadrill POKEDEXID NAME ---------- -------------------- 531 Audino 532 Timburr 533 Gurdurr 534 Conkeldurr 535 Tympole 536 Palpitoad 537 Seismitoad 538 Throh 539 Sawk 540 Sewaddle 541 Swadloon 542 Leavanny 543 Venipede 544 Whirlipede 545 Scolipede 546 Cottonee 547 Whimsicott 548 Petilil 549 Lilligant 550 Basculin 551 Sandile 552 Krokorok POKEDEXID NAME ---------- -------------------- 553 Krookodile 554 Darumaka 555 Darmanitan 556 Maractus 557 Dwebble 558 Crustle 559 Scraggy 560 Scrafty 561 Sigilyph 562 Yamask 563 Cofagrigus 564 Tirtouga 565 Carracosta 566 Archen 567 Archeops 568 Trubbish 569 Garbodor 570 Zorua 571 Zoroark 572 Minccino 573 Cinccino 574 Gothita POKEDEXID NAME ---------- -------------------- 575 Gothorita 576 Gothitelle 577 Solosis 578 Duosion 579 Reuniclus 580 Ducklett 581 Swanna 582 Vanillite 583 Vanillish 584 Vanilluxe 585 Deerling 586 Sawsbuck 587 Emolga 588 Karrablast 589 Escavalier 590 Foongus 591 Amoonguss 592 Frillish 593 Jellicent 594 Alomomola 595 Joltik 596 Galvantula POKEDEXID NAME ---------- -------------------- 597 Ferroseed 598 Ferrothorn 599 Klink 600 Klang 601 Klinklang 602 Tynamo 603 Eelektrik 604 Eelektross 605 Elgyem 606 Beheeyem 607 Litwick 608 Lampent 609 Chandelure 610 Axew 611 Fraxure 612 Haxorus 613 Cubchoo 614 Beartic 615 Cryogonal 616 Shelmet 617 Accelgor 618 Stunfisk POKEDEXID NAME ---------- -------------------- 619 Mienfoo 620 Mienshao 621 Druddigon 622 Golett 623 Golurk 624 Pawniard 625 Bisharp 626 Bouffalant 627 Rufflet 628 Braviary 629 Vullaby 630 Mandibuzz 631 Heatmor 632 Durant 633 Deino 634 Zweilous 635 Hydreigon 636 Larvesta 637 Volcarona 638 Cobalion 639 Terrakion 640 Virizion POKEDEXID NAME ---------- -------------------- 641 Tornadus 642 Thundurus 643 Reshiram 644 Zekrom 645 Landorus 646 Kyurem 647 Keldeo 648 Meloetta 649 Genesect 1001 CSC366Chu 1000 CS365chu 649 rows selected. SQL> select * from species; POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 1 12 Seed 2 12 Seed 3 12 Seed 4 10 Lizard 5 10 Flame 6 10 Flame 7 11 Tiny Turtle 8 11 Turtle 9 11 Shellfish 10 7 Worm 11 7 Cocoon 12 7 Butterfly 13 7 Hairy Bug 14 7 Cocoon 15 7 Poison Bee 16 1 Tiny Bird 17 1 Bird 18 1 Bird 19 1 Mouse 20 1 Mouse 21 1 Tiny Bird 22 1 Beak POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 23 4 Snake 24 4 Cobra 25 13 Mouse 26 13 Mouse 27 5 Mouse 28 5 Mouse 29 4 Poison Pin 30 4 Poison Pin 31 4 Drill 33 4 Poison Pin 34 4 Drill 35 1 Fairy 36 1 Fairy 37 10 Fox 38 10 Fox 39 1 Balloon 40 1 Balloon 41 4 Bat 42 4 Bat 43 12 Weed 44 12 Weed 45 12 Flower POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 46 7 Mushroom 47 7 Mushroom 48 7 Insect 49 7 Poison Moth 50 5 Mole 51 5 Mole 52 1 Scratch Cat 53 1 Classy Cat 54 11 Duck 55 11 Duck 56 2 Pig Monkey 57 2 Pig Monkey 58 10 Puppy 59 10 Legendary 60 11 Tadpole 61 11 Tadpole 62 11 Tadpole 63 14 Psi 64 14 Psi 65 14 Psi 66 2 Superpower 67 2 Superpower POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 68 2 Superpower 69 12 Flower 70 12 Flycatcher 71 12 Flycatcher 72 11 Jellyfish 73 11 Jellyfish 74 6 Rock 75 6 Rock 76 6 Megaton 77 10 Fire Horse 78 10 Fire Horse 79 11 Dopey 80 11 Hermit Crab 81 13 Magnet 82 13 Magnet 84 1 Twin Bird 85 1 Triple Bird 86 11 Sea Lion 87 11 Sea Lion 88 4 Sludge 89 4 Sludge 90 11 Bivalve POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 91 11 Bivalve 92 8 Gas 93 8 Gas 94 8 Shadow 95 6 Rock Snake 96 14 Hypnosis 97 14 Hypnosis 98 11 River Crab 99 11 Pincer 100 13 Ball 101 13 Ball 102 12 Egg 103 12 Coconut 104 5 Lonely 105 5 Bone Keeper 106 2 Kicking 107 2 Punching 108 1 Licking 109 4 Poison Gas 110 4 Poison Gas 111 5 Spikes 112 5 Drill POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 113 1 Egg 114 12 Vine 115 1 Parent 116 11 Dragon 117 11 Dragon 118 11 Goldfish 119 11 Goldfish 120 11 Star Shape 121 11 Mysterious 122 14 Barrier 123 7 Mantis 124 15 Human Shape 125 13 Electric 126 10 Spitfire 127 7 Stag Beetle 128 1 Wild Bull 129 11 Fish 130 11 Atrocious 131 11 Transport 132 1 Transform 133 1 Evolution 134 11 Bubble Jet POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 135 13 Lightning 136 10 Flame 137 1 Virtual 138 6 Spiral 139 6 Spiral 140 6 Shellfish 141 6 Shellfish 142 6 Fossil 143 1 Sleeping 144 15 Freeze 145 13 Electric 146 10 Flame 147 16 Dragon 148 16 Dragon 149 16 Dragon 150 14 Genetic 151 14 New Species 152 12 Leaf 153 12 Leaf 154 12 Herb 155 10 Fire Mouse 156 10 Volcano POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 157 10 Volcano 158 11 Big Jaw 159 11 Big Jaw 160 11 Big Jaw 161 1 Scout 162 1 Long Body 163 1 Owl 164 1 Owl 165 7 Five Star 166 7 Five Star 167 7 String Spit 168 7 Long Leg 169 4 Bat 170 11 Angler 171 11 Light 172 13 Tiny Mouse 173 1 Star Shape 174 1 Balloon 175 1 Spike Ball 176 1 Happiness 177 14 Tiny Bird 178 14 Mystic POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 179 13 Wool 180 13 Wool 181 13 Light 182 12 Flower 183 11 Aqua Mouse 184 11 Aqua Rabbit 185 6 Imitation 186 11 Frog 187 12 Cottonweed 188 12 Cottonweed 189 12 Cottonweed 190 1 Long Tail 191 12 Seed 192 12 Sun 193 7 Clear Wing 194 11 Water Fish 195 11 Water Fish 196 14 Sun 197 17 Moonlight 198 17 Darkness 199 11 Royal 200 8 Screech POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 201 14 Symbol 202 14 Patient 203 1 Long Neck 204 7 Bagworm 205 7 Bagworm 206 1 Land Snake 207 5 FlyScorpion 208 9 Iron Snake 209 1 Fairy 210 1 Fairy 211 11 Balloon 212 7 Pincer 213 7 Mold 214 7 Single Horn 215 17 Sharp Claw 216 1 Little Bear 217 1 Hibernator 218 10 Lava 219 10 Lava 220 15 Pig 221 15 Swine 222 11 Coral POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 223 11 Jet 224 11 Jet 225 15 Delivery 226 11 Kite 227 9 Armor Bird 228 17 Dark 229 17 Dark 230 11 Dragon 231 5 Long Nose 232 5 Armor 233 1 Virtual 234 1 Big Horn 235 1 Painter 236 2 Scuffle 237 2 Handstand 238 15 Kiss 239 13 Electric 240 10 Live Coal 241 1 Milk Cow 242 1 Happiness 243 13 Thunder 244 10 Volcano POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 245 11 Aurora 246 6 Rock Skin 247 6 Hard Shell 248 6 Armor 249 14 Diving 250 10 Rainbow 251 14 Time Travel 252 12 Wood Gecko 253 12 Wood Gecko 254 12 Forest 255 10 Chick 256 10 Young Fowl 257 10 Blaze 258 11 Mud Fish 259 11 Mud Fish 260 11 Mud Fish 261 17 Bite 262 17 Bite 263 1 TinyRaccoon 264 1 Rushing 265 7 Worm 266 7 Cocoon POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 267 7 Butterfly 268 7 Cocoon 269 7 Poison Moth 270 11 Water Weed 271 11 Jolly 272 11 Carefree 273 12 Acorn 274 12 Wily 275 12 Wicked 276 1 TinySwallow 277 1 Swallow 278 11 Seagull 279 11 Water Bird 280 14 Feeling 281 14 Emotion 282 14 Embrace 283 7 Pond Skater 284 7 Eyeball 285 12 Mushroom 286 12 Mushroom 287 1 Slacker 288 1 Wild Monkey POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 289 1 Lazy 290 7 Trainee 291 7 Ninja 292 7 Shed 293 1 Whisper 294 1 Big Voice 295 1 Loud Noise 296 2 Guts 297 2 Arm Thrust 298 1 Polka Dot 299 6 Compass 300 1 Kitten 301 1 Prim 302 17 Darkness 303 9 Deceiver 304 9 Iron Armor 305 9 Iron Armor 306 9 Iron Armor 307 2 Meditate 308 2 Meditate 309 13 Lightning 310 13 Discharge POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 311 13 Cheering 312 13 Cheering 313 7 Firefly 314 7 Firefly 315 12 Thorn 316 4 Stomach 317 4 Poison Bag 318 11 Savage 319 11 Brutal 320 11 Ball Whale 321 11 Float Whale 322 10 Numb 323 10 Eruption 324 10 Coal 325 14 Bounce 326 14 Manipulate 327 1 Spot Panda 328 5 Ant Pit 329 5 Vibration 330 5 Mystic 331 12 Cactus 332 12 Scarecrow POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 333 1 Cotton Bird 334 16 Humming 335 1 Cat Ferret 336 4 Fang Snake 337 6 Meteorite 338 6 Meteorite 339 11 Whiskers 340 11 Whiskers 341 11 Ruffian 342 11 Rogue 343 5 Clay Doll 344 5 Clay Doll 345 6 Sea Lily 346 6 Barnacle 347 6 Old Shrimp 348 6 Plate 349 11 Fish 350 11 Tender 351 1 Weather 352 1 Color Swap 353 8 Puppet 354 8 Marionette POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 355 8 Requiem 356 8 Beckon 357 12 Fruit 358 14 Wind Chime 359 17 Disaster 360 14 Bright 361 15 Snow Hat 362 15 Face 363 15 Clap 364 15 Ball Roll 365 15 Ice Break 366 11 Bivalve 367 11 Deep Sea 368 11 South Sea 369 11 Longevity 370 11 Rendezvous 371 16 Rock Head 372 16 Endurance 373 16 Dragon 374 9 Iron Ball 375 9 Iron Claw 376 9 Iron Leg POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 377 6 Rock Peak 378 15 Iceberg 379 9 Iron 380 16 Eon 381 16 Eon 382 11 Sea Basin 383 5 Continent 384 16 Sky High 385 9 Wish 386 14 DNA 387 12 Tiny Leaf 388 12 Grove 389 12 Continent 390 10 Chimp 391 10 Playful 392 10 Flame 393 11 Penguin 394 11 Penguin 395 11 Emperor 396 1 Starling 397 1 Starling 398 1 Predator POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 399 1 Plump Mouse 400 1 Beaver 401 7 Cricket 402 7 Cricket 403 13 Flash 404 13 Spark 405 13 Gleam Eyes 406 12 Bud 407 12 Bouquet 408 6 Head Butt 409 6 Head Butt 410 6 Shield 411 6 Shield 412 7 Bagworm 413 7 Bagworm 414 7 Moth 415 7 Tiny Bee 416 7 Beehive 417 13 EleSquirrel 418 11 Sea Weasel 419 11 Sea Weasel 420 12 Cherry POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 421 12 Blossom 422 11 Sea Slug 423 11 Sea Slug 424 1 Long Tail 425 8 Balloon 426 8 Blimp 427 1 Rabbit 428 1 Rabbit 429 8 Magical 430 17 Big Boss 431 1 Catty 432 1 Tiger Cat 433 14 Bell 434 4 Skunk 435 4 Skunk 436 9 Bronze 437 9 Bronze Bell 438 6 Bonsai 439 14 Mime 440 1 Playhouse 441 1 Music Note 442 8 Forbidden POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 443 16 Land Shark 444 16 Cave 445 16 Mach 446 1 Big Eater 447 2 Emanation 448 2 Aura 449 5 Hippo 450 5 Heavyweight 451 4 Scorpion 452 4 Ogre Scorp 453 4 Toxic Mouth 454 4 Toxic Mouth 455 12 Bug Catcher 456 11 Wing Fish 457 11 Neon 458 11 Kite 459 12 Frost Tree 460 12 Frost Tree 461 17 Sharp Claw 462 13 Magnet Area 463 1 Licking 464 5 Drill POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 465 12 Vine 466 13 Thunderbolt 467 10 Blast 468 1 Jubilee 469 7 Ogre Darner 470 12 Verdant 471 15 Fresh Snow 472 5 Fang Scorp 473 15 Twin Tusk 474 1 Virtual 475 14 Blade 476 6 Compass 477 8 Gripper 478 15 Snow Land 479 13 Plasma 480 14 Knowledge 481 14 Emotion 482 14 Willpower 483 9 Temporal 484 11 Spatial 485 10 Lava Dome 486 1 Colossal POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 487 8 Renegade 488 14 Lunar 489 11 Sea Drifter 490 11 Seafaring 491 17 Pitch-Black 492 12 Gratitude 493 1 Alpha 494 14 Victory 495 12 Grass Snake 496 12 Grass Snake 497 12 Regal 498 10 Fire Pig 499 10 Fire Pig 500 10 Mega Fire Pig 501 11 Sea Otter 502 11 Discipline 503 11 Formidable 504 1 Scout 505 1 Lookout 506 1 Puppy 507 1 Loyal Dog 508 1 Big-Hearted POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 509 17 Devious 510 17 Cruel 511 12 Grass Monkey 512 12 Thorn Monkey 513 10 High Temp 514 10 Ember 515 11 Spray 516 11 Geyser 517 14 Dream Eater 518 14 Drowsing 519 1 Tiny Pigeon 520 1 Wild Pigeon 521 1 Proud 522 13 Electrified 523 13 Thunderbolt 524 6 Mantle 525 6 Ore 526 6 Compressed 527 14 Bat 528 14 Courting 529 5 Mole 530 5 Subterrene POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 531 1 Hearing 532 2 Muscular 533 2 Muscular 534 2 Muscular 535 11 Tadpole 536 11 Vibration 537 11 Vibration 538 2 Judo 539 2 Karate 540 7 Sewing 541 7 Leaf-Wrapped 542 7 Nurturing 543 7 Centipede 544 7 Curlipede 545 7 Megapede 546 12 Cotton Puff 547 12 Windveiled 548 12 Bulb 549 12 Flowering 550 11 Hostile 551 5 Desert Croc 552 5 Desert Croc POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 553 5 Intimidation 554 10 Zen Charm 555 10 Blazing 556 12 Cactus 557 7 Rock Inn 558 7 Stone Home 559 17 Shedding 560 17 Hoodlum 561 14 Avianoid 562 8 Spirit 563 8 Coffin 564 11 Prototurtle 565 11 Prototurtle 566 6 First Bird 567 6 First Bird 568 4 Trash Bag 569 4 Trash Heap 570 17 Tricky Fox 571 17 Illusion Fox 572 1 Chinchilla 573 1 Scarf 574 14 Fixation POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 575 14 Manipulate 576 14 Astral Body 577 14 Cell 578 14 Mitosis 579 14 Multiplying 580 11 Water Bird 581 11 White Bird 582 15 Fresh Snow 583 15 Icy Snow 584 15 Snowstorm 585 1 Season 586 1 Season 587 13 Sky Squirrel 588 7 Clamping 589 7 Cavalry 590 12 Mushroom 591 12 Mushroom 592 11 Floating 593 11 Floating 594 11 Caring 595 7 Attaching 596 7 EleSpider POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 597 12 Thorn Seed 598 12 Thorn Pod 599 9 Gear 600 9 Gear 601 9 Gear 602 13 EleFish 603 13 EleFish 604 13 EleFish 605 14 Cerebral 606 14 Cerebral 607 8 Candle 608 8 Lamp 609 8 Luring 610 16 Tusk 611 16 Axe Jaw 612 16 Axe Jaw 613 15 Chill 614 15 Freezing 615 15 Crystallizing 616 7 Snail 617 7 Shell Out 618 5 Trap POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 619 2 Martial Arts 620 2 Martial Arts 621 16 Cave 622 5 Automaton 623 5 Automaton 624 17 Sharp Blade 625 17 Sword Blade 626 1 Bash Buffalo 627 1 Eaglet 628 1 Valiant 629 17 Diapered 630 17 Bone Vulture 631 10 Anteater 632 7 Iron Ant 633 17 Irate 634 17 Hostile 635 17 Brutal 636 7 Torch 637 7 Sun 638 9 Iron Will 639 6 Cavern 640 12 Grassland POKEDEXID TYPEID GENUS ---------- ---------- -------------------- 641 3 Cyclone 642 13 Bolt Strike 643 16 Vast White 644 16 Deep Black 645 5 Abundance 646 16 Boundary 647 11 Colt 648 1 Melody 649 7 Paleozoic 1000 14 Database 648 rows selected. SQL> select * from types; TYPEID TYPE GENERATION DAMAGECLASS ---------- -------------------- ---------- ----------- 1 normal 1 2 2 fighting 1 2 3 flying 1 2 4 poison 1 2 5 ground 1 2 6 rock 1 2 7 bug 1 2 8 ghost 1 2 9 steel 2 2 10 fire 1 3 11 water 1 3 12 grass 1 3 13 electric 1 3 14 psychic 1 3 15 ice 1 3 16 dragon 1 3 17 dark 2 3 10001 unknown 2 10002 shadow 3 19 rows selected. SQL> describe pokemon Name Null? Type ----------------------------------------------------------------------------------- -------- -------------------------------------------------------- POKEDEXID NOT NULL NUMBER(38) NAME VARCHAR2(20) SQL> describe species Name Null? Type ----------------------------------------------------------------------------------- -------- -------------------------------------------------------- POKEDEXID NOT NULL NUMBER(38) TYPEID NUMBER(38) GENUS VARCHAR2(20) SQL> SELECT p.name, s.genus, s.typeid 2 FROM pokemon p, species s 3 WHERE p.pokedexid = s.pokedexid 4 ; NAME GENUS TYPEID -------------------- -------------------- ---------- Bulbasaur Seed 12 Ivysaur Seed 12 Venusaur Seed 12 Charmander Lizard 10 Charmeleon Flame 10 Charizard Flame 10 Squirtle Tiny Turtle 11 Wartortle Turtle 11 Blastoise Shellfish 11 Caterpie Worm 7 Metapod Cocoon 7 Butterfree Butterfly 7 Weedle Hairy Bug 7 Kakuna Cocoon 7 Beedrill Poison Bee 7 Pidgey Tiny Bird 1 Pidgeotto Bird 1 Pidgeot Bird 1 Rattata Mouse 1 Raticate Mouse 1 Spearow Tiny Bird 1 Fearow Beak 1 NAME GENUS TYPEID -------------------- -------------------- ---------- Ekans Snake 4 Arbok Cobra 4 Pikachu Mouse 13 Raichu Mouse 13 Sandshrew Mouse 5 Sandslash Mouse 5 Nidoran??? Poison Pin 4 Nidorina Poison Pin 4 Nidoqueen Drill 4 Nidorino Poison Pin 4 Nidoking Drill 4 Clefairy Fairy 1 Clefable Fairy 1 Vulpix Fox 10 Ninetales Fox 10 Jigglypuff Balloon 1 Wigglytuff Balloon 1 Zubat Bat 4 Golbat Bat 4 Oddish Weed 12 Gloom Weed 12 Vileplume Flower 12 NAME GENUS TYPEID -------------------- -------------------- ---------- Paras Mushroom 7 Parasect Mushroom 7 Venonat Insect 7 Venomoth Poison Moth 7 Diglett Mole 5 Dugtrio Mole 5 Meowth Scratch Cat 1 Persian Classy Cat 1 Psyduck Duck 11 Golduck Duck 11 Mankey Pig Monkey 2 Primeape Pig Monkey 2 Growlithe Puppy 10 Arcanine Legendary 10 Poliwag Tadpole 11 Poliwhirl Tadpole 11 Poliwrath Tadpole 11 Abra Psi 14 Kadabra Psi 14 Alakazam Psi 14 Machop Superpower 2 Machoke Superpower 2 NAME GENUS TYPEID -------------------- -------------------- ---------- Machamp Superpower 2 Bellsprout Flower 12 Weepinbell Flycatcher 12 Victreebel Flycatcher 12 Tentacool Jellyfish 11 Tentacruel Jellyfish 11 Geodude Rock 6 Graveler Rock 6 Golem Megaton 6 Ponyta Fire Horse 10 Rapidash Fire Horse 10 Slowpoke Dopey 11 Slowbro Hermit Crab 11 Magnemite Magnet 13 Magneton Magnet 13 Doduo Twin Bird 1 Dodrio Triple Bird 1 Seel Sea Lion 11 Dewgong Sea Lion 11 Grimer Sludge 4 Muk Sludge 4 Shellder Bivalve 11 NAME GENUS TYPEID -------------------- -------------------- ---------- Cloyster Bivalve 11 Gastly Gas 8 Haunter Gas 8 Gengar Shadow 8 Onix Rock Snake 6 Drowzee Hypnosis 14 Hypno Hypnosis 14 Krabby River Crab 11 Kingler Pincer 11 Voltorb Ball 13 Electrode Ball 13 Exeggcute Egg 12 Exeggutor Coconut 12 Cubone Lonely 5 Marowak Bone Keeper 5 Hitmonlee Kicking 2 Hitmonchan Punching 2 Lickitung Licking 1 Koffing Poison Gas 4 Weezing Poison Gas 4 Rhyhorn Spikes 5 Rhydon Drill 5 NAME GENUS TYPEID -------------------- -------------------- ---------- Chansey Egg 1 Tangela Vine 12 Kangaskhan Parent 1 Horsea Dragon 11 Seadra Dragon 11 Goldeen Goldfish 11 Seaking Goldfish 11 Staryu Star Shape 11 Starmie Mysterious 11 Mr. Mime Barrier 14 Scyther Mantis 7 Jynx Human Shape 15 Electabuzz Electric 13 Magmar Spitfire 10 Pinsir Stag Beetle 7 Tauros Wild Bull 1 Magikarp Fish 11 Gyarados Atrocious 11 Lapras Transport 11 Ditto Transform 1 Eevee Evolution 1 Vaporeon Bubble Jet 11 NAME GENUS TYPEID -------------------- -------------------- ---------- Jolteon Lightning 13 Flareon Flame 10 Porygon Virtual 1 Omanyte Spiral 6 Omastar Spiral 6 Kabuto Shellfish 6 Kabutops Shellfish 6 Aerodactyl Fossil 6 Snorlax Sleeping 1 Articuno Freeze 15 Zapdos Electric 13 Moltres Flame 10 Dratini Dragon 16 Dragonair Dragon 16 Dragonite Dragon 16 Mewtwo Genetic 14 Mew New Species 14 Chikorita Leaf 12 Bayleef Leaf 12 Meganium Herb 12 Cyndaquil Fire Mouse 10 Quilava Volcano 10 NAME GENUS TYPEID -------------------- -------------------- ---------- Typhlosion Volcano 10 Totodile Big Jaw 11 Croconaw Big Jaw 11 Feraligatr Big Jaw 11 Sentret Scout 1 Furret Long Body 1 Hoothoot Owl 1 Noctowl Owl 1 Ledyba Five Star 7 Ledian Five Star 7 Spinarak String Spit 7 Ariados Long Leg 7 Crobat Bat 4 Chinchou Angler 11 Lanturn Light 11 Pichu Tiny Mouse 13 Cleffa Star Shape 1 Igglybuff Balloon 1 Togepi Spike Ball 1 Togetic Happiness 1 Natu Tiny Bird 14 Xatu Mystic 14 NAME GENUS TYPEID -------------------- -------------------- ---------- Mareep Wool 13 Flaaffy Wool 13 Ampharos Light 13 Bellossom Flower 12 Marill Aqua Mouse 11 Azumarill Aqua Rabbit 11 Sudowoodo Imitation 6 Politoed Frog 11 Hoppip Cottonweed 12 Skiploom Cottonweed 12 Jumpluff Cottonweed 12 Aipom Long Tail 1 Sunkern Seed 12 Sunflora Sun 12 Yanma Clear Wing 7 Wooper Water Fish 11 Quagsire Water Fish 11 Espeon Sun 14 Umbreon Moonlight 17 Murkrow Darkness 17 Slowking Royal 11 Misdreavus Screech 8 NAME GENUS TYPEID -------------------- -------------------- ---------- Unown Symbol 14 Wobbuffet Patient 14 Girafarig Long Neck 1 Pineco Bagworm 7 Forretress Bagworm 7 Dunsparce Land Snake 1 Gligar FlyScorpion 5 Steelix Iron Snake 9 Snubbull Fairy 1 Granbull Fairy 1 Qwilfish Balloon 11 Scizor Pincer 7 Shuckle Mold 7 Heracross Single Horn 7 Sneasel Sharp Claw 17 Teddiursa Little Bear 1 Ursaring Hibernator 1 Slugma Lava 10 Magcargo Lava 10 Swinub Pig 15 Piloswine Swine 15 Corsola Coral 11 NAME GENUS TYPEID -------------------- -------------------- ---------- Remoraid Jet 11 Octillery Jet 11 Delibird Delivery 15 Mantine Kite 11 Skarmory Armor Bird 9 Houndour Dark 17 Houndoom Dark 17 Kingdra Dragon 11 Phanpy Long Nose 5 Donphan Armor 5 Porygon2 Virtual 1 Stantler Big Horn 1 Smeargle Painter 1 Tyrogue Scuffle 2 Hitmontop Handstand 2 Smoochum Kiss 15 Elekid Electric 13 Magby Live Coal 10 Miltank Milk Cow 1 Blissey Happiness 1 Raikou Thunder 13 Entei Volcano 10 NAME GENUS TYPEID -------------------- -------------------- ---------- Suicune Aurora 11 Larvitar Rock Skin 6 Pupitar Hard Shell 6 Tyranitar Armor 6 Lugia Diving 14 Ho-Oh Rainbow 10 Celebi Time Travel 14 Treecko Wood Gecko 12 Grovyle Wood Gecko 12 Sceptile Forest 12 Torchic Chick 10 Combusken Young Fowl 10 Blaziken Blaze 10 Mudkip Mud Fish 11 Marshtomp Mud Fish 11 Swampert Mud Fish 11 Poochyena Bite 17 Mightyena Bite 17 Zigzagoon TinyRaccoon 1 Linoone Rushing 1 Wurmple Worm 7 Silcoon Cocoon 7 NAME GENUS TYPEID -------------------- -------------------- ---------- Beautifly Butterfly 7 Cascoon Cocoon 7 Dustox Poison Moth 7 Lotad Water Weed 11 Lombre Jolly 11 Ludicolo Carefree 11 Seedot Acorn 12 Nuzleaf Wily 12 Shiftry Wicked 12 Taillow TinySwallow 1 Swellow Swallow 1 Wingull Seagull 11 Pelipper Water Bird 11 Ralts Feeling 14 Kirlia Emotion 14 Gardevoir Embrace 14 Surskit Pond Skater 7 Masquerain Eyeball 7 Shroomish Mushroom 12 Breloom Mushroom 12 Slakoth Slacker 1 Vigoroth Wild Monkey 1 NAME GENUS TYPEID -------------------- -------------------- ---------- Slaking Lazy 1 Nincada Trainee 7 Ninjask Ninja 7 Shedinja Shed 7 Whismur Whisper 1 Loudred Big Voice 1 Exploud Loud Noise 1 Makuhita Guts 2 Hariyama Arm Thrust 2 Azurill Polka Dot 1 Nosepass Compass 6 Skitty Kitten 1 Delcatty Prim 1 Sableye Darkness 17 Mawile Deceiver 9 Aron Iron Armor 9 Lairon Iron Armor 9 Aggron Iron Armor 9 Meditite Meditate 2 Medicham Meditate 2 Electrike Lightning 13 Manectric Discharge 13 NAME GENUS TYPEID -------------------- -------------------- ---------- Plusle Cheering 13 Minun Cheering 13 Volbeat Firefly 7 Illumise Firefly 7 Roselia Thorn 12 Gulpin Stomach 4 Swalot Poison Bag 4 Carvanha Savage 11 Sharpedo Brutal 11 Wailmer Ball Whale 11 Wailord Float Whale 11 Numel Numb 10 Camerupt Eruption 10 Torkoal Coal 10 Spoink Bounce 14 Grumpig Manipulate 14 Spinda Spot Panda 1 Trapinch Ant Pit 5 Vibrava Vibration 5 Flygon Mystic 5 Cacnea Cactus 12 Cacturne Scarecrow 12 NAME GENUS TYPEID -------------------- -------------------- ---------- Swablu Cotton Bird 1 Altaria Humming 16 Zangoose Cat Ferret 1 Seviper Fang Snake 4 Lunatone Meteorite 6 Solrock Meteorite 6 Barboach Whiskers 11 Whiscash Whiskers 11 Corphish Ruffian 11 Crawdaunt Rogue 11 Baltoy Clay Doll 5 Claydol Clay Doll 5 Lileep Sea Lily 6 Cradily Barnacle 6 Anorith Old Shrimp 6 Armaldo Plate 6 Feebas Fish 11 Milotic Tender 11 Castform Weather 1 Kecleon Color Swap 1 Shuppet Puppet 8 Banette Marionette 8 NAME GENUS TYPEID -------------------- -------------------- ---------- Duskull Requiem 8 Dusclops Beckon 8 Tropius Fruit 12 Chimecho Wind Chime 14 Absol Disaster 17 Wynaut Bright 14 Snorunt Snow Hat 15 Glalie Face 15 Spheal Clap 15 Sealeo Ball Roll 15 Walrein Ice Break 15 Clamperl Bivalve 11 Huntail Deep Sea 11 Gorebyss South Sea 11 Relicanth Longevity 11 Luvdisc Rendezvous 11 Bagon Rock Head 16 Shelgon Endurance 16 Salamence Dragon 16 Beldum Iron Ball 9 Metang Iron Claw 9 Metagross Iron Leg 9 NAME GENUS TYPEID -------------------- -------------------- ---------- Regirock Rock Peak 6 Regice Iceberg 15 Registeel Iron 9 Latias Eon 16 Latios Eon 16 Kyogre Sea Basin 11 Groudon Continent 5 Rayquaza Sky High 16 Jirachi Wish 9 Deoxys DNA 14 Turtwig Tiny Leaf 12 Grotle Grove 12 Torterra Continent 12 Chimchar Chimp 10 Monferno Playful 10 Infernape Flame 10 Piplup Penguin 11 Prinplup Penguin 11 Empoleon Emperor 11 Starly Starling 1 Staravia Starling 1 Staraptor Predator 1 NAME GENUS TYPEID -------------------- -------------------- ---------- Bidoof Plump Mouse 1 Bibarel Beaver 1 Kricketot Cricket 7 Kricketune Cricket 7 Shinx Flash 13 Luxio Spark 13 Luxray Gleam Eyes 13 Budew Bud 12 Roserade Bouquet 12 Cranidos Head Butt 6 Rampardos Head Butt 6 Shieldon Shield 6 Bastiodon Shield 6 Burmy Bagworm 7 Wormadam Bagworm 7 Mothim Moth 7 Combee Tiny Bee 7 Vespiquen Beehive 7 Pachirisu EleSquirrel 13 Buizel Sea Weasel 11 Floatzel Sea Weasel 11 Cherubi Cherry 12 NAME GENUS TYPEID -------------------- -------------------- ---------- Cherrim Blossom 12 Shellos Sea Slug 11 Gastrodon Sea Slug 11 Ambipom Long Tail 1 Drifloon Balloon 8 Drifblim Blimp 8 Buneary Rabbit 1 Lopunny Rabbit 1 Mismagius Magical 8 Honchkrow Big Boss 17 Glameow Catty 1 Purugly Tiger Cat 1 Chingling Bell 14 Stunky Skunk 4 Skuntank Skunk 4 Bronzor Bronze 9 Bronzong Bronze Bell 9 Bonsly Bonsai 6 Mime Jr. Mime 14 Happiny Playhouse 1 Chatot Music Note 1 Spiritomb Forbidden 8 NAME GENUS TYPEID -------------------- -------------------- ---------- Gible Land Shark 16 Gabite Cave 16 Garchomp Mach 16 Munchlax Big Eater 1 Riolu Emanation 2 Lucario Aura 2 Hippopotas Hippo 5 Hippowdon Heavyweight 5 Skorupi Scorpion 4 Drapion Ogre Scorp 4 Croagunk Toxic Mouth 4 Toxicroak Toxic Mouth 4 Carnivine Bug Catcher 12 Finneon Wing Fish 11 Lumineon Neon 11 Mantyke Kite 11 Snover Frost Tree 12 Abomasnow Frost Tree 12 Weavile Sharp Claw 17 Magnezone Magnet Area 13 Lickilicky Licking 1 Rhyperior Drill 5 NAME GENUS TYPEID -------------------- -------------------- ---------- Tangrowth Vine 12 Electivire Thunderbolt 13 Magmortar Blast 10 Togekiss Jubilee 1 Yanmega Ogre Darner 7 Leafeon Verdant 12 Glaceon Fresh Snow 15 Gliscor Fang Scorp 5 Mamoswine Twin Tusk 15 Porygon-Z Virtual 1 Gallade Blade 14 Probopass Compass 6 Dusknoir Gripper 8 Froslass Snow Land 15 Rotom Plasma 13 Uxie Knowledge 14 Mesprit Emotion 14 Azelf Willpower 14 Dialga Temporal 9 Palkia Spatial 11 Heatran Lava Dome 10 Regigigas Colossal 1 NAME GENUS TYPEID -------------------- -------------------- ---------- Giratina Renegade 8 Cresselia Lunar 14 Phione Sea Drifter 11 Manaphy Seafaring 11 Darkrai Pitch-Black 17 Shaymin Gratitude 12 Arceus Alpha 1 Victini Victory 14 Snivy Grass Snake 12 Servine Grass Snake 12 Serperior Regal 12 Tepig Fire Pig 10 Pignite Fire Pig 10 Emboar Mega Fire Pig 10 Oshawott Sea Otter 11 Dewott Discipline 11 Samurott Formidable 11 Patrat Scout 1 Watchog Lookout 1 Lillipup Puppy 1 Herdier Loyal Dog 1 Stoutland Big-Hearted 1 NAME GENUS TYPEID -------------------- -------------------- ---------- Purrloin Devious 17 Liepard Cruel 17 Pansage Grass Monkey 12 Simisage Thorn Monkey 12 Pansear High Temp 10 Simisear Ember 10 Panpour Spray 11 Simipour Geyser 11 Munna Dream Eater 14 Musharna Drowsing 14 Pidove Tiny Pigeon 1 Tranquill Wild Pigeon 1 Unfezant Proud 1 Blitzle Electrified 13 Zebstrika Thunderbolt 13 Roggenrola Mantle 6 Boldore Ore 6 Gigalith Compressed 6 Woobat Bat 14 Swoobat Courting 14 Drilbur Mole 5 Excadrill Subterrene 5 NAME GENUS TYPEID -------------------- -------------------- ---------- Audino Hearing 1 Timburr Muscular 2 Gurdurr Muscular 2 Conkeldurr Muscular 2 Tympole Tadpole 11 Palpitoad Vibration 11 Seismitoad Vibration 11 Throh Judo 2 Sawk Karate 2 Sewaddle Sewing 7 Swadloon Leaf-Wrapped 7 Leavanny Nurturing 7 Venipede Centipede 7 Whirlipede Curlipede 7 Scolipede Megapede 7 Cottonee Cotton Puff 12 Whimsicott Windveiled 12 Petilil Bulb 12 Lilligant Flowering 12 Basculin Hostile 11 Sandile Desert Croc 5 Krokorok Desert Croc 5 NAME GENUS TYPEID -------------------- -------------------- ---------- Krookodile Intimidation 5 Darumaka Zen Charm 10 Darmanitan Blazing 10 Maractus Cactus 12 Dwebble Rock Inn 7 Crustle Stone Home 7 Scraggy Shedding 17 Scrafty Hoodlum 17 Sigilyph Avianoid 14 Yamask Spirit 8 Cofagrigus Coffin 8 Tirtouga Prototurtle 11 Carracosta Prototurtle 11 Archen First Bird 6 Archeops First Bird 6 Trubbish Trash Bag 4 Garbodor Trash Heap 4 Zorua Tricky Fox 17 Zoroark Illusion Fox 17 Minccino Chinchilla 1 Cinccino Scarf 1 Gothita Fixation 14 NAME GENUS TYPEID -------------------- -------------------- ---------- Gothorita Manipulate 14 Gothitelle Astral Body 14 Solosis Cell 14 Duosion Mitosis 14 Reuniclus Multiplying 14 Ducklett Water Bird 11 Swanna White Bird 11 Vanillite Fresh Snow 15 Vanillish Icy Snow 15 Vanilluxe Snowstorm 15 Deerling Season 1 Sawsbuck Season 1 Emolga Sky Squirrel 13 Karrablast Clamping 7 Escavalier Cavalry 7 Foongus Mushroom 12 Amoonguss Mushroom 12 Frillish Floating 11 Jellicent Floating 11 Alomomola Caring 11 Joltik Attaching 7 Galvantula EleSpider 7 NAME GENUS TYPEID -------------------- -------------------- ---------- Ferroseed Thorn Seed 12 Ferrothorn Thorn Pod 12 Klink Gear 9 Klang Gear 9 Klinklang Gear 9 Tynamo EleFish 13 Eelektrik EleFish 13 Eelektross EleFish 13 Elgyem Cerebral 14 Beheeyem Cerebral 14 Litwick Candle 8 Lampent Lamp 8 Chandelure Luring 8 Axew Tusk 16 Fraxure Axe Jaw 16 Haxorus Axe Jaw 16 Cubchoo Chill 15 Beartic Freezing 15 Cryogonal Crystallizing 15 Shelmet Snail 7 Accelgor Shell Out 7 Stunfisk Trap 5 NAME GENUS TYPEID -------------------- -------------------- ---------- Mienfoo Martial Arts 2 Mienshao Martial Arts 2 Druddigon Cave 16 Golett Automaton 5 Golurk Automaton 5 Pawniard Sharp Blade 17 Bisharp Sword Blade 17 Bouffalant Bash Buffalo 1 Rufflet Eaglet 1 Braviary Valiant 1 Vullaby Diapered 17 Mandibuzz Bone Vulture 17 Heatmor Anteater 10 Durant Iron Ant 7 Deino Irate 17 Zweilous Hostile 17 Hydreigon Brutal 17 Larvesta Torch 7 Volcarona Sun 7 Cobalion Iron Will 9 Terrakion Cavern 6 Virizion Grassland 12 NAME GENUS TYPEID -------------------- -------------------- ---------- Tornadus Cyclone 3 Thundurus Bolt Strike 13 Reshiram Vast White 16 Zekrom Deep Black 16 Landorus Abundance 5 Kyurem Boundary 16 Keldeo Colt 11 Meloetta Melody 1 Genesect Paleozoic 7 CS365chu Database 14 648 rows selected. SQL> SELECT p.name, s.genus, s.typeid 2 FROM pokemon p, species s 3 WHERE pokedexid = 20 4 ; WHERE pokedexid = 20 * ERROR at line 3: ORA-00918: column ambiguously defined SQL> SELECT p.name, s.genus, s.typeid 2 FROM pokemon p, species s 3 WHERE p.pokedexid = s.pokedexid and 4 s.genus = 'Continent' 5 ; NAME GENUS TYPEID -------------------- -------------------- ---------- Groudon Continent 5 Torterra Continent 12 SQL> describe types Name Null? Type ----------------------------------------------------------------------------------- -------- -------------------------------------------------------- TYPEID NOT NULL NUMBER(38) TYPE VARCHAR2(20) GENERATION NUMBER(38) DAMAGECLASS NUMBER(38) SQL> SELECT p.name, s.genus, t.type 2 FROM pokemon p, species s, types t 3 WHERE p.pokedexid = s.pokedexid and 4 s.genus = 'Continent' and 5 t.typeid = s.typeid 6 ; NAME GENUS TYPE -------------------- -------------------- -------------------- Groudon Continent ground Torterra Continent grass SQL> select table_name from user_tables; TABLE_NAME ------------------------------ LEAGUES ATTENDANCE BEERS BARS ALLELES PNEXT SPECIES ATTRIBUTES TYPES ANEW POKEMON EVOLUTION REACTORS EARTHQUAKES LOCATION EMPLOYEE BIGQUAKES TOURNAMENT EMPLOYEES 19 rows selected. SQL> describe attributes Name Null? Type ----------------------------------------------------------------------------------- -------- -------------------------------------------------------- POKEDEXID NOT NULL NUMBER(38) HEIGHT NUMBER(38) WEIGHT NUMBER(38) BASEEXPERIENCE NUMBER(38) SQL> SELECT p.name, s.genus, t.type, height, 2 weight 3 FROM pokemon p, species s, types t, 4 attributes a 5 WHERE p.pokedexid = s.pokedexid and 6 s.genus = 'Continent' and 7 t.typeid = s.typeid 8 ; NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 7 69 Groudon Continent ground 10 130 Groudon Continent ground 20 1000 Groudon Continent ground 6 85 Groudon Continent ground 11 190 Groudon Continent ground 17 905 Groudon Continent ground 5 90 Groudon Continent ground 10 225 Groudon Continent ground 16 855 Groudon Continent ground 3 29 Groudon Continent ground 7 99 Groudon Continent ground 11 320 Groudon Continent ground 3 32 Groudon Continent ground 6 100 Groudon Continent ground 10 295 Groudon Continent ground 3 18 Groudon Continent ground 11 300 Groudon Continent ground 15 395 Groudon Continent ground 3 35 Groudon Continent ground 7 185 Groudon Continent ground 3 20 Groudon Continent ground 12 380 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 20 69 Groudon Continent ground 35 650 Groudon Continent ground 4 60 Groudon Continent ground 8 300 Groudon Continent ground 6 120 Groudon Continent ground 10 295 Groudon Continent ground 4 70 Groudon Continent ground 8 200 Groudon Continent ground 13 600 Groudon Continent ground 9 195 Groudon Continent ground 14 620 Groudon Continent ground 6 75 Groudon Continent ground 13 400 Groudon Continent ground 6 99 Groudon Continent ground 11 199 Groudon Continent ground 5 55 Groudon Continent ground 10 120 Groudon Continent ground 8 75 Groudon Continent ground 16 550 Groudon Continent ground 5 54 Groudon Continent ground 8 86 Groudon Continent ground 12 186 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 3 54 Groudon Continent ground 10 295 Groudon Continent ground 10 300 Groudon Continent ground 15 125 Groudon Continent ground 2 8 Groudon Continent ground 7 333 Groudon Continent ground 4 42 Groudon Continent ground 10 320 Groudon Continent ground 8 196 Groudon Continent ground 17 766 Groudon Continent ground 5 280 Groudon Continent ground 10 320 Groudon Continent ground 7 190 Groudon Continent ground 19 1550 Groudon Continent ground 6 124 Groudon Continent ground 10 200 Groudon Continent ground 13 540 Groudon Continent ground 9 195 Groudon Continent ground 13 565 Groudon Continent ground 15 480 Groudon Continent ground 8 195 Groudon Continent ground 15 705 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 16 1300 Groudon Continent ground 7 40 Groudon Continent ground 10 64 Groudon Continent ground 17 155 Groudon Continent ground 9 455 Groudon Continent ground 16 550 Groudon Continent ground 4 200 Groudon Continent ground 10 1050 Groudon Continent ground 14 3000 Groudon Continent ground 10 300 Groudon Continent ground 17 950 Groudon Continent ground 12 360 Groudon Continent ground 16 785 Groudon Continent ground 3 60 Groudon Continent ground 10 600 Groudon Continent ground 14 392 Groudon Continent ground 18 852 Groudon Continent ground 11 900 Groudon Continent ground 17 1200 Groudon Continent ground 9 300 Groudon Continent ground 12 300 Groudon Continent ground 3 40 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 15 1325 Groudon Continent ground 13 1 Groudon Continent ground 16 1 Groudon Continent ground 15 405 Groudon Continent ground 88 2100 Groudon Continent ground 10 324 Groudon Continent ground 16 756 Groudon Continent ground 4 65 Groudon Continent ground 13 600 Groudon Continent ground 5 104 Groudon Continent ground 12 666 Groudon Continent ground 4 25 Groudon Continent ground 20 1200 Groudon Continent ground 4 65 Groudon Continent ground 10 450 Groudon Continent ground 15 498 Groudon Continent ground 14 502 Groudon Continent ground 12 655 Groudon Continent ground 6 10 Groudon Continent ground 12 95 Groudon Continent ground 10 1150 Groudon Continent ground 19 1200 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 11 346 Groudon Continent ground 10 350 Groudon Continent ground 22 800 Groudon Continent ground 4 80 Groudon Continent ground 12 250 Groudon Continent ground 6 150 Groudon Continent ground 13 390 Groudon Continent ground 8 345 Groudon Continent ground 11 800 Groudon Continent ground 13 545 Groudon Continent ground 15 560 Groudon Continent ground 14 406 Groudon Continent ground 11 300 Groudon Continent ground 13 445 Groudon Continent ground 15 550 Groudon Continent ground 14 884 Groudon Continent ground 9 100 Groudon Continent ground 65 2350 Groudon Continent ground 25 2200 Groudon Continent ground 3 40 Groudon Continent ground 3 65 Groudon Continent ground 10 290 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 8 245 Groudon Continent ground 9 250 Groudon Continent ground 8 365 Groudon Continent ground 4 75 Groudon Continent ground 10 350 Groudon Continent ground 5 115 Groudon Continent ground 13 405 Groudon Continent ground 18 590 Groudon Continent ground 21 4600 Groudon Continent ground 17 554 Groudon Continent ground 16 526 Groudon Continent ground 20 600 Groudon Continent ground 18 33 Groudon Continent ground 40 165 Groudon Continent ground 22 2100 Groudon Continent ground 20 1220 Groudon Continent ground 4 40 Groudon Continent ground 9 64 Groudon Continent ground 12 158 Groudon Continent ground 18 1005 Groudon Continent ground 5 79 Groudon Continent ground 9 190 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 17 795 Groudon Continent ground 6 95 Groudon Continent ground 11 250 Groudon Continent ground 23 888 Groudon Continent ground 8 60 Groudon Continent ground 18 325 Groudon Continent ground 7 212 Groudon Continent ground 16 408 Groudon Continent ground 10 108 Groudon Continent ground 14 356 Groudon Continent ground 5 85 Groudon Continent ground 11 335 Groudon Continent ground 18 750 Groudon Continent ground 5 120 Groudon Continent ground 12 225 Groudon Continent ground 3 20 Groudon Continent ground 3 30 Groudon Continent ground 3 10 Groudon Continent ground 3 15 Groudon Continent ground 6 32 Groudon Continent ground 2 20 Groudon Continent ground 15 150 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 6 78 Groudon Continent ground 8 133 Groudon Continent ground 14 615 Groudon Continent ground 4 58 Groudon Continent ground 4 85 Groudon Continent ground 8 285 Groudon Continent ground 12 380 Groudon Continent ground 11 339 Groudon Continent ground 4 5 Groudon Continent ground 6 10 Groudon Continent ground 8 30 Groudon Continent ground 8 115 Groudon Continent ground 3 18 Groudon Continent ground 8 85 Groudon Continent ground 12 380 Groudon Continent ground 4 85 Groudon Continent ground 14 750 Groudon Continent ground 9 265 Groudon Continent ground 10 270 Groudon Continent ground 5 21 Groudon Continent ground 20 795 Groudon Continent ground 7 10 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 5 50 Groudon Continent ground 13 285 Groudon Continent ground 15 415 Groudon Continent ground 6 72 Groudon Continent ground 12 1258 Groudon Continent ground 15 140 Groudon Continent ground 11 648 Groudon Continent ground 92 4000 Groudon Continent ground 6 78 Groudon Continent ground 14 487 Groudon Continent ground 5 39 Groudon Continent ground 18 1180 Groudon Continent ground 6 205 Groudon Continent ground 15 540 Groudon Continent ground 9 280 Groudon Continent ground 6 88 Groudon Continent ground 18 1258 Groudon Continent ground 7 350 Groudon Continent ground 8 550 Groudon Continent ground 4 65 Groudon Continent ground 11 558 Groudon Continent ground 6 50 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 6 120 Groudon Continent ground 9 285 Groudon Continent ground 9 160 Groudon Continent ground 21 2200 Groudon Continent ground 17 505 Groudon Continent ground 6 108 Groudon Continent ground 14 350 Groudon Continent ground 18 1520 Groudon Continent ground 5 335 Groudon Continent ground 11 1200 Groudon Continent ground 6 325 Groudon Continent ground 14 712 Groudon Continent ground 12 580 Groudon Continent ground 7 210 Groudon Continent ground 14 480 Groudon Continent ground 4 60 Groudon Continent ground 6 235 Groudon Continent ground 7 214 Groudon Continent ground 12 755 Groudon Continent ground 15 468 Groudon Continent ground 19 1780 Groudon Continent ground 21 1980 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 20 1870 Groudon Continent ground 6 720 Groudon Continent ground 12 1520 Groudon Continent ground 20 2020 Groudon Continent ground 52 2160 Groudon Continent ground 38 1990 Groudon Continent ground 6 50 Groudon Continent ground 5 50 Groudon Continent ground 9 216 Groudon Continent ground 17 522 Groudon Continent ground 4 25 Groudon Continent ground 9 195 Groudon Continent ground 19 520 Groudon Continent ground 4 76 Groudon Continent ground 7 280 Groudon Continent ground 15 819 Groudon Continent ground 5 136 Groudon Continent ground 10 370 Groudon Continent ground 4 175 Groudon Continent ground 5 325 Groudon Continent ground 3 36 Groudon Continent ground 6 100 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 10 284 Groudon Continent ground 7 115 Groudon Continent ground 12 316 Groudon Continent ground 5 26 Groudon Continent ground 12 325 Groudon Continent ground 15 550 Groudon Continent ground 5 40 Groudon Continent ground 10 280 Groudon Continent ground 13 596 Groudon Continent ground 3 23 Groudon Continent ground 7 198 Groudon Continent ground 6 95 Groudon Continent ground 12 280 Groudon Continent ground 4 66 Groudon Continent ground 8 202 Groudon Continent ground 16 484 Groudon Continent ground 5 17 Groudon Continent ground 8 36 Groudon Continent ground 4 45 Groudon Continent ground 12 392 Groudon Continent ground 8 240 Groudon Continent ground 14 465 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 20 1305 Groudon Continent ground 5 55 Groudon Continent ground 8 120 Groudon Continent ground 8 12 Groudon Continent ground 6 163 Groudon Continent ground 10 405 Groudon Continent ground 15 840 Groudon Continent ground 10 864 Groudon Continent ground 23 2538 Groudon Continent ground 2 20 Groudon Continent ground 10 970 Groudon Continent ground 6 110 Groudon Continent ground 11 326 Groudon Continent ground 5 110 Groudon Continent ground 6 115 Groudon Continent ground 4 600 Groudon Continent ground 9 1200 Groudon Continent ground 21 3600 Groudon Continent ground 6 112 Groudon Continent ground 13 315 Groudon Continent ground 6 152 Groudon Continent ground 15 402 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 4 42 Groudon Continent ground 4 42 Groudon Continent ground 7 177 Groudon Continent ground 6 177 Groudon Continent ground 3 20 Groudon Continent ground 4 103 Groudon Continent ground 17 800 Groudon Continent ground 8 208 Groudon Continent ground 18 888 Groudon Continent ground 20 1300 Groudon Continent ground 145 3980 Groudon Continent ground 7 240 Groudon Continent ground 19 2200 Groudon Continent ground 5 804 Groudon Continent ground 7 306 Groudon Continent ground 9 715 Groudon Continent ground 11 50 Groudon Continent ground 7 150 Groudon Continent ground 11 153 Groudon Continent ground 20 820 Groudon Continent ground 4 513 Groudon Continent ground 13 774 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 4 12 Groudon Continent ground 11 206 Groudon Continent ground 13 403 Groudon Continent ground 27 525 Groudon Continent ground 10 1680 Groudon Continent ground 12 1540 Groudon Continent ground 4 19 Groudon Continent ground 9 236 Groudon Continent ground 6 115 Groudon Continent ground 11 328 Groudon Continent ground 5 215 Groudon Continent ground 15 1080 Groudon Continent ground 10 238 Groudon Continent ground 15 604 Groudon Continent ground 7 125 Groudon Continent ground 15 682 Groudon Continent ground 6 74 Groudon Continent ground 62 1620 Groudon Continent ground 3 8 Groudon Continent ground 10 220 Groudon Continent ground 6 23 Groudon Continent ground 11 125 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 8 150 Groudon Continent ground 16 306 Groudon Continent ground 20 1000 Groudon Continent ground 6 10 Groudon Continent ground 12 470 Groudon Continent ground 6 140 Groudon Continent ground 7 168 Groudon Continent ground 15 2565 Groudon Continent ground 8 395 Groudon Continent ground 11 876 Groudon Continent ground 14 1506 Groudon Continent ground 4 525 Groudon Continent ground 17 270 Groudon Continent ground 18 226 Groudon Continent ground 10 234 Groudon Continent ground 6 87 Groudon Continent ground 6 421 Groudon Continent ground 11 1105 Groudon Continent ground 15 1026 Groudon Continent ground 6 952 Groudon Continent ground 12 2025 Groudon Continent ground 16 5500 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 17 2300 Groudon Continent ground 18 1750 Groudon Continent ground 19 2050 Groudon Continent ground 14 400 Groudon Continent ground 20 600 Groudon Continent ground 45 3520 Groudon Continent ground 35 9500 Groudon Continent ground 70 2065 Groudon Continent ground 3 11 Groudon Continent ground 17 608 Groudon Continent ground 4 102 Groudon Continent ground 11 970 Groudon Continent ground 22 3100 Groudon Continent ground 5 62 Groudon Continent ground 9 220 Groudon Continent ground 12 550 Groudon Continent ground 4 52 Groudon Continent ground 8 230 Groudon Continent ground 17 845 Groudon Continent ground 3 20 Groudon Continent ground 6 155 Groudon Continent ground 12 249 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 5 200 Groudon Continent ground 10 315 Groudon Continent ground 3 22 Groudon Continent ground 10 255 Groudon Continent ground 5 95 Groudon Continent ground 9 305 Groudon Continent ground 14 420 Groudon Continent ground 2 12 Groudon Continent ground 9 145 Groudon Continent ground 9 315 Groudon Continent ground 16 1025 Groudon Continent ground 5 570 Groudon Continent ground 13 1495 Groudon Continent ground 2 34 Groudon Continent ground 5 65 Groudon Continent ground 9 233 Groudon Continent ground 3 55 Groudon Continent ground 12 385 Groudon Continent ground 4 39 Groudon Continent ground 7 295 Groudon Continent ground 11 335 Groudon Continent ground 4 33 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 5 93 Groudon Continent ground 3 63 Groudon Continent ground 9 299 Groudon Continent ground 12 203 Groudon Continent ground 4 12 Groudon Continent ground 12 150 Groudon Continent ground 4 55 Groudon Continent ground 12 333 Groudon Continent ground 9 44 Groudon Continent ground 9 273 Groudon Continent ground 5 39 Groudon Continent ground 10 438 Groudon Continent ground 2 6 Groudon Continent ground 4 192 Groudon Continent ground 10 380 Groudon Continent ground 5 605 Groudon Continent ground 13 1870 Groudon Continent ground 5 150 Groudon Continent ground 6 130 Groudon Continent ground 6 244 Groudon Continent ground 5 19 Groudon Continent ground 10 1080 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 7 205 Groudon Continent ground 14 560 Groudon Continent ground 19 950 Groudon Continent ground 6 1050 Groudon Continent ground 7 202 Groudon Continent ground 12 540 Groudon Continent ground 8 495 Groudon Continent ground 20 3000 Groudon Continent ground 8 120 Groudon Continent ground 13 615 Groudon Continent ground 7 230 Groudon Continent ground 13 444 Groudon Continent ground 14 270 Groudon Continent ground 4 70 Groudon Continent ground 12 240 Groudon Continent ground 10 650 Groudon Continent ground 10 505 Groudon Continent ground 22 1355 Groudon Continent ground 11 340 Groudon Continent ground 12 1800 Groudon Continent ground 17 1400 Groudon Continent ground 24 2828 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 20 1286 Groudon Continent ground 18 1386 Groudon Continent ground 16 680 Groudon Continent ground 15 380 Groudon Continent ground 19 515 Groudon Continent ground 10 255 Groudon Continent ground 8 259 Groudon Continent ground 20 425 Groudon Continent ground 25 2910 Groudon Continent ground 9 340 Groudon Continent ground 16 520 Groudon Continent ground 14 3400 Groudon Continent ground 22 1066 Groudon Continent ground 13 266 Groudon Continent ground 3 3 Groudon Continent ground 3 3 Groudon Continent ground 3 3 Groudon Continent ground 3 3 Groudon Continent ground 54 6830 Groudon Continent ground 42 3360 Groudon Continent ground 17 4300 Groudon Continent ground 37 4200 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 45 7500 Groudon Continent ground 15 856 Groudon Continent ground 4 31 Groudon Continent ground 3 14 Groudon Continent ground 15 505 Groudon Continent ground 2 21 Groudon Continent ground 32 3200 Groudon Continent ground 4 40 Groudon Continent ground 6 81 Groudon Continent ground 8 160 Groudon Continent ground 33 630 Groudon Continent ground 5 99 Groudon Continent ground 10 555 Groudon Continent ground 16 1500 Groudon Continent ground 5 59 Groudon Continent ground 8 245 Groudon Continent ground 15 946 Groudon Continent ground 5 116 Groudon Continent ground 11 270 Groudon Continent ground 4 41 Groudon Continent ground 9 147 Groudon Continent ground 12 610 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 4 101 Groudon Continent ground 11 375 Groudon Continent ground 6 105 Groudon Continent ground 11 305 Groudon Continent ground 6 110 Groudon Continent ground 10 280 Groudon Continent ground 6 135 Groudon Continent ground 10 290 Groudon Continent ground 6 233 Groudon Continent ground 11 605 Groudon Continent ground 3 21 Groudon Continent ground 6 150 Groudon Continent ground 12 290 Groudon Continent ground 8 298 Groudon Continent ground 16 795 Groudon Continent ground 4 180 Groudon Continent ground 9 1020 Groudon Continent ground 17 2600 Groudon Continent ground 4 21 Groudon Continent ground 9 105 Groudon Continent ground 3 85 Groudon Continent ground 7 404 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 11 310 Groudon Continent ground 6 125 Groudon Continent ground 12 400 Groudon Continent ground 14 870 Groudon Continent ground 5 45 Groudon Continent ground 8 170 Groudon Continent ground 15 620 Groudon Continent ground 13 555 Groudon Continent ground 14 510 Groudon Continent ground 3 25 Groudon Continent ground 5 73 Groudon Continent ground 12 205 Groudon Continent ground 4 53 Groudon Continent ground 12 585 Groudon Continent ground 25 2005 Groudon Continent ground 3 6 Groudon Continent ground 7 66 Groudon Continent ground 5 66 Groudon Continent ground 11 163 Groudon Continent ground 10 180 Groudon Continent ground 7 152 Groudon Continent ground 10 334 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 15 963 Groudon Continent ground 6 375 Groudon Continent ground 13 929 Groudon Continent ground 10 280 Groudon Continent ground 3 145 Groudon Continent ground 14 2000 Groudon Continent ground 6 118 Groudon Continent ground 11 300 Groudon Continent ground 14 140 Groudon Continent ground 5 15 Groudon Continent ground 17 765 Groudon Continent ground 7 165 Groudon Continent ground 12 810 Groudon Continent ground 5 95 Groudon Continent ground 14 320 Groudon Continent ground 6 310 Groudon Continent ground 19 1073 Groudon Continent ground 7 125 Groudon Continent ground 16 811 Groudon Continent ground 4 58 Groudon Continent ground 5 75 Groudon Continent ground 4 58 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 7 180 Groudon Continent ground 15 440 Groudon Continent ground 3 10 Groudon Continent ground 6 80 Groudon Continent ground 10 201 Groudon Continent ground 5 55 Groudon Continent ground 13 242 Groudon Continent ground 4 57 Groudon Continent ground 11 410 Groudon Continent ground 13 575 Groudon Continent ground 6 195 Groudon Continent ground 19 925 Groudon Continent ground 4 50 Groudon Continent ground 5 59 Groudon Continent ground 10 330 Groudon Continent ground 2 10 Groudon Continent ground 6 105 Groudon Continent ground 12 330 Groudon Continent ground 22 1350 Groudon Continent ground 12 316 Groudon Continent ground 1 6 Groudon Continent ground 8 143 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 6 188 Groudon Continent ground 10 1100 Groudon Continent ground 3 210 Groudon Continent ground 6 510 Groudon Continent ground 6 810 Groudon Continent ground 2 3 Groudon Continent ground 12 220 Groudon Continent ground 21 805 Groudon Continent ground 5 90 Groudon Continent ground 10 345 Groudon Continent ground 3 31 Groudon Continent ground 6 130 Groudon Continent ground 10 343 Groudon Continent ground 6 180 Groudon Continent ground 10 360 Groudon Continent ground 18 1055 Groudon Continent ground 5 85 Groudon Continent ground 26 2600 Groudon Continent ground 11 1480 Groudon Continent ground 4 77 Groudon Continent ground 8 253 Groudon Continent ground 7 110 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 9 200 Groudon Continent ground 14 355 Groudon Continent ground 16 1390 Groudon Continent ground 10 920 Groudon Continent ground 28 3300 Groudon Continent ground 5 102 Groudon Continent ground 16 700 Groudon Continent ground 16 946 Groudon Continent ground 5 105 Groudon Continent ground 15 410 Groudon Continent ground 5 90 Groudon Continent ground 12 395 Groudon Continent ground 14 580 Groudon Continent ground 3 330 Groudon Continent ground 8 173 Groudon Continent ground 14 500 Groudon Continent ground 18 1600 Groudon Continent ground 11 288 Groudon Continent ground 16 460 Groudon Continent ground 21 2500 Groudon Continent ground 19 2600 Groudon Continent ground 20 2000 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 15 630 Groudon Continent ground 15 610 Groudon Continent ground 32 3300 Groudon Continent ground 29 3450 Groudon Continent ground 15 680 Groudon Continent ground 30 3250 Groudon Continent ground 14 485 Groudon Continent ground 6 65 Groudon Continent ground 15 825 Groudon Continent ground 8 300 Torterra Continent grass 7 69 Torterra Continent grass 10 130 Torterra Continent grass 20 1000 Torterra Continent grass 6 85 Torterra Continent grass 11 190 Torterra Continent grass 17 905 Torterra Continent grass 5 90 Torterra Continent grass 10 225 Torterra Continent grass 16 855 Torterra Continent grass 3 29 Torterra Continent grass 7 99 Torterra Continent grass 11 320 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 3 32 Torterra Continent grass 6 100 Torterra Continent grass 10 295 Torterra Continent grass 3 18 Torterra Continent grass 11 300 Torterra Continent grass 15 395 Torterra Continent grass 3 35 Torterra Continent grass 7 185 Torterra Continent grass 3 20 Torterra Continent grass 12 380 Torterra Continent grass 20 69 Torterra Continent grass 35 650 Torterra Continent grass 4 60 Torterra Continent grass 8 300 Torterra Continent grass 6 120 Torterra Continent grass 10 295 Torterra Continent grass 4 70 Torterra Continent grass 8 200 Torterra Continent grass 13 600 Torterra Continent grass 9 195 Torterra Continent grass 14 620 Torterra Continent grass 6 75 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 13 400 Torterra Continent grass 6 99 Torterra Continent grass 11 199 Torterra Continent grass 5 55 Torterra Continent grass 10 120 Torterra Continent grass 8 75 Torterra Continent grass 16 550 Torterra Continent grass 5 54 Torterra Continent grass 8 86 Torterra Continent grass 12 186 Torterra Continent grass 3 54 Torterra Continent grass 10 295 Torterra Continent grass 10 300 Torterra Continent grass 15 125 Torterra Continent grass 2 8 Torterra Continent grass 7 333 Torterra Continent grass 4 42 Torterra Continent grass 10 320 Torterra Continent grass 8 196 Torterra Continent grass 17 766 Torterra Continent grass 5 280 Torterra Continent grass 10 320 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 7 190 Torterra Continent grass 19 1550 Torterra Continent grass 6 124 Torterra Continent grass 10 200 Torterra Continent grass 13 540 Torterra Continent grass 9 195 Torterra Continent grass 13 565 Torterra Continent grass 15 480 Torterra Continent grass 8 195 Torterra Continent grass 15 705 Torterra Continent grass 16 1300 Torterra Continent grass 7 40 Torterra Continent grass 10 64 Torterra Continent grass 17 155 Torterra Continent grass 9 455 Torterra Continent grass 16 550 Torterra Continent grass 4 200 Torterra Continent grass 10 1050 Torterra Continent grass 14 3000 Torterra Continent grass 10 300 Torterra Continent grass 17 950 Torterra Continent grass 12 360 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 16 785 Torterra Continent grass 3 60 Torterra Continent grass 10 600 Torterra Continent grass 14 392 Torterra Continent grass 18 852 Torterra Continent grass 11 900 Torterra Continent grass 17 1200 Torterra Continent grass 9 300 Torterra Continent grass 12 300 Torterra Continent grass 3 40 Torterra Continent grass 15 1325 Torterra Continent grass 13 1 Torterra Continent grass 16 1 Torterra Continent grass 15 405 Torterra Continent grass 88 2100 Torterra Continent grass 10 324 Torterra Continent grass 16 756 Torterra Continent grass 4 65 Torterra Continent grass 13 600 Torterra Continent grass 5 104 Torterra Continent grass 12 666 Torterra Continent grass 4 25 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 20 1200 Torterra Continent grass 4 65 Torterra Continent grass 10 450 Torterra Continent grass 15 498 Torterra Continent grass 14 502 Torterra Continent grass 12 655 Torterra Continent grass 6 10 Torterra Continent grass 12 95 Torterra Continent grass 10 1150 Torterra Continent grass 19 1200 Torterra Continent grass 11 346 Torterra Continent grass 10 350 Torterra Continent grass 22 800 Torterra Continent grass 4 80 Torterra Continent grass 12 250 Torterra Continent grass 6 150 Torterra Continent grass 13 390 Torterra Continent grass 8 345 Torterra Continent grass 11 800 Torterra Continent grass 13 545 Torterra Continent grass 15 560 Torterra Continent grass 14 406 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 11 300 Torterra Continent grass 13 445 Torterra Continent grass 15 550 Torterra Continent grass 14 884 Torterra Continent grass 9 100 Torterra Continent grass 65 2350 Torterra Continent grass 25 2200 Torterra Continent grass 3 40 Torterra Continent grass 3 65 Torterra Continent grass 10 290 Torterra Continent grass 8 245 Torterra Continent grass 9 250 Torterra Continent grass 8 365 Torterra Continent grass 4 75 Torterra Continent grass 10 350 Torterra Continent grass 5 115 Torterra Continent grass 13 405 Torterra Continent grass 18 590 Torterra Continent grass 21 4600 Torterra Continent grass 17 554 Torterra Continent grass 16 526 Torterra Continent grass 20 600 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 18 33 Torterra Continent grass 40 165 Torterra Continent grass 22 2100 Torterra Continent grass 20 1220 Torterra Continent grass 4 40 Torterra Continent grass 9 64 Torterra Continent grass 12 158 Torterra Continent grass 18 1005 Torterra Continent grass 5 79 Torterra Continent grass 9 190 Torterra Continent grass 17 795 Torterra Continent grass 6 95 Torterra Continent grass 11 250 Torterra Continent grass 23 888 Torterra Continent grass 8 60 Torterra Continent grass 18 325 Torterra Continent grass 7 212 Torterra Continent grass 16 408 Torterra Continent grass 10 108 Torterra Continent grass 14 356 Torterra Continent grass 5 85 Torterra Continent grass 11 335 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 18 750 Torterra Continent grass 5 120 Torterra Continent grass 12 225 Torterra Continent grass 3 20 Torterra Continent grass 3 30 Torterra Continent grass 3 10 Torterra Continent grass 3 15 Torterra Continent grass 6 32 Torterra Continent grass 2 20 Torterra Continent grass 15 150 Torterra Continent grass 6 78 Torterra Continent grass 8 133 Torterra Continent grass 14 615 Torterra Continent grass 4 58 Torterra Continent grass 4 85 Torterra Continent grass 8 285 Torterra Continent grass 12 380 Torterra Continent grass 11 339 Torterra Continent grass 4 5 Torterra Continent grass 6 10 Torterra Continent grass 8 30 Torterra Continent grass 8 115 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 3 18 Torterra Continent grass 8 85 Torterra Continent grass 12 380 Torterra Continent grass 4 85 Torterra Continent grass 14 750 Torterra Continent grass 9 265 Torterra Continent grass 10 270 Torterra Continent grass 5 21 Torterra Continent grass 20 795 Torterra Continent grass 7 10 Torterra Continent grass 5 50 Torterra Continent grass 13 285 Torterra Continent grass 15 415 Torterra Continent grass 6 72 Torterra Continent grass 12 1258 Torterra Continent grass 15 140 Torterra Continent grass 11 648 Torterra Continent grass 92 4000 Torterra Continent grass 6 78 Torterra Continent grass 14 487 Torterra Continent grass 5 39 Torterra Continent grass 18 1180 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 6 205 Torterra Continent grass 15 540 Torterra Continent grass 9 280 Torterra Continent grass 6 88 Torterra Continent grass 18 1258 Torterra Continent grass 7 350 Torterra Continent grass 8 550 Torterra Continent grass 4 65 Torterra Continent grass 11 558 Torterra Continent grass 6 50 Torterra Continent grass 6 120 Torterra Continent grass 9 285 Torterra Continent grass 9 160 Torterra Continent grass 21 2200 Torterra Continent grass 17 505 Torterra Continent grass 6 108 Torterra Continent grass 14 350 Torterra Continent grass 18 1520 Torterra Continent grass 5 335 Torterra Continent grass 11 1200 Torterra Continent grass 6 325 Torterra Continent grass 14 712 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 12 580 Torterra Continent grass 7 210 Torterra Continent grass 14 480 Torterra Continent grass 4 60 Torterra Continent grass 6 235 Torterra Continent grass 7 214 Torterra Continent grass 12 755 Torterra Continent grass 15 468 Torterra Continent grass 19 1780 Torterra Continent grass 21 1980 Torterra Continent grass 20 1870 Torterra Continent grass 6 720 Torterra Continent grass 12 1520 Torterra Continent grass 20 2020 Torterra Continent grass 52 2160 Torterra Continent grass 38 1990 Torterra Continent grass 6 50 Torterra Continent grass 5 50 Torterra Continent grass 9 216 Torterra Continent grass 17 522 Torterra Continent grass 4 25 Torterra Continent grass 9 195 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 19 520 Torterra Continent grass 4 76 Torterra Continent grass 7 280 Torterra Continent grass 15 819 Torterra Continent grass 5 136 Torterra Continent grass 10 370 Torterra Continent grass 4 175 Torterra Continent grass 5 325 Torterra Continent grass 3 36 Torterra Continent grass 6 100 Torterra Continent grass 10 284 Torterra Continent grass 7 115 Torterra Continent grass 12 316 Torterra Continent grass 5 26 Torterra Continent grass 12 325 Torterra Continent grass 15 550 Torterra Continent grass 5 40 Torterra Continent grass 10 280 Torterra Continent grass 13 596 Torterra Continent grass 3 23 Torterra Continent grass 7 198 Torterra Continent grass 6 95 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 12 280 Torterra Continent grass 4 66 Torterra Continent grass 8 202 Torterra Continent grass 16 484 Torterra Continent grass 5 17 Torterra Continent grass 8 36 Torterra Continent grass 4 45 Torterra Continent grass 12 392 Torterra Continent grass 8 240 Torterra Continent grass 14 465 Torterra Continent grass 20 1305 Torterra Continent grass 5 55 Torterra Continent grass 8 120 Torterra Continent grass 8 12 Torterra Continent grass 6 163 Torterra Continent grass 10 405 Torterra Continent grass 15 840 Torterra Continent grass 10 864 Torterra Continent grass 23 2538 Torterra Continent grass 2 20 Torterra Continent grass 10 970 Torterra Continent grass 6 110 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 11 326 Torterra Continent grass 5 110 Torterra Continent grass 6 115 Torterra Continent grass 4 600 Torterra Continent grass 9 1200 Torterra Continent grass 21 3600 Torterra Continent grass 6 112 Torterra Continent grass 13 315 Torterra Continent grass 6 152 Torterra Continent grass 15 402 Torterra Continent grass 4 42 Torterra Continent grass 4 42 Torterra Continent grass 7 177 Torterra Continent grass 6 177 Torterra Continent grass 3 20 Torterra Continent grass 4 103 Torterra Continent grass 17 800 Torterra Continent grass 8 208 Torterra Continent grass 18 888 Torterra Continent grass 20 1300 Torterra Continent grass 145 3980 Torterra Continent grass 7 240 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 19 2200 Torterra Continent grass 5 804 Torterra Continent grass 7 306 Torterra Continent grass 9 715 Torterra Continent grass 11 50 Torterra Continent grass 7 150 Torterra Continent grass 11 153 Torterra Continent grass 20 820 Torterra Continent grass 4 513 Torterra Continent grass 13 774 Torterra Continent grass 4 12 Torterra Continent grass 11 206 Torterra Continent grass 13 403 Torterra Continent grass 27 525 Torterra Continent grass 10 1680 Torterra Continent grass 12 1540 Torterra Continent grass 4 19 Torterra Continent grass 9 236 Torterra Continent grass 6 115 Torterra Continent grass 11 328 Torterra Continent grass 5 215 Torterra Continent grass 15 1080 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 10 238 Torterra Continent grass 15 604 Torterra Continent grass 7 125 Torterra Continent grass 15 682 Torterra Continent grass 6 74 Torterra Continent grass 62 1620 Torterra Continent grass 3 8 Torterra Continent grass 10 220 Torterra Continent grass 6 23 Torterra Continent grass 11 125 Torterra Continent grass 8 150 Torterra Continent grass 16 306 Torterra Continent grass 20 1000 Torterra Continent grass 6 10 Torterra Continent grass 12 470 Torterra Continent grass 6 140 Torterra Continent grass 7 168 Torterra Continent grass 15 2565 Torterra Continent grass 8 395 Torterra Continent grass 11 876 Torterra Continent grass 14 1506 Torterra Continent grass 4 525 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 17 270 Torterra Continent grass 18 226 Torterra Continent grass 10 234 Torterra Continent grass 6 87 Torterra Continent grass 6 421 Torterra Continent grass 11 1105 Torterra Continent grass 15 1026 Torterra Continent grass 6 952 Torterra Continent grass 12 2025 Torterra Continent grass 16 5500 Torterra Continent grass 17 2300 Torterra Continent grass 18 1750 Torterra Continent grass 19 2050 Torterra Continent grass 14 400 Torterra Continent grass 20 600 Torterra Continent grass 45 3520 Torterra Continent grass 35 9500 Torterra Continent grass 70 2065 Torterra Continent grass 3 11 Torterra Continent grass 17 608 Torterra Continent grass 4 102 Torterra Continent grass 11 970 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 22 3100 Torterra Continent grass 5 62 Torterra Continent grass 9 220 Torterra Continent grass 12 550 Torterra Continent grass 4 52 Torterra Continent grass 8 230 Torterra Continent grass 17 845 Torterra Continent grass 3 20 Torterra Continent grass 6 155 Torterra Continent grass 12 249 Torterra Continent grass 5 200 Torterra Continent grass 10 315 Torterra Continent grass 3 22 Torterra Continent grass 10 255 Torterra Continent grass 5 95 Torterra Continent grass 9 305 Torterra Continent grass 14 420 Torterra Continent grass 2 12 Torterra Continent grass 9 145 Torterra Continent grass 9 315 Torterra Continent grass 16 1025 Torterra Continent grass 5 570 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 13 1495 Torterra Continent grass 2 34 Torterra Continent grass 5 65 Torterra Continent grass 9 233 Torterra Continent grass 3 55 Torterra Continent grass 12 385 Torterra Continent grass 4 39 Torterra Continent grass 7 295 Torterra Continent grass 11 335 Torterra Continent grass 4 33 Torterra Continent grass 5 93 Torterra Continent grass 3 63 Torterra Continent grass 9 299 Torterra Continent grass 12 203 Torterra Continent grass 4 12 Torterra Continent grass 12 150 Torterra Continent grass 4 55 Torterra Continent grass 12 333 Torterra Continent grass 9 44 Torterra Continent grass 9 273 Torterra Continent grass 5 39 Torterra Continent grass 10 438 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 2 6 Torterra Continent grass 4 192 Torterra Continent grass 10 380 Torterra Continent grass 5 605 Torterra Continent grass 13 1870 Torterra Continent grass 5 150 Torterra Continent grass 6 130 Torterra Continent grass 6 244 Torterra Continent grass 5 19 Torterra Continent grass 10 1080 Torterra Continent grass 7 205 Torterra Continent grass 14 560 Torterra Continent grass 19 950 Torterra Continent grass 6 1050 Torterra Continent grass 7 202 Torterra Continent grass 12 540 Torterra Continent grass 8 495 Torterra Continent grass 20 3000 Torterra Continent grass 8 120 Torterra Continent grass 13 615 Torterra Continent grass 7 230 Torterra Continent grass 13 444 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 14 270 Torterra Continent grass 4 70 Torterra Continent grass 12 240 Torterra Continent grass 10 650 Torterra Continent grass 10 505 Torterra Continent grass 22 1355 Torterra Continent grass 11 340 Torterra Continent grass 12 1800 Torterra Continent grass 17 1400 Torterra Continent grass 24 2828 Torterra Continent grass 20 1286 Torterra Continent grass 18 1386 Torterra Continent grass 16 680 Torterra Continent grass 15 380 Torterra Continent grass 19 515 Torterra Continent grass 10 255 Torterra Continent grass 8 259 Torterra Continent grass 20 425 Torterra Continent grass 25 2910 Torterra Continent grass 9 340 Torterra Continent grass 16 520 Torterra Continent grass 14 3400 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 22 1066 Torterra Continent grass 13 266 Torterra Continent grass 3 3 Torterra Continent grass 3 3 Torterra Continent grass 3 3 Torterra Continent grass 3 3 Torterra Continent grass 54 6830 Torterra Continent grass 42 3360 Torterra Continent grass 17 4300 Torterra Continent grass 37 4200 Torterra Continent grass 45 7500 Torterra Continent grass 15 856 Torterra Continent grass 4 31 Torterra Continent grass 3 14 Torterra Continent grass 15 505 Torterra Continent grass 2 21 Torterra Continent grass 32 3200 Torterra Continent grass 4 40 Torterra Continent grass 6 81 Torterra Continent grass 8 160 Torterra Continent grass 33 630 Torterra Continent grass 5 99 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 10 555 Torterra Continent grass 16 1500 Torterra Continent grass 5 59 Torterra Continent grass 8 245 Torterra Continent grass 15 946 Torterra Continent grass 5 116 Torterra Continent grass 11 270 Torterra Continent grass 4 41 Torterra Continent grass 9 147 Torterra Continent grass 12 610 Torterra Continent grass 4 101 Torterra Continent grass 11 375 Torterra Continent grass 6 105 Torterra Continent grass 11 305 Torterra Continent grass 6 110 Torterra Continent grass 10 280 Torterra Continent grass 6 135 Torterra Continent grass 10 290 Torterra Continent grass 6 233 Torterra Continent grass 11 605 Torterra Continent grass 3 21 Torterra Continent grass 6 150 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 12 290 Torterra Continent grass 8 298 Torterra Continent grass 16 795 Torterra Continent grass 4 180 Torterra Continent grass 9 1020 Torterra Continent grass 17 2600 Torterra Continent grass 4 21 Torterra Continent grass 9 105 Torterra Continent grass 3 85 Torterra Continent grass 7 404 Torterra Continent grass 11 310 Torterra Continent grass 6 125 Torterra Continent grass 12 400 Torterra Continent grass 14 870 Torterra Continent grass 5 45 Torterra Continent grass 8 170 Torterra Continent grass 15 620 Torterra Continent grass 13 555 Torterra Continent grass 14 510 Torterra Continent grass 3 25 Torterra Continent grass 5 73 Torterra Continent grass 12 205 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 4 53 Torterra Continent grass 12 585 Torterra Continent grass 25 2005 Torterra Continent grass 3 6 Torterra Continent grass 7 66 Torterra Continent grass 5 66 Torterra Continent grass 11 163 Torterra Continent grass 10 180 Torterra Continent grass 7 152 Torterra Continent grass 10 334 Torterra Continent grass 15 963 Torterra Continent grass 6 375 Torterra Continent grass 13 929 Torterra Continent grass 10 280 Torterra Continent grass 3 145 Torterra Continent grass 14 2000 Torterra Continent grass 6 118 Torterra Continent grass 11 300 Torterra Continent grass 14 140 Torterra Continent grass 5 15 Torterra Continent grass 17 765 Torterra Continent grass 7 165 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 12 810 Torterra Continent grass 5 95 Torterra Continent grass 14 320 Torterra Continent grass 6 310 Torterra Continent grass 19 1073 Torterra Continent grass 7 125 Torterra Continent grass 16 811 Torterra Continent grass 4 58 Torterra Continent grass 5 75 Torterra Continent grass 4 58 Torterra Continent grass 7 180 Torterra Continent grass 15 440 Torterra Continent grass 3 10 Torterra Continent grass 6 80 Torterra Continent grass 10 201 Torterra Continent grass 5 55 Torterra Continent grass 13 242 Torterra Continent grass 4 57 Torterra Continent grass 11 410 Torterra Continent grass 13 575 Torterra Continent grass 6 195 Torterra Continent grass 19 925 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 4 50 Torterra Continent grass 5 59 Torterra Continent grass 10 330 Torterra Continent grass 2 10 Torterra Continent grass 6 105 Torterra Continent grass 12 330 Torterra Continent grass 22 1350 Torterra Continent grass 12 316 Torterra Continent grass 1 6 Torterra Continent grass 8 143 Torterra Continent grass 6 188 Torterra Continent grass 10 1100 Torterra Continent grass 3 210 Torterra Continent grass 6 510 Torterra Continent grass 6 810 Torterra Continent grass 2 3 Torterra Continent grass 12 220 Torterra Continent grass 21 805 Torterra Continent grass 5 90 Torterra Continent grass 10 345 Torterra Continent grass 3 31 Torterra Continent grass 6 130 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 10 343 Torterra Continent grass 6 180 Torterra Continent grass 10 360 Torterra Continent grass 18 1055 Torterra Continent grass 5 85 Torterra Continent grass 26 2600 Torterra Continent grass 11 1480 Torterra Continent grass 4 77 Torterra Continent grass 8 253 Torterra Continent grass 7 110 Torterra Continent grass 9 200 Torterra Continent grass 14 355 Torterra Continent grass 16 1390 Torterra Continent grass 10 920 Torterra Continent grass 28 3300 Torterra Continent grass 5 102 Torterra Continent grass 16 700 Torterra Continent grass 16 946 Torterra Continent grass 5 105 Torterra Continent grass 15 410 Torterra Continent grass 5 90 Torterra Continent grass 12 395 NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Torterra Continent grass 14 580 Torterra Continent grass 3 330 Torterra Continent grass 8 173 Torterra Continent grass 14 500 Torterra Continent grass 18 1600 Torterra Continent grass 11 288 Torterra Continent grass 16 460 Torterra Continent grass 21 2500 Torterra Continent grass 19 2600 Torterra Continent grass 20 2000 Torterra Continent grass 15 630 Torterra Continent grass 15 610 Torterra Continent grass 32 3300 Torterra Continent grass 29 3450 Torterra Continent grass 15 680 Torterra Continent grass 30 3250 Torterra Continent grass 14 485 Torterra Continent grass 6 65 Torterra Continent grass 15 825 Torterra Continent grass 8 300 1296 rows selected. SQL> SELECT p.name, s.genus, t.type, height, 2 weight 3 FROM pokemon p, species s, types t, 4 attributes a 5 WHERE p.pokedexid = s.pokedexid and 6 s.genus = 'Continent' and 7 t.typeid = s.typeid and 8 a.pokedexid = p.pokedexid 9 ; NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 35 9500 Torterra Continent grass 22 3100 SQL> run 1 SELECT p.name, s.genus, t.type, height, 2 weight 3 FROM pokemon p, species s, types t, 4 attributes a 5 WHERE p.pokedexid = s.pokedexid and 6 s.genus = 'Continent' and 7 t.typeid = s.typeid and 8 a.pokedexid = p.pokedexid 9* NAME GENUS TYPE HEIGHT WEIGHT -------------------- -------------------- -------------------- ---------- ---------- Groudon Continent ground 35 9500 Torterra Continent grass 22 3100 SQL> SELECT p.name, s.genus, t.type, height, 2 weight, weight/height 3 FROM pokemon p, species s, types t, 4 attributes a 5 WHERE p.pokedexid = s.pokedexid and 6 s.genus = 'Continent' and 7 t.typeid = s.typeid and 8 a.pokedexid = p.pokedexid 9 ; NAME GENUS TYPE HEIGHT WEIGHT WEIGHT/HEIGHT -------------------- -------------------- -------------------- ---------- ---------- ------------- Groudon Continent ground 35 9500 271.428571 Torterra Continent grass 22 3100 140.909091 SQL> SELECT p.name AS "Pokemon", 2 s.genus, 3 t.type, 4 height, 5 weight, 6 weight/height AS RATIO 7 FROM pokemon p, species s, types t, 8 attributes a 9 WHERE p.pokedexid = s.pokedexid and 10 s.genus = 'Continent' and 11 t.typeid = s.typeid and 12 a.pokedexid = p.pokedexid 13 ; Pokemon GENUS TYPE HEIGHT WEIGHT RATIO -------------------- -------------------- -------------------- ---------- ---------- ---------- Groudon Continent ground 35 9500 271.428571 Torterra Continent grass 22 3100 140.909091 SQL> SELECT p.name AS "Pokemon", 2 s.genus, 3 t.type, 4 height, 5 weight, 6 weight/height AS Ratio 7 FROM pokemon p, species s, types t, 8 attributes a 9 WHERE p.pokedexid = s.pokedexid and 10 s.genus = 'Continent' and 11 t.typeid = s.typeid and 12 a.pokedexid = p.pokedexid 13 ; Pokemon GENUS TYPE HEIGHT WEIGHT RATIO -------------------- -------------------- -------------------- ---------- ---------- ---------- Groudon Continent ground 35 9500 271.428571 Torterra Continent grass 22 3100 140.909091 SQL> create table top100 AS 2 ( select * 3 from pokemon 4 where pokedexid <= 100 5 ); Table created. 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 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 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 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 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> SQL> SELECT p.name, 2 s.genus, 3 t.type, 4 height, 5 weight, baseexperience 6 FROM pokemon p, species s, types t, 7 attributes a 8 WHERE p.pokedexid = s.pokedexid and 9 t.typeid = s.typeid and 10 a.pokedexid = p.pokedexid 11 ; NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Bidoof Plump Mouse normal 5 200 58 Bibarel Beaver normal 10 315 116 Ambipom Long Tail normal 12 203 186 Buneary Rabbit normal 4 55 84 Lopunny Rabbit normal 12 333 178 Glameow Catty normal 5 39 71 Purugly Tiger Cat normal 10 438 183 Happiny Playhouse normal 6 244 255 Chatot Music Note normal 5 19 107 Munchlax Big Eater normal 6 1050 94 Lickilicky Licking normal 17 1400 193 Togekiss Jubilee normal 15 380 220 Porygon-Z Virtual normal 9 340 185 Regigigas Colossal normal 37 4200 220 Arceus Alpha normal 32 3200 255 Patrat Scout normal 5 116 51 Watchog Lookout normal 11 270 147 Lillipup Puppy normal 4 41 55 Herdier Loyal Dog normal 9 147 130 Stoutland Big-Hearted normal 12 610 221 Pidove Tiny Pigeon normal 3 21 53 Tranquill Wild Pigeon normal 6 150 125 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Unfezant Proud normal 12 290 215 Audino Hearing normal 11 310 390 Minccino Chinchilla normal 4 58 60 Cinccino Scarf normal 5 75 165 Deerling Season normal 6 195 67 Sawsbuck Season normal 19 925 166 Bouffalant Bash Buffalo normal 16 946 172 Rufflet Eaglet normal 5 105 70 Braviary Valiant normal 15 410 179 Meloetta Melody normal 6 65 270 Pidgey Tiny Bird normal 3 18 55 Pidgeotto Bird normal 11 300 113 Pidgeot Bird normal 15 395 172 Rattata Mouse normal 3 35 57 Raticate Mouse normal 7 185 116 Spearow Tiny Bird normal 3 20 58 Fearow Beak normal 12 380 162 Clefairy Fairy normal 6 75 68 Clefable Fairy normal 13 400 129 Jigglypuff Balloon normal 5 55 76 Wigglytuff Balloon normal 10 120 109 Meowth Scratch Cat normal 4 42 69 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Persian Classy Cat normal 10 320 148 Doduo Twin Bird normal 14 392 96 Dodrio Triple Bird normal 18 852 158 Lickitung Licking normal 12 655 127 Chansey Egg normal 11 346 255 Kangaskhan Parent normal 22 800 175 Tauros Wild Bull normal 14 884 211 Ditto Transform normal 3 40 61 Eevee Evolution normal 3 65 92 Porygon Virtual normal 8 365 130 Snorlax Sleeping normal 21 4600 154 Sentret Scout normal 8 60 57 Furret Long Body normal 18 325 116 Hoothoot Owl normal 7 212 58 Noctowl Owl normal 16 408 162 Cleffa Star Shape normal 3 30 37 Igglybuff Balloon normal 3 10 39 Togepi Spike Ball normal 3 15 74 Togetic Happiness normal 6 32 114 Aipom Long Tail normal 8 115 94 Girafarig Long Neck normal 15 415 149 Dunsparce Land Snake normal 15 140 125 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Snubbull Fairy normal 6 78 63 Granbull Fairy normal 14 487 178 Teddiursa Little Bear normal 6 88 124 Ursaring Hibernator normal 18 1258 189 Porygon2 Virtual normal 6 325 180 Stantler Big Horn normal 14 712 165 Smeargle Painter normal 12 580 106 Miltank Milk Cow normal 12 755 200 Blissey Happiness normal 15 468 255 Zigzagoon TinyRaccoon normal 4 175 60 Linoone Rushing normal 5 325 128 Taillow TinySwallow normal 3 23 59 Swellow Swallow normal 7 198 162 Slakoth Slacker normal 8 240 83 Vigoroth Wild Monkey normal 14 465 126 Slaking Lazy normal 20 1305 210 Whismur Whisper normal 6 163 68 Loudred Big Voice normal 10 405 126 Exploud Loud Noise normal 15 840 184 Azurill Polka Dot normal 2 20 33 Skitty Kitten normal 6 110 65 Delcatty Prim normal 11 326 138 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Spinda Spot Panda normal 11 50 85 Swablu Cotton Bird normal 4 12 74 Zangoose Cat Ferret normal 13 403 165 Castform Weather normal 3 8 145 Kecleon Color Swap normal 10 220 132 Starly Starling normal 3 20 56 Staravia Starling normal 6 155 113 Staraptor Predator normal 12 249 172 Mankey Pig Monkey fighting 5 280 74 Primeape Pig Monkey fighting 10 320 149 Machop Superpower fighting 8 195 75 Machoke Superpower fighting 15 705 146 Machamp Superpower fighting 16 1300 193 Hitmonlee Kicking fighting 15 498 139 Hitmonchan Punching fighting 14 502 140 Tyrogue Scuffle fighting 7 210 91 Hitmontop Handstand fighting 14 480 138 Makuhita Guts fighting 10 864 87 Hariyama Arm Thrust fighting 23 2538 184 Meditite Meditate fighting 6 112 91 Medicham Meditate fighting 13 315 153 Riolu Emanation fighting 7 202 72 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Lucario Aura fighting 12 540 204 Timburr Muscular fighting 6 125 61 Gurdurr Muscular fighting 12 400 142 Conkeldurr Muscular fighting 14 870 227 Throh Judo fighting 13 555 163 Sawk Karate fighting 14 510 163 Mienfoo Martial Arts fighting 9 200 70 Mienshao Martial Arts fighting 14 355 179 Tornadus Cyclone flying 15 630 261 Ekans Snake poison 20 69 62 Arbok Cobra poison 35 650 147 Nidoran??? Poison Pin poison 4 70 59 Nidorina Poison Pin poison 8 200 117 Nidoqueen Drill poison 13 600 194 Nidorino Poison Pin poison 9 195 118 Nidoking Drill poison 14 620 195 Zubat Bat poison 8 75 54 Golbat Bat poison 16 550 171 Grimer Sludge poison 9 300 90 Muk Sludge poison 12 300 157 Koffing Poison Gas poison 6 10 114 Weezing Poison Gas poison 12 95 173 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Crobat Bat poison 18 750 204 Gulpin Stomach poison 4 103 75 Swalot Poison Bag poison 17 800 168 Seviper Fang Snake poison 27 525 165 Stunky Skunk poison 4 192 79 Skuntank Skunk poison 10 380 209 Skorupi Scorpion poison 8 120 114 Drapion Ogre Scorp poison 13 615 204 Croagunk Toxic Mouth poison 7 230 83 Toxicroak Toxic Mouth poison 13 444 181 Trubbish Trash Bag poison 6 310 66 Garbodor Trash Heap poison 19 1073 166 Sandshrew Mouse ground 6 120 93 Sandslash Mouse ground 10 295 163 Diglett Mole ground 2 8 81 Dugtrio Mole ground 7 333 153 Cubone Lonely ground 4 65 87 Marowak Bone Keeper ground 10 450 124 Rhyhorn Spikes ground 10 1150 135 Rhydon Drill ground 19 1200 204 Gligar FlyScorpion ground 11 648 108 Phanpy Long Nose ground 5 335 124 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Donphan Armor ground 11 1200 189 Trapinch Ant Pit ground 7 150 73 Vibrava Vibration ground 11 153 126 Flygon Mystic ground 20 820 197 Baltoy Clay Doll ground 5 215 58 Claydol Clay Doll ground 15 1080 189 Groudon Continent ground 35 9500 218 Hippopotas Hippo ground 8 495 95 Hippowdon Heavyweight ground 20 3000 198 Rhyperior Drill ground 24 2828 217 Gliscor Fang Scorp ground 20 425 192 Drilbur Mole ground 3 85 66 Excadrill Subterrene ground 7 404 178 Sandile Desert Croc ground 7 152 58 Krokorok Desert Croc ground 10 334 123 Krookodile Intimidation ground 15 963 229 Stunfisk Trap ground 7 110 165 Golett Automaton ground 10 920 61 Golurk Automaton ground 28 3300 169 Landorus Abundance ground 15 680 270 Geodude Rock rock 4 200 73 Graveler Rock rock 10 1050 134 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Golem Megaton rock 14 3000 177 Onix Rock Snake rock 88 2100 108 Omanyte Spiral rock 4 75 99 Omastar Spiral rock 10 350 199 Kabuto Shellfish rock 5 115 99 Kabutops Shellfish rock 13 405 199 Aerodactyl Fossil rock 18 590 202 Sudowoodo Imitation rock 12 380 135 Larvitar Rock Skin rock 6 720 67 Pupitar Hard Shell rock 12 1520 144 Tyranitar Armor rock 20 2020 218 Nosepass Compass rock 10 970 108 Lunatone Meteorite rock 10 1680 150 Solrock Meteorite rock 12 1540 150 Lileep Sea Lily rock 10 238 99 Cradily Barnacle rock 15 604 199 Anorith Old Shrimp rock 7 125 99 Armaldo Plate rock 15 682 199 Regirock Rock Peak rock 17 2300 217 Cranidos Head Butt rock 9 315 99 Rampardos Head Butt rock 16 1025 199 Shieldon Shield rock 5 570 99 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Bastiodon Shield rock 13 1495 199 Bonsly Bonsai rock 5 150 68 Probopass Compass rock 14 3400 198 Roggenrola Mantle rock 4 180 56 Boldore Ore rock 9 1020 137 Gigalith Compressed rock 17 2600 227 Archen First Bird rock 5 95 71 Archeops First Bird rock 14 320 177 Terrakion Cavern rock 19 2600 261 Caterpie Worm bug 3 29 53 Metapod Cocoon bug 7 99 72 Butterfree Butterfly bug 11 320 160 Weedle Hairy Bug bug 3 32 52 Kakuna Cocoon bug 6 100 71 Beedrill Poison Bee bug 10 295 159 Paras Mushroom bug 3 54 70 Parasect Mushroom bug 10 295 128 Venonat Insect bug 10 300 75 Venomoth Poison Moth bug 15 125 138 Scyther Mantis bug 15 560 187 Pinsir Stag Beetle bug 15 550 200 Ledyba Five Star bug 10 108 54 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Ledian Five Star bug 14 356 134 Spinarak String Spit bug 5 85 54 Ariados Long Leg bug 11 335 134 Yanma Clear Wing bug 12 380 147 Pineco Bagworm bug 6 72 60 Forretress Bagworm bug 12 1258 118 Scizor Pincer bug 18 1180 200 Shuckle Mold bug 6 205 80 Heracross Single Horn bug 15 540 200 Wurmple Worm bug 3 36 54 Silcoon Cocoon bug 6 100 72 Beautifly Butterfly bug 10 284 161 Cascoon Cocoon bug 7 115 72 Dustox Poison Moth bug 12 316 161 Surskit Pond Skater bug 5 17 63 Masquerain Eyeball bug 8 36 128 Nincada Trainee bug 5 55 65 Ninjask Ninja bug 8 120 155 Shedinja Shed bug 8 12 95 Volbeat Firefly bug 7 177 146 Illumise Firefly bug 6 177 146 Kricketot Cricket bug 3 22 54 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Kricketune Cricket bug 10 255 159 Burmy Bagworm bug 2 34 61 Wormadam Bagworm bug 5 65 159 Mothim Moth bug 9 233 159 Combee Tiny Bee bug 3 55 63 Vespiquen Beehive bug 12 385 188 Yanmega Ogre Darner bug 19 515 198 Sewaddle Sewing bug 3 25 62 Swadloon Leaf-Wrapped bug 5 73 133 Leavanny Nurturing bug 12 205 221 Venipede Centipede bug 4 53 52 Whirlipede Curlipede bug 12 585 126 Scolipede Megapede bug 25 2005 214 Dwebble Rock Inn bug 3 145 65 Crustle Stone Home bug 14 2000 166 Karrablast Clamping bug 5 59 63 Escavalier Cavalry bug 10 330 173 Joltik Attaching bug 1 6 64 Galvantula EleSpider bug 8 143 165 Shelmet Snail bug 4 77 61 Accelgor Shell Out bug 8 253 173 Durant Iron Ant bug 3 330 169 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Larvesta Torch bug 11 288 72 Volcarona Sun bug 16 460 248 Genesect Paleozoic bug 15 825 270 Gastly Gas ghost 13 1 95 Haunter Gas ghost 16 1 126 Gengar Shadow ghost 15 405 190 Misdreavus Screech ghost 7 10 147 Shuppet Puppet ghost 6 23 97 Banette Marionette ghost 11 125 179 Duskull Requiem ghost 8 150 97 Dusclops Beckon ghost 16 306 179 Drifloon Balloon ghost 4 12 127 Drifblim Blimp ghost 12 150 204 Mismagius Magical ghost 9 44 187 Spiritomb Forbidden ghost 10 1080 168 Dusknoir Gripper ghost 22 1066 210 Giratina Renegade ghost 45 7500 220 Yamask Spirit ghost 5 15 61 Cofagrigus Coffin ghost 17 765 169 Litwick Candle ghost 3 31 55 Lampent Lamp ghost 6 130 130 Chandelure Luring ghost 10 343 234 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Steelix Iron Snake steel 92 4000 196 Skarmory Armor Bird steel 17 505 168 Mawile Deceiver steel 6 115 98 Aron Iron Armor steel 4 600 96 Lairon Iron Armor steel 9 1200 152 Aggron Iron Armor steel 21 3600 205 Beldum Iron Ball steel 6 952 103 Metang Iron Claw steel 12 2025 153 Metagross Iron Leg steel 16 5500 210 Registeel Iron steel 19 2050 215 Jirachi Wish steel 3 11 215 Bronzor Bronze steel 5 605 72 Bronzong Bronze Bell steel 13 1870 188 Dialga Temporal steel 54 6830 220 Klink Gear steel 3 210 60 Klang Gear steel 6 510 154 Klinklang Gear steel 6 810 234 Cobalion Iron Will steel 21 2500 261 Charmander Lizard fire 6 85 65 Charmeleon Flame fire 11 190 142 Charizard Flame fire 17 905 209 Vulpix Fox fire 6 99 63 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Ninetales Fox fire 11 199 178 Growlithe Puppy fire 7 190 91 Arcanine Legendary fire 19 1550 213 Ponyta Fire Horse fire 10 300 152 Rapidash Fire Horse fire 17 950 192 Magmar Spitfire fire 13 445 167 Flareon Flame fire 9 250 198 Moltres Flame fire 20 600 217 Cyndaquil Fire Mouse fire 5 79 65 Quilava Volcano fire 9 190 142 Typhlosion Volcano fire 17 795 209 Slugma Lava fire 7 350 78 Magcargo Lava fire 8 550 154 Magby Live Coal fire 7 214 117 Entei Volcano fire 21 1980 217 Ho-Oh Rainbow fire 38 1990 220 Torchic Chick fire 4 25 65 Combusken Young Fowl fire 9 195 142 Blaziken Blaze fire 19 520 209 Numel Numb fire 7 240 88 Camerupt Eruption fire 19 2200 175 Torkoal Coal fire 5 804 161 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Chimchar Chimp fire 5 62 65 Monferno Playful fire 9 220 142 Infernape Flame fire 12 550 209 Magmortar Blast fire 16 680 199 Heatran Lava Dome fire 17 4300 215 Tepig Fire Pig fire 5 99 28 Pignite Fire Pig fire 10 555 146 Emboar Mega Fire Pig fire 16 1500 238 Pansear High Temp fire 6 110 63 Simisear Ember fire 10 280 174 Darumaka Zen Charm fire 6 375 63 Darmanitan Blazing fire 13 929 168 Heatmor Anteater fire 14 580 169 Clamperl Bivalve water 4 525 142 Huntail Deep Sea water 17 270 178 Gorebyss South Sea water 18 226 178 Relicanth Longevity water 10 234 198 Luvdisc Rendezvous water 6 87 110 Kyogre Sea Basin water 45 3520 218 Piplup Penguin water 4 52 66 Prinplup Penguin water 8 230 143 Empoleon Emperor water 17 845 210 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Buizel Sea Weasel water 7 295 75 Floatzel Sea Weasel water 11 335 178 Shellos Sea Slug water 3 63 73 Gastrodon Sea Slug water 9 299 176 Finneon Wing Fish water 4 70 90 Lumineon Neon water 12 240 156 Mantyke Kite water 10 650 108 Palkia Spatial water 42 3360 220 Phione Sea Drifter water 4 31 165 Manaphy Seafaring water 3 14 215 Oshawott Sea Otter water 5 59 28 Dewott Discipline water 8 245 145 Samurott Formidable water 15 946 238 Panpour Spray water 6 135 63 Simipour Geyser water 10 290 174 Tympole Tadpole water 5 45 59 Palpitoad Vibration water 8 170 134 Seismitoad Vibration water 15 620 225 Basculin Hostile water 10 180 161 Tirtouga Prototurtle water 7 165 71 Carracosta Prototurtle water 12 810 173 Ducklett Water Bird water 5 55 61 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Swanna White Bird water 13 242 166 Frillish Floating water 12 330 67 Jellicent Floating water 22 1350 168 Alomomola Caring water 12 316 165 Keldeo Colt water 14 485 261 Squirtle Tiny Turtle water 5 90 66 Wartortle Turtle water 10 225 143 Blastoise Shellfish water 16 855 210 Psyduck Duck water 8 196 80 Golduck Duck water 17 766 174 Poliwag Tadpole water 6 124 77 Poliwhirl Tadpole water 10 200 131 Poliwrath Tadpole water 13 540 185 Tentacool Jellyfish water 9 455 105 Tentacruel Jellyfish water 16 550 205 Slowpoke Dopey water 12 360 99 Slowbro Hermit Crab water 16 785 164 Seel Sea Lion water 11 900 100 Dewgong Sea Lion water 17 1200 176 Shellder Bivalve water 3 40 97 Cloyster Bivalve water 15 1325 203 Krabby River Crab water 4 65 115 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Kingler Pincer water 13 600 206 Horsea Dragon water 4 80 83 Seadra Dragon water 12 250 155 Goldeen Goldfish water 6 150 111 Seaking Goldfish water 13 390 170 Staryu Star Shape water 8 345 106 Starmie Mysterious water 11 800 207 Magikarp Fish water 9 100 20 Gyarados Atrocious water 65 2350 214 Lapras Transport water 25 2200 219 Vaporeon Bubble Jet water 10 290 196 Totodile Big Jaw water 6 95 66 Croconaw Big Jaw water 11 250 143 Feraligatr Big Jaw water 23 888 210 Chinchou Angler water 5 120 90 Lanturn Light water 12 225 156 Marill Aqua Mouse water 4 85 58 Azumarill Aqua Rabbit water 8 285 153 Politoed Frog water 11 339 185 Wooper Water Fish water 4 85 52 Quagsire Water Fish water 14 750 137 Slowking Royal water 20 795 164 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Qwilfish Balloon water 5 39 100 Corsola Coral water 6 50 113 Remoraid Jet water 6 120 78 Octillery Jet water 9 285 164 Mantine Kite water 21 2200 168 Kingdra Dragon water 18 1520 207 Suicune Aurora water 20 1870 215 Mudkip Mud Fish water 4 76 65 Marshtomp Mud Fish water 7 280 143 Swampert Mud Fish water 15 819 210 Lotad Water Weed water 5 26 74 Lombre Jolly water 12 325 141 Ludicolo Carefree water 15 550 181 Wingull Seagull water 6 95 64 Pelipper Water Bird water 12 280 164 Carvanha Savage water 8 208 88 Sharpedo Brutal water 18 888 175 Wailmer Ball Whale water 20 1300 137 Wailord Float Whale water 145 3980 206 Barboach Whiskers water 4 19 92 Whiscash Whiskers water 9 236 158 Corphish Ruffian water 6 115 111 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Crawdaunt Rogue water 11 328 161 Feebas Fish water 6 74 61 Milotic Tender water 62 1620 213 Bulbasaur Seed grass 7 69 64 Ivysaur Seed grass 10 130 141 Venusaur Seed grass 20 1000 208 Oddish Weed grass 5 54 78 Gloom Weed grass 8 86 132 Vileplume Flower grass 12 186 184 Bellsprout Flower grass 7 40 84 Weepinbell Flycatcher grass 10 64 151 Victreebel Flycatcher grass 17 155 191 Exeggcute Egg grass 4 25 98 Exeggutor Coconut grass 20 1200 212 Tangela Vine grass 10 350 166 Chikorita Leaf grass 9 64 64 Bayleef Leaf grass 12 158 141 Meganium Herb grass 18 1005 208 Bellossom Flower grass 4 58 184 Hoppip Cottonweed grass 4 5 74 Skiploom Cottonweed grass 6 10 136 Jumpluff Cottonweed grass 8 30 176 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Sunkern Seed grass 3 18 52 Sunflora Sun grass 8 85 146 Treecko Wood Gecko grass 5 50 65 Grovyle Wood Gecko grass 9 216 141 Sceptile Forest grass 17 522 208 Seedot Acorn grass 5 40 74 Nuzleaf Wily grass 10 280 141 Shiftry Wicked grass 13 596 181 Shroomish Mushroom grass 4 45 65 Breloom Mushroom grass 12 392 165 Roselia Thorn grass 3 20 152 Cacnea Cactus grass 4 513 97 Cacturne Scarecrow grass 13 774 177 Tropius Fruit grass 20 1000 169 Turtwig Tiny Leaf grass 4 102 64 Grotle Grove grass 11 970 141 Torterra Continent grass 22 3100 208 Budew Bud grass 2 12 68 Roserade Bouquet grass 9 145 204 Cherubi Cherry grass 4 33 68 Cherrim Blossom grass 5 93 133 Carnivine Bug Catcher grass 14 270 164 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Snover Frost Tree grass 10 505 131 Abomasnow Frost Tree grass 22 1355 214 Tangrowth Vine grass 20 1286 211 Leafeon Verdant grass 10 255 196 Shaymin Gratitude grass 2 21 64 Snivy Grass Snake grass 6 81 28 Servine Grass Snake grass 8 160 145 Serperior Regal grass 33 630 238 Pansage Grass Monkey grass 6 105 63 Simisage Thorn Monkey grass 11 305 174 Cottonee Cotton Puff grass 3 6 56 Whimsicott Windveiled grass 7 66 168 Petilil Bulb grass 5 66 56 Lilligant Flowering grass 11 163 168 Maractus Cactus grass 10 280 161 Foongus Mushroom grass 2 10 59 Amoonguss Mushroom grass 6 105 162 Ferroseed Thorn Seed grass 6 188 61 Ferrothorn Thorn Pod grass 10 1100 171 Virizion Grassland grass 20 2000 261 Pikachu Mouse electric 4 60 82 Raichu Mouse electric 8 300 122 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Magnemite Magnet electric 3 60 89 Magneton Magnet electric 10 600 161 Voltorb Ball electric 5 104 103 Electrode Ball electric 12 666 150 Electabuzz Electric electric 11 300 156 Jolteon Lightning electric 8 245 197 Zapdos Electric electric 16 526 216 Pichu Tiny Mouse electric 3 20 42 Mareep Wool electric 6 78 59 Flaaffy Wool electric 8 133 117 Ampharos Light electric 14 615 194 Elekid Electric electric 6 235 106 Raikou Thunder electric 19 1780 216 Electrike Lightning electric 6 152 104 Manectric Discharge electric 15 402 168 Plusle Cheering electric 4 42 120 Minun Cheering electric 4 42 120 Shinx Flash electric 5 95 60 Luxio Spark electric 9 305 117 Luxray Gleam Eyes electric 14 420 194 Pachirisu EleSquirrel electric 4 39 120 Magnezone Magnet Area electric 12 1800 211 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Electivire Thunderbolt electric 18 1386 199 Rotom Plasma electric 3 3 132 Blitzle Electrified electric 8 298 59 Zebstrika Thunderbolt electric 16 795 174 Emolga Sky Squirrel electric 4 50 150 Tynamo EleFish electric 2 3 55 Eelektrik EleFish electric 12 220 142 Eelektross EleFish electric 21 805 232 Thundurus Bolt Strike electric 15 610 261 Abra Psi psychic 9 195 75 Kadabra Psi psychic 13 565 145 Alakazam Psi psychic 15 480 186 Drowzee Hypnosis psychic 10 324 102 Hypno Hypnosis psychic 16 756 165 Mr. Mime Barrier psychic 13 545 136 Mewtwo Genetic psychic 20 1220 220 Mew New Species psychic 4 40 64 Natu Tiny Bird psychic 2 20 73 Xatu Mystic psychic 15 150 171 Espeon Sun psychic 9 265 197 Unown Symbol psychic 5 50 61 Wobbuffet Patient psychic 13 285 177 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Lugia Diving psychic 52 2160 220 Celebi Time Travel psychic 6 50 64 Ralts Feeling psychic 4 66 70 Kirlia Emotion psychic 8 202 140 Gardevoir Embrace psychic 16 484 208 Spoink Bounce psychic 7 306 89 Grumpig Manipulate psychic 9 715 164 Chimecho Wind Chime psychic 6 10 147 Wynaut Bright psychic 6 140 44 Deoxys DNA psychic 17 608 215 Chingling Bell psychic 2 6 74 Mime Jr. Mime psychic 6 130 78 Gallade Blade psychic 16 520 208 Uxie Knowledge psychic 3 3 210 Mesprit Emotion psychic 3 3 210 Azelf Willpower psychic 3 3 210 Cresselia Lunar psychic 15 856 210 Victini Victory psychic 4 40 270 Munna Dream Eater psychic 6 233 58 Musharna Drowsing psychic 11 605 170 Woobat Bat psychic 4 21 63 Swoobat Courting psychic 9 105 149 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Sigilyph Avianoid psychic 14 140 172 Gothita Fixation psychic 4 58 58 Gothorita Manipulate psychic 7 180 137 Gothitelle Astral Body psychic 15 440 221 Solosis Cell psychic 3 10 58 Duosion Mitosis psychic 6 80 130 Reuniclus Multiplying psychic 10 201 221 Elgyem Cerebral psychic 5 90 67 Beheeyem Cerebral psychic 10 345 170 CS365chu Database psychic 8 300 200 Jynx Human Shape ice 14 406 137 Articuno Freeze ice 17 554 215 Swinub Pig ice 4 65 78 Piloswine Swine ice 11 558 160 Delibird Delivery ice 9 160 183 Smoochum Kiss ice 4 60 87 Snorunt Snow Hat ice 7 168 74 Glalie Face ice 15 2565 187 Spheal Clap ice 8 395 75 Sealeo Ball Roll ice 11 876 128 Walrein Ice Break ice 14 1506 192 Regice Iceberg ice 18 1750 216 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Glaceon Fresh Snow ice 8 259 196 Mamoswine Twin Tusk ice 25 2910 207 Froslass Snow Land ice 13 266 187 Vanillite Fresh Snow ice 4 57 61 Vanillish Icy Snow ice 11 410 138 Vanilluxe Snowstorm ice 13 575 241 Cubchoo Chill ice 5 85 61 Beartic Freezing ice 26 2600 170 Cryogonal Crystallizing ice 11 1480 170 Dratini Dragon dragon 18 33 67 Dragonair Dragon dragon 40 165 144 Dragonite Dragon dragon 22 2100 218 Altaria Humming dragon 11 206 188 Bagon Rock Head dragon 6 421 89 Shelgon Endurance dragon 11 1105 144 Salamence Dragon dragon 15 1026 218 Latias Eon dragon 14 400 211 Latios Eon dragon 20 600 211 Rayquaza Sky High dragon 70 2065 220 Gible Land Shark dragon 7 205 67 Gabite Cave dragon 14 560 144 Garchomp Mach dragon 19 950 218 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Axew Tusk dragon 6 180 64 Fraxure Axe Jaw dragon 10 360 144 Haxorus Axe Jaw dragon 18 1055 243 Druddigon Cave dragon 16 1390 170 Reshiram Vast White dragon 32 3300 306 Zekrom Deep Black dragon 29 3450 306 Kyurem Boundary dragon 30 3250 297 Umbreon Moonlight dark 10 270 197 Murkrow Darkness dark 5 21 107 Sneasel Sharp Claw dark 9 280 132 Houndour Dark dark 6 108 114 Houndoom Dark dark 14 350 204 Poochyena Bite dark 5 136 55 Mightyena Bite dark 10 370 128 Sableye Darkness dark 5 110 98 Absol Disaster dark 12 470 174 Honchkrow Big Boss dark 9 273 187 Weavile Sharp Claw dark 11 340 199 Darkrai Pitch-Black dark 15 505 210 Purrloin Devious dark 4 101 56 Liepard Cruel dark 11 375 156 Scraggy Shedding dark 6 118 70 NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Scrafty Hoodlum dark 11 300 171 Zorua Tricky Fox dark 7 125 66 Zoroark Illusion Fox dark 16 811 179 Pawniard Sharp Blade dark 5 102 68 Bisharp Sword Blade dark 16 700 172 Vullaby Diapered dark 5 90 74 Mandibuzz Bone Vulture dark 12 395 179 Deino Irate dark 8 173 60 Zweilous Hostile dark 14 500 147 Hydreigon Brutal dark 18 1600 270 648 rows selected. SQL> create table combo as ( 2 SELECT p.name, 3 s.genus, 4 t.type, 5 height, 6 weight, baseexperience 7 FROM pokemon p, species s, types t, 8 attributes a 9 WHERE p.pokedexid = s.pokedexid and 10 t.typeid = s.typeid and 11 a.pokedexid = p.pokedexid 12 ) 13 ; Table created. SQL> SQL> create table heavy 2 as (select name, genus, type 3 from combo 4 where weight = 2500 5 ); Table created. SQL> select * from heavy; NAME GENUS TYPE -------------------- -------------------- -------------------- Cobalion Iron Will steel SQL> select weight from combo; WEIGHT ---------- 200 315 203 55 333 39 438 244 19 1050 1400 380 340 4200 3200 116 270 41 147 610 21 150 WEIGHT ---------- 290 310 58 75 195 925 946 105 410 65 18 300 395 35 185 20 380 75 400 55 120 42 WEIGHT ---------- 320 392 852 655 346 800 884 40 65 365 4600 60 325 212 408 30 10 15 32 115 415 140 WEIGHT ---------- 78 487 88 1258 325 712 580 755 468 175 325 23 198 240 465 1305 163 405 840 20 110 326 WEIGHT ---------- 50 12 403 8 220 20 155 249 280 320 195 705 1300 498 502 210 480 864 2538 112 315 202 WEIGHT ---------- 540 125 400 870 555 510 200 355 630 69 650 70 200 600 195 620 75 550 300 300 10 95 WEIGHT ---------- 750 103 800 525 192 380 120 615 230 444 310 1073 120 295 8 333 65 450 1150 1200 648 335 WEIGHT ---------- 1200 150 153 820 215 1080 9500 495 3000 2828 425 85 404 152 334 963 110 920 3300 680 200 1050 WEIGHT ---------- 3000 2100 75 350 115 405 590 380 720 1520 2020 970 1680 1540 238 604 125 682 2300 315 1025 570 WEIGHT ---------- 1495 150 3400 180 1020 2600 95 320 2600 29 99 320 32 100 295 54 295 300 125 560 550 108 WEIGHT ---------- 356 85 335 380 72 1258 1180 205 540 36 100 284 115 316 17 36 55 120 12 177 177 22 WEIGHT ---------- 255 34 65 233 55 385 515 25 73 205 53 585 2005 145 2000 59 330 6 143 77 253 330 WEIGHT ---------- 288 460 825 1 1 405 10 23 125 150 306 12 150 44 1080 1066 7500 15 765 31 130 343 WEIGHT ---------- 4000 505 115 600 1200 3600 952 2025 5500 2050 11 605 1870 6830 210 510 810 2500 85 190 905 99 WEIGHT ---------- 199 190 1550 300 950 445 250 600 79 190 795 350 550 214 1980 1990 25 195 520 240 2200 804 WEIGHT ---------- 62 220 550 680 4300 99 555 1500 110 280 375 929 580 525 270 226 234 87 3520 52 230 845 WEIGHT ---------- 295 335 63 299 70 240 650 3360 31 14 59 245 946 135 290 45 170 620 180 165 810 55 WEIGHT ---------- 242 330 1350 316 485 90 225 855 196 766 124 200 540 455 550 360 785 900 1200 40 1325 65 WEIGHT ---------- 600 80 250 150 390 345 800 100 2350 2200 290 95 250 888 120 225 85 285 339 85 750 795 WEIGHT ---------- 39 50 120 285 2200 1520 1870 76 280 819 26 325 550 95 280 208 888 1300 3980 19 236 115 WEIGHT ---------- 328 74 1620 69 130 1000 54 86 186 40 64 155 25 1200 350 64 158 1005 58 5 10 30 WEIGHT ---------- 18 85 50 216 522 40 280 596 45 392 20 513 774 1000 102 970 3100 12 145 33 93 270 WEIGHT ---------- 505 1355 1286 255 21 81 160 630 105 305 6 66 66 163 280 10 105 188 1100 2000 60 300 WEIGHT ---------- 60 600 104 666 300 245 526 20 78 133 615 235 1780 152 402 42 42 95 305 420 39 1800 WEIGHT ---------- 1386 3 298 795 50 3 220 805 610 195 565 480 324 756 545 1220 40 20 150 265 50 285 WEIGHT ---------- 2160 50 66 202 484 306 715 10 140 608 6 130 520 3 3 3 856 40 233 605 21 105 WEIGHT ---------- 140 58 180 440 10 80 201 90 345 300 406 554 65 558 160 60 168 2565 395 876 1506 1750 WEIGHT ---------- 259 2910 266 57 410 575 85 2600 1480 33 165 2100 206 421 1105 1026 400 600 2065 205 560 950 WEIGHT ---------- 180 360 1055 1390 3300 3450 3250 270 21 280 108 350 136 370 110 470 273 340 505 101 375 118 WEIGHT ---------- 300 125 811 102 700 90 395 173 500 1600 648 rows selected. SQL> drop table heavy; Table dropped. SQL> SQL> create table heavy 2 as (select name, genus, type 3 from combo 4 where weight >= 2500 5 ); Table created. 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 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 height from combo order by height; HEIGHT ---------- 1 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 HEIGHT ---------- 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 HEIGHT ---------- 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 HEIGHT ---------- 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 HEIGHT ---------- 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5 5 5 5 HEIGHT ---------- 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 HEIGHT ---------- 5 5 5 5 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 HEIGHT ---------- 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 HEIGHT ---------- 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 HEIGHT ---------- 6 6 6 6 6 6 6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 HEIGHT ---------- 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 8 8 8 HEIGHT ---------- 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 HEIGHT ---------- 8 8 8 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 9 9 9 HEIGHT ---------- 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 10 10 10 HEIGHT ---------- 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 HEIGHT ---------- 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 HEIGHT ---------- 10 10 10 10 10 10 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 HEIGHT ---------- 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 12 12 12 HEIGHT ---------- 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 HEIGHT ---------- 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 13 13 13 13 13 HEIGHT ---------- 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 13 14 14 14 HEIGHT ---------- 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 14 HEIGHT ---------- 14 14 14 14 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 HEIGHT ---------- 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 15 16 16 16 16 16 HEIGHT ---------- 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 16 17 17 17 17 17 HEIGHT ---------- 17 17 17 17 17 17 17 17 17 17 17 17 17 18 18 18 18 18 18 18 18 18 HEIGHT ---------- 18 18 18 18 18 18 19 19 19 19 19 19 19 19 19 19 19 20 20 20 20 20 HEIGHT ---------- 20 20 20 20 20 20 20 20 20 20 20 20 21 21 21 21 21 21 22 22 22 22 HEIGHT ---------- 22 22 23 23 24 25 25 25 26 27 28 29 30 32 32 33 35 35 37 38 40 42 HEIGHT ---------- 45 45 52 54 62 65 70 88 92 145 648 rows selected. SQL> create table tall 2 as (select name, genus, type 3 from combo 4 where height >= 35 5 ); Table created. SQL> select * from height; select * from height * ERROR at line 1: ORA-00942: table or view does not exist 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 Wailord Float Whale water Milotic Tender water Lugia Diving psychic Dragonair Dragon dragon Rayquaza Sky High dragon 16 rows selected. SQL> SQL> create table dragons 2 as (select name, genus, type 3 from combo where 4 type = 'dragon') 5 ; Table created. SQL> select * from dragons; NAME GENUS TYPE -------------------- -------------------- -------------------- Dratini Dragon dragon Dragonair Dragon dragon Dragonite Dragon dragon Altaria Humming dragon Bagon Rock Head dragon Shelgon Endurance dragon Salamence Dragon dragon Latias Eon dragon Latios Eon dragon Rayquaza Sky High dragon Gible Land Shark dragon Gabite Cave dragon Garchomp Mach dragon Axew Tusk dragon Fraxure Axe Jaw dragon Haxorus Axe Jaw dragon Druddigon Cave dragon Reshiram Vast White dragon Zekrom Deep Black dragon Kyurem Boundary dragon 20 rows selected. SQL> select * from combo where name = 'Pikachu'; NAME GENUS TYPE HEIGHT WEIGHT BASEEXPERIENCE -------------------- -------------------- -------------------- ---------- ---------- -------------- Pikachu Mouse electric 4 60 82 SQL> Tall UNION Heavy; SP2-0734: unknown command beginning "Tall UNION..." - rest of line ignored. SQL> (select * from tall) 2 UNION 3 (select * from Heavy) 4 ; NAME GENUS TYPE -------------------- -------------------- -------------------- Aggron Iron Armor steel Arbok Cobra poison Arceus Alpha normal Beartic Freezing ice Cobalion Iron Will steel Dialga Temporal steel Dragonair Dragon dragon Gigalith Compressed rock Giratina Renegade ghost Glalie Face ice Golem Megaton rock Golurk Automaton ground Groudon Continent ground Gyarados Atrocious water Hariyama Arm Thrust fighting Heatran Lava Dome fire Hippowdon Heavyweight ground Ho-Oh Rainbow fire Kyogre Sea Basin water Kyurem Boundary dragon Lugia Diving psychic Mamoswine Twin Tusk ice NAME GENUS TYPE -------------------- -------------------- -------------------- Metagross Iron Leg steel Milotic Tender water Onix Rock Snake rock Palkia Spatial water Probopass Compass rock Rayquaza Sky High dragon Regigigas Colossal normal Reshiram Vast White dragon Rhyperior Drill ground Snorlax Sleeping normal Steelix Iron Snake steel Terrakion Cavern rock Torterra Continent grass Wailord Float Whale water Zekrom Deep Black dragon 37 rows selected. SQL> select type from dragons; TYPE -------------------- dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon dragon 20 rows selected. SQL> select DIStinct type from dragons; TYPE -------------------- dragon SQL> (select distinct * from tall) 2 UNION 3 (select distinct * from Heavy) 4 ; NAME GENUS TYPE -------------------- -------------------- -------------------- Aggron Iron Armor steel Arbok Cobra poison Arceus Alpha normal Beartic Freezing ice Cobalion Iron Will steel Dialga Temporal steel Dragonair Dragon dragon Gigalith Compressed rock Giratina Renegade ghost Glalie Face ice Golem Megaton rock Golurk Automaton ground Groudon Continent ground Gyarados Atrocious water Hariyama Arm Thrust fighting Heatran Lava Dome fire Hippowdon Heavyweight ground Ho-Oh Rainbow fire Kyogre Sea Basin water Kyurem Boundary dragon Lugia Diving psychic Mamoswine Twin Tusk ice NAME GENUS TYPE -------------------- -------------------- -------------------- Metagross Iron Leg steel Milotic Tender water Onix Rock Snake rock Palkia Spatial water Probopass Compass rock Rayquaza Sky High dragon Regigigas Colossal normal Reshiram Vast White dragon Rhyperior Drill ground Snorlax Sleeping normal Steelix Iron Snake steel Terrakion Cavern rock Torterra Continent grass Wailord Float Whale water Zekrom Deep Black dragon 37 rows selected. SQL> SQL> (select distinct * from tall) 2 intersect 3 (select distinct * from heavy) 4 ; NAME GENUS TYPE -------------------- -------------------- -------------------- Dialga Temporal steel Giratina Renegade ghost Groudon Continent ground Kyogre Sea Basin water Palkia Spatial water Regigigas Colossal normal Steelix Iron Snake steel Wailord Float Whale water 8 rows selected. SQL> (select * from tall) 2 UNION DISTINCT 3 (select * from Heavy) 4 ; UNION DISTINCT * ERROR at line 2: ORA-00928: missing SELECT keyword SQL> SQL> select distinct * from 2 ( 3 (select * from tall) 4 UNION 5 (select * from Heavy) 6 ) 7 ; NAME GENUS TYPE -------------------- -------------------- -------------------- Aggron Iron Armor steel Arbok Cobra poison Arceus Alpha normal Beartic Freezing ice Cobalion Iron Will steel Dialga Temporal steel Dragonair Dragon dragon Gigalith Compressed rock Giratina Renegade ghost Glalie Face ice Golem Megaton rock Golurk Automaton ground Groudon Continent ground Gyarados Atrocious water Hariyama Arm Thrust fighting Heatran Lava Dome fire Hippowdon Heavyweight ground Ho-Oh Rainbow fire Kyogre Sea Basin water Kyurem Boundary dragon Lugia Diving psychic Mamoswine Twin Tusk ice NAME GENUS TYPE -------------------- -------------------- -------------------- Metagross Iron Leg steel Milotic Tender water Onix Rock Snake rock Palkia Spatial water Probopass Compass rock Rayquaza Sky High dragon Regigigas Colossal normal Reshiram Vast White dragon Rhyperior Drill ground Snorlax Sleeping normal Steelix Iron Snake steel Terrakion Cavern rock Torterra Continent grass Wailord Float Whale water Zekrom Deep Black dragon 37 rows selected. SQL> (select * from tall) 2 UNION 3 (select * from Heavy) 4 order by type 5 ; order by type * ERROR at line 4: ORA-00904: "TYPE": invalid identifier SQL> (select * from tall) 2 UNION 3 (select * from Heavy 4 order by type 5 ) 6 ; order by type * ERROR at line 4: ORA-00907: missing right parenthesis SQL> (select * from tall 2 order by type) 3 UNION 4 (select * from Heavy 5 ) 6 ; order by type) * ERROR at line 2: ORA-00907: missing right parenthesis SQL> SQL> (select * from heavy) 2 EXCEPT 3 (select * from tall) 4 ; EXCEPT * ERROR at line 2: ORA-00933: SQL command not properly ended SQL> (select * from heavy) 2 MINUS 3 (select * from tall) 4 ; NAME GENUS TYPE -------------------- -------------------- -------------------- Aggron Iron Armor steel Arceus Alpha normal Beartic Freezing ice Cobalion Iron Will steel Gigalith Compressed rock Glalie Face ice Golem Megaton rock Golurk Automaton ground Hariyama Arm Thrust fighting Heatran Lava Dome fire Hippowdon Heavyweight ground Kyurem Boundary dragon Mamoswine Twin Tusk ice Metagross Iron Leg steel Probopass Compass rock Reshiram Vast White dragon Rhyperior Drill ground Snorlax Sleeping normal Terrakion Cavern rock Torterra Continent grass Zekrom Deep Black dragon 21 rows selected. SQL> SQL> (select distinct * from tall 2 where type <> 'ice') 3 intersect 4 (select distinct * from heavy) 5 ; NAME GENUS TYPE -------------------- -------------------- -------------------- Dialga Temporal steel Giratina Renegade ghost Groudon Continent ground Kyogre Sea Basin water Palkia Spatial water Regigigas Colossal normal Steelix Iron Snake steel Wailord Float Whale water 8 rows selected. SQL> exit