oracle code

基础教程代码 /* * regexp_seed.sql * Appendix A, Oracle Expert PL/SQL * by Ron Hardman and Michael McLaughlin * * This script creates the table and seed data to test * regular expression metacharacters and functions */ CREATE TABLE reg_exp_tbl ( name VARCHAR2(100 CHAR), address VARCHAR2(100 CHAR) ); INSERT INTO reg_exp_tbl VALUES ( 'Scott Eldridge', '2989 Berkeley, CA 39030'); INSERT INTO reg_exp_tbl VALUES ( 'Tom Doebler', '20034 Polonia Ct., Polonia, WI 54421'); INSERT INTO reg_exp_tbl VALUES ( 'Darell Smith', '90002 Packer Fan Ct, Polonia, WI 54421'); INSERT INTO reg_exp_tbl VALUES ( 'Judy Zimmerman', '10000 Zimmer Pl., Texas City, TX 90372'); COMMIT; /* * regexp_seed.sql * Appendix A, Oracle Expert PL/SQL * by Ron Hardman and Michael McLaughlin * * This script creates the table and seed data to test * regular expression metacharacters and functions */ CREATE TABLE reg_exp_tbl ( name VARCHAR2(100 CHAR), address VARCHAR2(100 CHAR) ); INSERT INTO reg_exp_tbl VALUES ( 'Scott Eldridge', '2989 Berkeley, CA 39030'); INSERT INTO reg_exp_tbl VALUES ( 'Tom Doebler', '20034 Polonia Ct., Polonia, WI 54421'); INSERT INTO reg_exp_tbl VALUES ( 'Darell Smith', '90002 Packer Fan Ct, Polonia, WI 54421'); INSERT INTO reg_exp_tbl VALUES ( 'Judy Zimmerman', '10000 Zimmer Pl., Texas City, TX 90372'); COMMIT; /* * regexp_seed.sql * Appendix A, Oracle Expert PL/SQL * by Ron Hardman and Michael McLaughlin * * This script creates the table and seed data to test * regular expression metacharacters and functions */ CREATE TABLE reg_exp_tbl ( name VARCHAR2(100 CHAR), address VARCHAR2(100 CHAR) ); INSERT INTO reg_exp_tbl VALUES ( 'Scott Eldridge', '2989 Berkeley, CA 39030'); INSERT INTO reg_exp_tbl VALUES ( 'Tom Doebler', '20034 Polonia Ct., Polonia, WI 54421'); INSERT INTO reg_exp_tbl VALUES ( 'Darell Smith', '90002 Packer Fan Ct, Polonia, WI 54421'); INSERT INTO reg_exp_tbl VALUES ( 'Judy Zimmerman', '10000 Zimmer Pl., Texas City, TX 90372'); COMMIT; //初步学习……