oracle 19c sql
Script Ouput X Query Result SHB SQL | Fetched 50 rows in 0.049 seconds ORDER_ID ORDER_DATE CUSTOMER_ID EMPLOYEE_D SHIP_DATE SHIPMENT_METHOD_ID 388 09-OCT-99 400666 6903 13-NOV-02 10 2 139 -JAN-00 802033 3 4587 14-NOV-02 1394 15-NOV-02 3 244 24-JUN-02 401512 4 89610-MAY-98 401740 8859 13-NOV-02 8 N LA D 508 09-DB99 201595 2160 15-NOV-02 7 70 539 23-JAN-98 401614 3307 17-NOV-02 7. 1272 01-FEB-01 201340 5775 13-NOV-02 9 1278 29-OCT-01 401572 5648 15-NOV-02 7 1320 30 NOV 99 G01574 8377 14-NOV-02 7 PAYMENT METHOD ID PAID ORDER_STATUS 4 NOTES 4 Y fac"ApXA2ymD) 7 Ph7 SY G 29h\-pU=+hQNVW2. E 6N 13BwI4yNdN99UL}, IN SI53C!tknufqljag H -d-6Y' 43ZTSC?$ E (null) 15 'B-Mu/Gdarfjp#[- z-pqYzsYp] [X$e"q 6 Y 3U12,7x9, GmH8DIACZ (null) 3+10 ( ywHgN9B* (V 2 Y H n[9]V5XZS:COC4J>04.: 7Y I]TJPHGGSDYA-TIX 4;
(OSFJlJ/:pud 2 N H 01 (ath"H]H45m30F1] 3Y \ dhu'5!um';0x\7X 4 Y *49\"P$]NK01@2bA 401659 5775 16-NOV-02 4 1459 06-DEC-00 901574 4422 12-NOV-02 6 6 G 55 cm 1115 05-AUG-98 101484 8762 14-NOV-02 5 1849 26-OCT-99 101612 9485 14-NOV-02 3 1874 19-DEC-97 800691 8931 14-NOV-02 4 401680 1923 27-APR-02 1394 16-NOV-02 6 400666 7741 13-NOV-02 6 1963 15-JUL-98 2001 31-DEC-00 17 201775 9485 15-NOV-02 7 18 2317 13-JAN-98 200055 2895 12-NOV-02 8 select from customers; select from products; select from payment method; select * from shipment method: Script Output x Query Result x at SQL | All Rows Fetched: 49 in 0.072 seconds STATE CITY Champagne Victorville SD 1 MI 2 GA Thorn 3 AK 4 Harlem Springs Sunkist ID 5 MO Hodge North Fontana Hector AR 7 VT MN 8 ZIP CODE PHONE EMAIL CC_NUMBER 43172 4319071613 JAntoine@iodmgpvjdzprccx.gov 231146832737266 30583 6491535533 TWeis@tenleimrovgfgcj.edu 936977663745292 96955 3367308904 LHernadez@ducimwwbulgmglj.ad 973236712433695 08989 7764173590 KNorton@ajcsnnonpuyltwo ad 990273053627068 99858 1115042803 KThiel@zjmqntgomdqvhdx.ws 829371860847345 73726 7933962285 HTeixeira@bnywenkmnsouqyi.gov 526478225001794 98629 4155187511 HBarr@ccgsgzmxkeutrjy.gov 412170214720408 36347 7667045227 ABranch@eyvmxphmrtqvxja.com 536825384580287 92237 4155081512 BChew@hgfggptewvgosrx.net 292229267113932 47390 6383996848 CCapone@cmgpygaihignrhl.mil 768429811996829 68113 9181639247 FKent@avvojyfatcbqgfa.org 295141402987424 89861 5068826104 FArsenault@rcdcqcowthfflac.ad 127671708461896 12476 4949545616 LMcpherson@frjhixxgiqmhesw.ws 562163275872341 41447 3045452355 MHawthorne@feswiprceqbbbog.gov 705457979214954 80828 9091277424 KLasher@deegckmztqjuvli.ad 340859560896699 77922 1199835158 TCreel@pdvrjaelqnqopyl.ws 552234235185816 04658 2046547179 MConnor@hxbyvaxhbtxruva.mil 845394297945619 71166 AA715273 TRaierweinweide SRA0066AANS CREDIT LIMIT GENDER STATUS COMMENT 200000 M /T if- 300000 E A PN415) 200000 E A ])Bjy-f0 200000 F (null) 710) 5d] 800000 E (null) 1 PCL: U\/ VTT SALES_REP_ID CUSTOMER_D CUSTOMER_SSN FIRST_NAME LAST_NAME ADDRLINE 6415 201340 969996970 Jeffrey Antoine 9938 Moreno St. 2336 801367 596664413 Tristan Weis 88296 Cheatham St. 6415 801397 118869007 Leigha Hernadez 85 Tsai Road 7719 902 654 899466416 Kelvin Norton 65 Harley Street 7719 402676 421735374 Kurt Thiel 95 Albanese Ct. 6415 402724 936177368 Heriberto Teixeira 6766 Eugene Road 2336 102008 101723163 Helga Barr 12 Gill Street 6415 401989 663728604 Alfonso Branch 86 Aleman Avenue 4587 402022 630624535 Bud Chew 7395 Tomlinson Ct. 7719 802033 322367549 Clay Capone 42 Bolick Rd 2336 100016 949402668 Fransisca Kent 79 Coates Ave 9644 800043 968948460 Foster Arsenault 83 Roundtree Avenue 7719 200055 592492609 Lorelei Mcpherson 92879 Jaime Road 6415 900106 937526259 Maurita Hawthorne 66 Mims Ct. 6415 400666 925900647 Karma Lasher 77 Brandt St. 7719 800691 490896547 Tana Creel 95389 Julian St. 7719 400723 853199311 Morgan Connor 241 Germany Rd 2226 26 Tr Tara 20140700170736 Baier Danby 9 Kelso KS 10 Chambless VT Blue Jay KS 12 WV 13 VA 14 OK Earp Lenwood Hinkley Sunset Hills Calada Croat Dan 15 VA 16 AL 17 en Line 3922 Colunin 25 Modified 18 9:44 PM select from product inventory; select * from products; select * from shipment method; Query Result x 3 @ 3 SQL I Fetched 50 rows in 0.049 seconds PRODUCT_ID QTY_ON_HAND QTY_ON_ORDER DATE ORDERED 26 22-MAR-01 DELIVERY DATE 65 17-JUN-01 NA 82 25-OCT-99 05-NOV-99 3 47 18-DEC-98 02-FEB-99 4 95 42 28-FEB-99 01-MAR-99 5 15 24 28-NOV-98 10-FEB-99 1005 10 11-MAR-99 30-MAR-99 72 30 04-APR-99 01-JUN-99 8 1007 63 88 12-APR-00 13-APR-00 9 1008 59 22 09-NOV-02 26-JAN-03 10 1009 37 89 17-JAN-02 27-FEB-02 11 1010 31 33 02-APR-00 30-APR-00 12 1011 15 35 16-JUN-98 22-JUN-98 13 1012 58 12 18-FEB-99 13-APR-99 Script Ouput X Query Result SHB SQL | Fetched 50 rows in 0.049 seconds ORDER_ID ORDER_DATE CUSTOMER_ID EMPLOYEE_D SHIP_DATE SHIPMENT_METHOD_ID 388 09-OCT-99 400666 6903 13-NOV-02 10 2 139 -JAN-00 802033 3 4587 14-NOV-02 1394 15-NOV-02 3 244 24-JUN-02 401512 4 89610-MAY-98 401740 8859 13-NOV-02 8 N LA D 508 09-DB99 201595 2160 15-NOV-02 7 70 539 23-JAN-98 401614 3307 17-NOV-02 7. 1272 01-FEB-01 201340 5775 13-NOV-02 9 1278 29-OCT-01 401572 5648 15-NOV-02 7 1320 30 NOV 99 G01574 8377 14-NOV-02 7 PAYMENT METHOD ID PAID ORDER_STATUS 4 NOTES 4 Y fac"ApXA2ymD) 7 Ph7 SY G 29h\-pU=+hQNVW2. E 6N 13BwI4yNdN99UL}, IN SI53C!tknufqljag H -d-6Y' 43ZTSC?$ E (null) 15 'B-Mu/Gdarfjp#[- z-pqYzsYp] [X$e"q 6 Y 3U12,7x9, GmH8DIACZ (null) 3+10 ( ywHgN9B* (V 2 Y H n[9]V5XZS:COC4J>04.: 7Y I]TJPHGGSDYA-TIX 4; (OSFJlJ/:pud 2 N H 01 (ath"H]H45m30F1] 3Y \ dhu'5!um';0x\7X 4 Y *49\"P$]NK01@2bA 401659 5775 16-NOV-02 4 1459 06-DEC-00 901574 4422 12-NOV-02 6 6 G 55 cm 1115 05-AUG-98 101484 8762 14-NOV-02 5 1849 26-OCT-99 101612 9485 14-NOV-02 3 1874 19-DEC-97 800691 8931 14-NOV-02 4 401680 1923 27-APR-02 1394 16-NOV-02 6 400666 7741 13-NOV-02 6 1963 15-JUL-98 2001 31-DEC-00 17 201775 9485 15-NOV-02 7 18 2317 13-JAN-98 200055 2895 12-NOV-02 8 select from customers; select from products; select from payment method; select * from shipment method: Script Output x Query Result x at SQL | All Rows Fetched: 49 in 0.072 seconds STATE CITY Champagne Victorville SD 1 MI 2 GA Thorn 3 AK 4 Harlem Springs Sunkist ID 5 MO Hodge North Fontana Hector AR 7 VT MN 8 ZIP CODE PHONE EMAIL CC_NUMBER 43172 4319071613 JAntoine@iodmgpvjdzprccx.gov 231146832737266 30583 6491535533 TWeis@tenleimrovgfgcj.edu 936977663745292 96955 3367308904 LHernadez@ducimwwbulgmglj.ad 973236712433695 08989 7764173590 KNorton@ajcsnnonpuyltwo ad 990273053627068 99858 1115042803 KThiel@zjmqntgomdqvhdx.ws 829371860847345 73726 7933962285 HTeixeira@bnywenkmnsouqyi.gov 526478225001794 98629 4155187511 HBarr@ccgsgzmxkeutrjy.gov 412170214720408 36347 7667045227 ABranch@eyvmxphmrtqvxja.com 536825384580287 92237 4155081512 BChew@hgfggptewvgosrx.net 292229267113932 47390 6383996848 CCapone@cmgpygaihignrhl.mil 768429811996829 68113 9181639247 FKent@avvojyfatcbqgfa.org 295141402987424 89861 5068826104 FArsenault@rcdcqcowthfflac.ad 127671708461896 12476 4949545616 LMcpherson@frjhixxgiqmhesw.ws 562163275872341 41447 3045452355 MHawthorne@feswiprceqbbbog.gov 705457979214954 80828 9091277424 KLasher@deegckmztqjuvli.ad 340859560896699 77922 1199835158 TCreel@pdvrjaelqnqopyl.ws 552234235185816 04658 2046547179 MConnor@hxbyvaxhbtxruva.mil 845394297945619 71166 AA715273 TRaierweinweide SRA0066AANS CREDIT LIMIT GENDER STATUS COMMENT 200000 M /T if- 300000 E A PN415) 200000 E A ])Bjy-f0 200000 F (null) 710) 5d] 800000 E (null) 1 PCL: U\/ VTT SALES_REP_ID CUSTOMER_D CUSTOMER_SSN FIRST_NAME LAST_NAME ADDRLINE 6415 201340 969996970 Jeffrey Antoine 9938 Moreno St. 2336 801367 596664413 Tristan Weis 88296 Cheatham St. 6415 801397 118869007 Leigha Hernadez 85 Tsai Road 7719 902 654 899466416 Kelvin Norton 65 Harley Street 7719 402676 421735374 Kurt Thiel 95 Albanese Ct. 6415 402724 936177368 Heriberto Teixeira 6766 Eugene Road 2336 102008 101723163 Helga Barr 12 Gill Street 6415 401989 663728604 Alfonso Branch 86 Aleman Avenue 4587 402022 630624535 Bud Chew 7395 Tomlinson Ct. 7719 802033 322367549 Clay Capone 42 Bolick Rd 2336 100016 949402668 Fransisca Kent 79 Coates Ave 9644 800043 968948460 Foster Arsenault 83 Roundtree Avenue 7719 200055 592492609 Lorelei Mcpherson 92879 Jaime Road 6415 900106 937526259 Maurita Hawthorne 66 Mims Ct. 6415 400666 925900647 Karma Lasher 77 Brandt St. 7719 800691 490896547 Tana Creel 95389 Julian St. 7719 400723 853199311 Morgan Connor 241 Germany Rd 2226 26 Tr Tara 20140700170736 Baier Danby 9 Kelso KS 10 Chambless VT Blue Jay KS 12 WV 13 VA 14 OK Earp Lenwood Hinkley Sunset Hills Calada Croat Dan 15 VA 16 AL 17 en Line 3922 Colunin 25 Modified 18 9:44 PM select from product inventory; select * from products; select * from shipment method; Query Result x 3 @ 3 SQL I Fetched 50 rows in 0.049 seconds PRODUCT_ID QTY_ON_HAND QTY_ON_ORDER DATE ORDERED 26 22-MAR-01 DELIVERY DATE 65 17-JUN-01 NA 82 25-OCT-99 05-NOV-99 3 47 18-DEC-98 02-FEB-99 4 95 42 28-FEB-99 01-MAR-99 5 15 24 28-NOV-98 10-FEB-99 1005 10 11-MAR-99 30-MAR-99 72 30 04-APR-99 01-JUN-99 8 1007 63 88 12-APR-00 13-APR-00 9 1008 59 22 09-NOV-02 26-JAN-03 10 1009 37 89 17-JAN-02 27-FEB-02 11 1010 31 33 02-APR-00 30-APR-00 12 1011 15 35 16-JUN-98 22-JUN-98 13 1012 58 12 18-FEB-99 13-APR-99
