1, CREATE SEQUENCE USERID INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE NOCACHE NOORDER;CREATE OR REPLACE TRIGGER USERADD BEFORE INSERT ON MEMBERRG FOR EACH ROW BEGIN SELECT LPAD(USERID.NEXTVAL,4,'0') INTO :NEW.NUM FROM DUAL; END;2, alter table table_name rename column old_name to new_name; 3, select * from dba_tables where OWNER='用户名'; select * from dba_users;
1。 先创建序列-- CREATE SEQUENCE USERID INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE NOCACHE NOORDER创建触发器-- CREATE OR REPLACE TRIGGER USERADD BEFORE INSERT ON MEMBERRG FOR EACH ROW BEGIN USERID.NEXTVAL INTO :NEW.NUM FROM DUAL; END;2.alter table table_name rename col_name_old to col_name_new3.select * from dba_tables where owner=owner_name select * from all_tables where owner=owner_name
1.使用序列和触发器 2.先添加列,再删除列 3.使用user_tables等视图!select * from tab;
CREATE SEQUENCE USERID INCREMENT BY 1 START WITH 1
MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
NOCACHE NOORDER;CREATE OR REPLACE TRIGGER USERADD
BEFORE INSERT ON MEMBERRG
FOR EACH ROW
BEGIN
SELECT LPAD(USERID.NEXTVAL,4,'0') INTO :NEW.NUM FROM DUAL;
END;2,
alter table table_name rename column old_name to new_name;
3,
select * from dba_tables where OWNER='用户名';
select * from dba_users;
先创建序列--
CREATE SEQUENCE USERID INCREMENT BY 1 START WITH 1
MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
NOCACHE NOORDER创建触发器--
CREATE OR REPLACE TRIGGER USERADD
BEFORE INSERT ON MEMBERRG
FOR EACH ROW
BEGIN
USERID.NEXTVAL INTO :NEW.NUM FROM DUAL;
END;2.alter table table_name rename col_name_old to col_name_new3.select * from dba_tables where owner=owner_name
select * from all_tables where owner=owner_name
2.先添加列,再删除列
3.使用user_tables等视图!select * from tab;