SQL> set linesize 200 SQL> set pagesize 25 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 647 rows selected. SQL> select * 2 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 647 rows selected. SQL> select * 2 from pokemon 3 where POKEDEXID < 10; POKEDEXID NAME ---------- -------------------- 1 Bulbasaur 2 Ivysaur 3 Venusaur 4 Charmander 5 Charmeleon 6 Charizard 7 Squirtle 8 Wartortle 9 Blastoise 9 rows selected. SQL> select name 2 from pokemon 3 where pokedexid <= 15; NAME -------------------- Bulbasaur Ivysaur Venusaur Charmander Charmeleon Charizard Squirtle Wartortle Blastoise Caterpie Metapod Butterfree Weedle Kakuna Beedrill 15 rows selected. SQL> select name 2 from pokemon 3 where pokedexid <=15 4 order by name 5 ; NAME -------------------- Beedrill Blastoise Bulbasaur Butterfree Caterpie Charizard Charmander Charmeleon Ivysaur Kakuna Metapod Squirtle Venusaur Wartortle Weedle 15 rows selected. SQL> list 1 select name 2 from pokemon 3 where pokedexid <=15 4 order by name 5* SQL> select name 2 from pokemon 3 where pokedexid <= 15 4 order by name DESC 5 ; NAME -------------------- Weedle Wartortle Venusaur Squirtle Metapod Kakuna Ivysaur Charmeleon Charmander Charizard Caterpie Butterfree Bulbasaur Blastoise Beedrill 15 rows selected. SQL> select * 2 from pokemon 3 where pokedexid = 150; POKEDEXID NAME ---------- -------------------- 150 Mewtwo SQL> select * 2 from pokemon 3 where Name = 'Abra' 4 ; POKEDEXID NAME ---------- -------------------- 63 Abra SQL> select * from attributes where pokedexid<15; POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- ---------- ---------- -------------- 1 7 69 64 2 10 130 141 3 20 1000 208 4 6 85 65 5 11 190 142 6 17 905 209 7 5 90 66 8 10 225 143 9 16 855 210 10 3 29 53 11 7 99 72 12 11 320 160 13 3 32 52 14 6 100 71 14 rows selected. SQL> select table_name from user_tables; TABLE_NAME ------------------------------ CONTINENTS LIST MODELS CAMPUSES CARMAKERS COUNTRIES MAKES CARDATA ST SHARKS AIRPORTS MARATHON FACULTY DISCENR DISCIPLINES ENROLLMENTS DEGREES FEES FLIGHTS AIRLINES TEACHERS LEAGUES TABLE_NAME ------------------------------ ATTENDANCE T ST01 NOPKEY PK ROOMS CUSTOMERS MINEFIELD RECEIPTS ITEMS FOO1 BEERS MYBOOKS BEERS1 FOO2 FOO3 FOO4 FOO5 BARS DRINKS BEERS2 LIKETEST TABLE_NAME ------------------------------ TIMES CHECKIN FOOBAR ATT2007 SEARCH KODIE CNTR ATTN LOCATIONS STUFF VECTORPAIRS VECTORS FST AGGS PTS MYLIST ALLELES MYVECTORS CC SPECIES ATTRIBUTES TYPES TABLE_NAME ------------------------------ ANEW POKEMON EVOLUTION REACTORS 70 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 647 rows selected. SQL> select table_name from user_tables; TABLE_NAME ------------------------------ CONTINENTS LIST MODELS CAMPUSES CARMAKERS COUNTRIES MAKES CARDATA ST SHARKS AIRPORTS MARATHON FACULTY DISCENR DISCIPLINES ENROLLMENTS DEGREES FEES FLIGHTS AIRLINES TEACHERS LEAGUES TABLE_NAME ------------------------------ ATTENDANCE T ST01 NOPKEY PK ROOMS CUSTOMERS MINEFIELD RECEIPTS ITEMS FOO1 BEERS MYBOOKS BEERS1 FOO2 FOO3 FOO4 FOO5 BARS DRINKS BEERS2 LIKETEST TABLE_NAME ------------------------------ TIMES CHECKIN FOOBAR ATT2007 SEARCH KODIE CNTR ATTN LOCATIONS STUFF VECTORPAIRS VECTORS FST AGGS PTS MYLIST ALLELES MYVECTORS CC SPECIES ATTRIBUTES TYPES TABLE_NAME ------------------------------ ANEW POKEMON EVOLUTION REACTORS 70 rows selected. SQL> select * from stuff; ID VAL ---------- ---------- 1 2 4 SQL> select * from cntr; A B C ---------- ---------- ---------- 1 2 3 4 5 6 3 2 5 SQL> select * 2 from stuff, cntr; ID VAL A B C ---------- ---------- ---------- ---------- ---------- 1 2 1 2 3 1 2 4 5 6 1 2 3 2 5 4 1 2 3 4 4 5 6 4 3 2 5 6 rows selected. SQL> select stuff.ID, stuff.val 2 from stuff, cntr 3 ; ID VAL ---------- ---------- 1 2 1 2 1 2 4 4 4 6 rows selected. SQL> select DISTINCT stuff.id, stuff.val 2 from stuff, cntr 3 ; ID VAL ---------- ---------- 4 1 2 SQL> select * from 2 pokemon, attributes 3 where pokemon.pokedexid = attributes.pokedexid and pokemon.pokedexid <= 15; POKEDEXID NAME POKEDEXID HEIGHT WEIGHT BASEEXPERIENCE ---------- -------------------- ---------- ---------- ---------- -------------- 1 Bulbasaur 1 7 69 64 2 Ivysaur 2 10 130 141 3 Venusaur 3 20 1000 208 4 Charmander 4 6 85 65 5 Charmeleon 5 11 190 142 6 Charizard 6 17 905 209 7 Squirtle 7 5 90 66 8 Wartortle 8 10 225 143 9 Blastoise 9 16 855 210 10 Caterpie 10 3 29 53 11 Metapod 11 7 99 72 12 Butterfree 12 11 320 160 13 Weedle 13 3 32 52 14 Kakuna 14 6 100 71 15 Beedrill 15 10 295 159 15 rows selected. SQL> select name, height, weight, baseexperience 2 from pokemon p, attributes a 3 where p.name = 'Pikachu' 4 ; NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 7 69 64 Pikachu 10 130 141 Pikachu 20 1000 208 Pikachu 6 85 65 Pikachu 11 190 142 Pikachu 17 905 209 Pikachu 5 90 66 Pikachu 10 225 143 Pikachu 16 855 210 Pikachu 3 29 53 Pikachu 7 99 72 Pikachu 11 320 160 Pikachu 3 32 52 Pikachu 6 100 71 Pikachu 10 295 159 Pikachu 3 18 55 Pikachu 11 300 113 Pikachu 15 395 172 Pikachu 3 35 57 Pikachu 7 185 116 Pikachu 3 20 58 Pikachu 12 380 162 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 20 69 62 Pikachu 35 650 147 Pikachu 4 60 82 Pikachu 8 300 122 Pikachu 6 120 93 Pikachu 10 295 163 Pikachu 4 70 59 Pikachu 8 200 117 Pikachu 13 600 194 Pikachu 9 195 118 Pikachu 14 620 195 Pikachu 6 75 68 Pikachu 13 400 129 Pikachu 6 99 63 Pikachu 11 199 178 Pikachu 5 55 76 Pikachu 10 120 109 Pikachu 8 75 54 Pikachu 16 550 171 Pikachu 5 54 78 Pikachu 8 86 132 Pikachu 12 186 184 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 3 54 70 Pikachu 10 295 128 Pikachu 10 300 75 Pikachu 15 125 138 Pikachu 2 8 81 Pikachu 7 333 153 Pikachu 4 42 69 Pikachu 10 320 148 Pikachu 8 196 80 Pikachu 17 766 174 Pikachu 5 280 74 Pikachu 10 320 149 Pikachu 7 190 91 Pikachu 19 1550 213 Pikachu 6 124 77 Pikachu 10 200 131 Pikachu 13 540 185 Pikachu 9 195 75 Pikachu 13 565 145 Pikachu 15 480 186 Pikachu 8 195 75 Pikachu 15 705 146 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 16 1300 193 Pikachu 7 40 84 Pikachu 10 64 151 Pikachu 17 155 191 Pikachu 9 455 105 Pikachu 16 550 205 Pikachu 4 200 73 Pikachu 10 1050 134 Pikachu 14 3000 177 Pikachu 10 300 152 Pikachu 17 950 192 Pikachu 12 360 99 Pikachu 16 785 164 Pikachu 3 60 89 Pikachu 10 600 161 Pikachu 14 392 96 Pikachu 18 852 158 Pikachu 11 900 100 Pikachu 17 1200 176 Pikachu 9 300 90 Pikachu 12 300 157 Pikachu 3 40 97 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 15 1325 203 Pikachu 13 1 95 Pikachu 16 1 126 Pikachu 15 405 190 Pikachu 88 2100 108 Pikachu 10 324 102 Pikachu 16 756 165 Pikachu 4 65 115 Pikachu 13 600 206 Pikachu 5 104 103 Pikachu 12 666 150 Pikachu 4 25 98 Pikachu 20 1200 212 Pikachu 4 65 87 Pikachu 10 450 124 Pikachu 15 498 139 Pikachu 14 502 140 Pikachu 12 655 127 Pikachu 6 10 114 Pikachu 12 95 173 Pikachu 10 1150 135 Pikachu 19 1200 204 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 11 346 255 Pikachu 10 350 166 Pikachu 22 800 175 Pikachu 4 80 83 Pikachu 12 250 155 Pikachu 6 150 111 Pikachu 13 390 170 Pikachu 8 345 106 Pikachu 11 800 207 Pikachu 13 545 136 Pikachu 15 560 187 Pikachu 14 406 137 Pikachu 11 300 156 Pikachu 13 445 167 Pikachu 15 550 200 Pikachu 14 884 211 Pikachu 9 100 20 Pikachu 65 2350 214 Pikachu 25 2200 219 Pikachu 3 40 61 Pikachu 3 65 92 Pikachu 10 290 196 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 8 245 197 Pikachu 9 250 198 Pikachu 8 365 130 Pikachu 4 75 99 Pikachu 10 350 199 Pikachu 5 115 99 Pikachu 13 405 199 Pikachu 18 590 202 Pikachu 21 4600 154 Pikachu 17 554 215 Pikachu 16 526 216 Pikachu 20 600 217 Pikachu 18 33 67 Pikachu 40 165 144 Pikachu 22 2100 218 Pikachu 20 1220 220 Pikachu 4 40 64 Pikachu 9 64 64 Pikachu 12 158 141 Pikachu 18 1005 208 Pikachu 5 79 65 Pikachu 9 190 142 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 17 795 209 Pikachu 6 95 66 Pikachu 11 250 143 Pikachu 23 888 210 Pikachu 8 60 57 Pikachu 18 325 116 Pikachu 7 212 58 Pikachu 16 408 162 Pikachu 10 108 54 Pikachu 14 356 134 Pikachu 5 85 54 Pikachu 11 335 134 Pikachu 18 750 204 Pikachu 5 120 90 Pikachu 12 225 156 Pikachu 3 20 42 Pikachu 3 30 37 Pikachu 3 10 39 Pikachu 3 15 74 Pikachu 6 32 114 Pikachu 2 20 73 Pikachu 15 150 171 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 6 78 59 Pikachu 8 133 117 Pikachu 14 615 194 Pikachu 4 58 184 Pikachu 4 85 58 Pikachu 8 285 153 Pikachu 12 380 135 Pikachu 11 339 185 Pikachu 4 5 74 Pikachu 6 10 136 Pikachu 8 30 176 Pikachu 8 115 94 Pikachu 3 18 52 Pikachu 8 85 146 Pikachu 12 380 147 Pikachu 4 85 52 Pikachu 14 750 137 Pikachu 9 265 197 Pikachu 10 270 197 Pikachu 5 21 107 Pikachu 20 795 164 Pikachu 7 10 147 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 5 50 61 Pikachu 13 285 177 Pikachu 15 415 149 Pikachu 6 72 60 Pikachu 12 1258 118 Pikachu 15 140 125 Pikachu 11 648 108 Pikachu 92 4000 196 Pikachu 6 78 63 Pikachu 14 487 178 Pikachu 5 39 100 Pikachu 18 1180 200 Pikachu 6 205 80 Pikachu 15 540 200 Pikachu 9 280 132 Pikachu 6 88 124 Pikachu 18 1258 189 Pikachu 7 350 78 Pikachu 8 550 154 Pikachu 4 65 78 Pikachu 11 558 160 Pikachu 6 50 113 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 6 120 78 Pikachu 9 285 164 Pikachu 9 160 183 Pikachu 21 2200 168 Pikachu 17 505 168 Pikachu 6 108 114 Pikachu 14 350 204 Pikachu 18 1520 207 Pikachu 5 335 124 Pikachu 11 1200 189 Pikachu 6 325 180 Pikachu 14 712 165 Pikachu 12 580 106 Pikachu 7 210 91 Pikachu 14 480 138 Pikachu 4 60 87 Pikachu 6 235 106 Pikachu 7 214 117 Pikachu 12 755 200 Pikachu 15 468 255 Pikachu 19 1780 216 Pikachu 21 1980 217 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 20 1870 215 Pikachu 6 720 67 Pikachu 12 1520 144 Pikachu 20 2020 218 Pikachu 52 2160 220 Pikachu 38 1990 220 Pikachu 6 50 64 Pikachu 5 50 65 Pikachu 9 216 141 Pikachu 17 522 208 Pikachu 4 25 65 Pikachu 9 195 142 Pikachu 19 520 209 Pikachu 4 76 65 Pikachu 7 280 143 Pikachu 15 819 210 Pikachu 5 136 55 Pikachu 10 370 128 Pikachu 4 175 60 Pikachu 5 325 128 Pikachu 3 36 54 Pikachu 6 100 72 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 10 284 161 Pikachu 7 115 72 Pikachu 12 316 161 Pikachu 5 26 74 Pikachu 12 325 141 Pikachu 15 550 181 Pikachu 5 40 74 Pikachu 10 280 141 Pikachu 13 596 181 Pikachu 3 23 59 Pikachu 7 198 162 Pikachu 6 95 64 Pikachu 12 280 164 Pikachu 4 66 70 Pikachu 8 202 140 Pikachu 16 484 208 Pikachu 5 17 63 Pikachu 8 36 128 Pikachu 4 45 65 Pikachu 12 392 165 Pikachu 8 240 83 Pikachu 14 465 126 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 20 1305 210 Pikachu 5 55 65 Pikachu 8 120 155 Pikachu 8 12 95 Pikachu 6 163 68 Pikachu 10 405 126 Pikachu 15 840 184 Pikachu 10 864 87 Pikachu 23 2538 184 Pikachu 2 20 33 Pikachu 10 970 108 Pikachu 6 110 65 Pikachu 11 326 138 Pikachu 5 110 98 Pikachu 6 115 98 Pikachu 4 600 96 Pikachu 9 1200 152 Pikachu 21 3600 205 Pikachu 6 112 91 Pikachu 13 315 153 Pikachu 6 152 104 Pikachu 15 402 168 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 4 42 120 Pikachu 4 42 120 Pikachu 7 177 146 Pikachu 6 177 146 Pikachu 3 20 152 Pikachu 4 103 75 Pikachu 17 800 168 Pikachu 8 208 88 Pikachu 18 888 175 Pikachu 20 1300 137 Pikachu 145 3980 206 Pikachu 7 240 88 Pikachu 19 2200 175 Pikachu 5 804 161 Pikachu 7 306 89 Pikachu 9 715 164 Pikachu 11 50 85 Pikachu 7 150 73 Pikachu 11 153 126 Pikachu 20 820 197 Pikachu 4 513 97 Pikachu 13 774 177 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 4 12 74 Pikachu 11 206 188 Pikachu 13 403 165 Pikachu 27 525 165 Pikachu 10 1680 150 Pikachu 12 1540 150 Pikachu 4 19 92 Pikachu 9 236 158 Pikachu 6 115 111 Pikachu 11 328 161 Pikachu 5 215 58 Pikachu 15 1080 189 Pikachu 10 238 99 Pikachu 15 604 199 Pikachu 7 125 99 Pikachu 15 682 199 Pikachu 6 74 61 Pikachu 62 1620 213 Pikachu 3 8 145 Pikachu 10 220 132 Pikachu 6 23 97 Pikachu 11 125 179 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 8 150 97 Pikachu 16 306 179 Pikachu 20 1000 169 Pikachu 6 10 147 Pikachu 12 470 174 Pikachu 6 140 44 Pikachu 7 168 74 Pikachu 15 2565 187 Pikachu 8 395 75 Pikachu 11 876 128 Pikachu 14 1506 192 Pikachu 4 525 142 Pikachu 17 270 178 Pikachu 18 226 178 Pikachu 10 234 198 Pikachu 6 87 110 Pikachu 6 421 89 Pikachu 11 1105 144 Pikachu 15 1026 218 Pikachu 6 952 103 Pikachu 12 2025 153 Pikachu 16 5500 210 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 17 2300 217 Pikachu 18 1750 216 Pikachu 19 2050 215 Pikachu 14 400 211 Pikachu 20 600 211 Pikachu 45 3520 218 Pikachu 35 9500 218 Pikachu 70 2065 220 Pikachu 3 11 215 Pikachu 17 608 215 Pikachu 4 102 64 Pikachu 11 970 141 Pikachu 22 3100 208 Pikachu 5 62 65 Pikachu 9 220 142 Pikachu 12 550 209 Pikachu 4 52 66 Pikachu 8 230 143 Pikachu 17 845 210 Pikachu 3 20 56 Pikachu 6 155 113 Pikachu 12 249 172 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 5 200 58 Pikachu 10 315 116 Pikachu 3 22 54 Pikachu 10 255 159 Pikachu 5 95 60 Pikachu 9 305 117 Pikachu 14 420 194 Pikachu 2 12 68 Pikachu 9 145 204 Pikachu 9 315 99 Pikachu 16 1025 199 Pikachu 5 570 99 Pikachu 13 1495 199 Pikachu 2 34 61 Pikachu 5 65 159 Pikachu 9 233 159 Pikachu 3 55 63 Pikachu 12 385 188 Pikachu 4 39 120 Pikachu 7 295 75 Pikachu 11 335 178 Pikachu 4 33 68 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 5 93 133 Pikachu 3 63 73 Pikachu 9 299 176 Pikachu 12 203 186 Pikachu 4 12 127 Pikachu 12 150 204 Pikachu 4 55 84 Pikachu 12 333 178 Pikachu 9 44 187 Pikachu 9 273 187 Pikachu 5 39 71 Pikachu 10 438 183 Pikachu 2 6 74 Pikachu 4 192 79 Pikachu 10 380 209 Pikachu 5 605 72 Pikachu 13 1870 188 Pikachu 5 150 68 Pikachu 6 130 78 Pikachu 6 244 255 Pikachu 5 19 107 Pikachu 10 1080 168 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 7 205 67 Pikachu 14 560 144 Pikachu 19 950 218 Pikachu 6 1050 94 Pikachu 7 202 72 Pikachu 12 540 204 Pikachu 8 495 95 Pikachu 20 3000 198 Pikachu 8 120 114 Pikachu 13 615 204 Pikachu 7 230 83 Pikachu 13 444 181 Pikachu 14 270 164 Pikachu 4 70 90 Pikachu 12 240 156 Pikachu 10 650 108 Pikachu 10 505 131 Pikachu 22 1355 214 Pikachu 11 340 199 Pikachu 12 1800 211 Pikachu 17 1400 193 Pikachu 24 2828 217 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 20 1286 211 Pikachu 18 1386 199 Pikachu 16 680 199 Pikachu 15 380 220 Pikachu 19 515 198 Pikachu 10 255 196 Pikachu 8 259 196 Pikachu 20 425 192 Pikachu 25 2910 207 Pikachu 9 340 185 Pikachu 16 520 208 Pikachu 14 3400 198 Pikachu 22 1066 210 Pikachu 13 266 187 Pikachu 3 3 132 Pikachu 3 3 210 Pikachu 3 3 210 Pikachu 3 3 210 Pikachu 54 6830 220 Pikachu 42 3360 220 Pikachu 17 4300 215 Pikachu 37 4200 220 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 45 7500 220 Pikachu 15 856 210 Pikachu 4 31 165 Pikachu 3 14 215 Pikachu 15 505 210 Pikachu 2 21 64 Pikachu 32 3200 255 Pikachu 4 40 270 Pikachu 6 81 28 Pikachu 8 160 145 Pikachu 33 630 238 Pikachu 5 99 28 Pikachu 10 555 146 Pikachu 16 1500 238 Pikachu 5 59 28 Pikachu 8 245 145 Pikachu 15 946 238 Pikachu 5 116 51 Pikachu 11 270 147 Pikachu 4 41 55 Pikachu 9 147 130 Pikachu 12 610 221 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 4 101 56 Pikachu 11 375 156 Pikachu 6 105 63 Pikachu 11 305 174 Pikachu 6 110 63 Pikachu 10 280 174 Pikachu 6 135 63 Pikachu 10 290 174 Pikachu 6 233 58 Pikachu 11 605 170 Pikachu 3 21 53 Pikachu 6 150 125 Pikachu 12 290 215 Pikachu 8 298 59 Pikachu 16 795 174 Pikachu 4 180 56 Pikachu 9 1020 137 Pikachu 17 2600 227 Pikachu 4 21 63 Pikachu 9 105 149 Pikachu 3 85 66 Pikachu 7 404 178 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 11 310 390 Pikachu 6 125 61 Pikachu 12 400 142 Pikachu 14 870 227 Pikachu 5 45 59 Pikachu 8 170 134 Pikachu 15 620 225 Pikachu 13 555 163 Pikachu 14 510 163 Pikachu 3 25 62 Pikachu 5 73 133 Pikachu 12 205 221 Pikachu 4 53 52 Pikachu 12 585 126 Pikachu 25 2005 214 Pikachu 3 6 56 Pikachu 7 66 168 Pikachu 5 66 56 Pikachu 11 163 168 Pikachu 10 180 161 Pikachu 7 152 58 Pikachu 10 334 123 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 15 963 229 Pikachu 6 375 63 Pikachu 13 929 168 Pikachu 10 280 161 Pikachu 3 145 65 Pikachu 14 2000 166 Pikachu 6 118 70 Pikachu 11 300 171 Pikachu 14 140 172 Pikachu 5 15 61 Pikachu 17 765 169 Pikachu 7 165 71 Pikachu 12 810 173 Pikachu 5 95 71 Pikachu 14 320 177 Pikachu 6 310 66 Pikachu 19 1073 166 Pikachu 7 125 66 Pikachu 16 811 179 Pikachu 4 58 60 Pikachu 5 75 165 Pikachu 4 58 58 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 7 180 137 Pikachu 15 440 221 Pikachu 3 10 58 Pikachu 6 80 130 Pikachu 10 201 221 Pikachu 5 55 61 Pikachu 13 242 166 Pikachu 4 57 61 Pikachu 11 410 138 Pikachu 13 575 241 Pikachu 6 195 67 Pikachu 19 925 166 Pikachu 4 50 150 Pikachu 5 59 63 Pikachu 10 330 173 Pikachu 2 10 59 Pikachu 6 105 162 Pikachu 12 330 67 Pikachu 22 1350 168 Pikachu 12 316 165 Pikachu 1 6 64 Pikachu 8 143 165 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 6 188 61 Pikachu 10 1100 171 Pikachu 3 210 60 Pikachu 6 510 154 Pikachu 6 810 234 Pikachu 2 3 55 Pikachu 12 220 142 Pikachu 21 805 232 Pikachu 5 90 67 Pikachu 10 345 170 Pikachu 3 31 55 Pikachu 6 130 130 Pikachu 10 343 234 Pikachu 6 180 64 Pikachu 10 360 144 Pikachu 18 1055 243 Pikachu 5 85 61 Pikachu 26 2600 170 Pikachu 11 1480 170 Pikachu 4 77 61 Pikachu 8 253 173 Pikachu 7 110 165 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 9 200 70 Pikachu 14 355 179 Pikachu 16 1390 170 Pikachu 10 920 61 Pikachu 28 3300 169 Pikachu 5 102 68 Pikachu 16 700 172 Pikachu 16 946 172 Pikachu 5 105 70 Pikachu 15 410 179 Pikachu 5 90 74 Pikachu 12 395 179 Pikachu 14 580 169 Pikachu 3 330 169 Pikachu 8 173 60 Pikachu 14 500 147 Pikachu 18 1600 270 Pikachu 11 288 72 Pikachu 16 460 248 Pikachu 21 2500 261 Pikachu 19 2600 261 Pikachu 20 2000 261 NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 15 630 261 Pikachu 15 610 261 Pikachu 32 3300 306 Pikachu 29 3450 306 Pikachu 15 680 270 Pikachu 30 3250 297 Pikachu 14 485 261 Pikachu 6 65 270 Pikachu 15 825 270 647 rows selected. SQL> list 1 select name, height, weight, baseexperience 2 from pokemon p, attributes a 3 where p.name = 'Pikachu' 4* SQL> select name, height, weight, baseexperience 2 from pokemon p, attributes a 3 where p.name = 'Pikachu' and 4 p.pokedexid = a.pokedexid 5 ; NAME HEIGHT WEIGHT BASEEXPERIENCE -------------------- ---------- ---------- -------------- Pikachu 4 60 82 SQL> exit