回复：数据库系统工程师

--删除约束ALTER VIEW productinfo DROP CONSTRAINT pk_productid;

--删除视图DROP VIEW pro_view CASCADE CONSTRAINT;

--删除约束ALTER VIEW productinfo DROP CONSTRAINT pk_productid;
--删除视图DROP VIEW pro_view CASCADE CONSTRAINT;

--删除约束ALTER VIEW productinfo DROP CONSTRAINT pk_productid;
--删除视图DROP VIEW pro_view CASCADE CONSTRAINT;

--删除约束ALTER VIEW productinfo DROP CONSTRAINT pk_productid;
--删除视图DROP VIEW pro_view CASCADE CONSTRAINT;

--创建一个自增长序列CREATE SEQUENCE t_table_idSTART WITH 1INCREMENT BY 1MAXVALUE 9999NOCACHENOCYCLE/

--创建一个自增长序列CREATE SEQUENCE t_table_idSTART WITH 1INCREMENT BY 1MAXVALUE 9999NOCACHENOCYCLE/

--创建一个自增长序列CREATE SEQUENCE t_table_idSTART WITH 1INCREMENT BY 1MAXVALUE 9999NOCACHENOCYCLE/

--创建一个自增长序列CREATE SEQUENCE t_table_idSTART WITH 1INCREMENT BY 1MAXVALUE 9999NOCACHENOCYCLE/

SELECT t_table_id.currval FROM PRODUCTINFO;

SELECT t_table_id.currval FROM PRODUCTINFO;

--创建存储过程CREATE OR REPLACE PROCEDURE productinfo_prcASBEGINUPDATE productinfo SET quantity=122WHERE productid=1;COMMIT;END;

--创建存储过程CREATE OR REPLACE PROCEDURE productinfo_prcASBEGINUPDATE productinfo SET quantity=122WHERE productid=1;COMMIT;END;

--创建存储过程CREATE OR REPLACE PROCEDURE productinfo_prcASBEGINUPDATE productinfo SET quantity=122WHERE productid=1;COMMIT;END;

--查询v$process 进程COL program FOR A30;SELECT pid,spid,username,program,LATCHSPIN,LATCHWAIT FROM v$process;