文件名称：oracle code
文件大小：480KB
文件格式：ZIP
更新时间：2011-11-20 03:15:17
代码
基础教程代码 /* * 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; //初步学习……