--建表
create table stk_ent_info (
  stk_ent_id number(8) not null primary key,
  stk_ent_name varchar2(40) ,
  stk_ent_indexcode varchar2(100),
  stk_ent_parentIndexCode varchar2(100)
);

--oracle的自增序列
CREATE SEQUENCE stk_ent_info_sequence 
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 10;

--通过序列实现主键自增
insert into stk_ent_info values(stk_ent_info_sequence.nextval,'ccc','3434343','23');
--查询表中的所有信息
select * from stk_ent_info;
--根据条件修改表数据
update stk_ent_info set stk_ent_name = 'bbb' where stk_ent_id = 1;
--根据条件查询数据
select * from stk_ent_info where stk_ent_name = 'bbb';