Existing building table a (user list)
The CREATE TABLE BBSUser
(
U_ID varchar2 (10), - the user Numbers -
UName VARCHAR2 (20), - the user name:
UPassword varchar2 (20), - the user name:
UEmail varchar2 (20), - password -
UBirthday varchar2 (20), - birthday -
Usex varchar2 (2), - sex -
UClass varchar2 (10), - the user level --
UStatement varchar2 (10), users - note -
URegDate varchar2 (20), - the registration date -
UState VARCHAR2 (4), - the user state -
Upoint NUMBER - user integral -
);
The alter table BBSUser ADD CONSTRAINT PK_U_ID primary key (U_ID);
The alter table BBSUser ADD constraint USex CHECK (USex in (' male ', 'woman'));
After inserting data
According to the business requirements to complete data manipulation
- call a stored procedure to realize top-up integral to users, and enhance the level of user -
- define top-up integral stored procedure -
- call a stored procedure to realize the integral to users of prepaid phone -
- integral input from the keyboard to top-up -
- effect show -
Ask everybody a great god help write a code according to the requirements