![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
PL/SQL
iteye_16394
这个作者很懒,什么都没留下…
展开
-
PL-SQL Basic
------ ======================PL-SQL Basic====================---/**create table stu*/create table stu( id number(3), name char(8), score number(3), age number(2), sex char(2))...原创 2009-10-08 11:55:50 · 58 阅读 · 0 评论 -
PL-SQL 与正则表达式 ---- config.sql
config.sql-- Clean up the database objectsDROP TRIGGER validateUser;DROP PROCEDURE check_email;DROP TABLE userinfo; -- Create the table CREATE TABLE userinfo( username VARCHAR2(20...原创 2009-10-08 16:18:07 · 95 阅读 · 0 评论 -
PL-SQL 与正则表达式 ---- search.sql
search.sql/** SET SERVEROUTPUT ON PROMPT PROMPT | ------------------------------------------------------------------------ | ; PROMPT | Enter your choice for the search ...原创 2009-10-08 16:28:27 · 84 阅读 · 0 评论 -
PL-SQL 与正则表达式 ---- update.sql
update.sqlUPDATE userinfo SET phone='650.221.2019',email='@johnemails.com', password='john' WHERE username='John ';原创 2009-10-08 16:31:18 · 77 阅读 · 0 评论