gr1021的博客

首先，先来创建表空间和表用户/*创建表空间*/create tablespace waterbossdatafile 'c:\waterboss.dbf'size 100mautoextend onnext 10m /*创建表用户*/create user tableuserdefault tablespace waterboss/*用户赋权，就可以用作登录*/gr

继上一篇创建表的基础上，进行表的简单查询：---------简单查询--查询水表编号为30408的业主记录select * from t_Owners where watermeter = '30408' --查询业主名称包含“刘”的业主记录select * from T_OWNERS where name like '%刘%' --查询业主名称包含‘刘’的且门牌号包含‘

创建视图：create or replace force view view_ownersasselect * from T_OWNERS删除视图语法：drop view view_owners创建视图 ：业主类型为 1 的业主信息create or replace view view_ownersasselect * from t_Owners where ownertyp

创建序列create sequence se_owners--提取下一个值select se_owners.nextval from dual--提取当前值select se_owners.currval from dual--创建复杂序列--有最大值的非循环序列create sequence se_testincrement by 10start with 10maxval