oraclesql表空间包含视图索引

：包含数据段、索引段、回退段、临时段数据块：是Oracle中最小的逻辑单元createtablespacedatafilerootfile'size --'rootfile'dbfautoextendcreateuseridentifiedbydefaulttablespacerootspacetemporarytablespacetempCREATEUSERusernameIDENTIFIEDBYpassword[DEFAULTTABLESPACEtablespace]·grantconnecttousername;CONNECT·grantresourceto ·grantcreatesequencetousername;此系统权限允许用户在当前模式中创建序CONNECT·grantselectontesttousername;允许用户查询TEST·grantupdateontesttousername;TEST·grantallontesttousername;TEST·alteruserusernameidentifiedbynessword;用于修改用户口·dropuserusernamecascadeRevokeconnectfromSetlinesizeSelectrownum,namefrom createtabletb_stu(stu_idchar(12)primarykey,stu_namevarchar(50)notnull,varchar(5),birthday)select*frominsertintotb_stu(stu_id,stu_name,,birthday)values('123456789012','李四select*fromtb_stuwherestu_namedeletefromtb_stuwhereupdatetb_stuset='女',stu_name='梁朝伟'where--to_date修改存入数据库期的格updatetb_stusetbirthday=to_date('2009-10-5','yyyy-mm-dd')where--to_date查询数据库期按指定格式输select*fromtb_stuwherebirthdaybetween(to_date('2009-10-1','yyyy-mm-dd'))and(to_date('2009-12-1','yyyy-mm-dd'))--虚列rownum数据库中实际并不存 selectrownum,stu_id,stu_name,,birthdayfromtb_stuwhere='男select*from(selectrownumrn,stu_id,stu_name,,birthdayfromtb_stuwhere='男')wherern<3;createtabletb_employee(em_idnumberprimaryem_namevarchar(50)notnull,varchar(2),birthdaydate,salnumber(20,2))insertintotb_employeevalues(1,'梁朝伟','男 select*fromtb_employeewheresal>200orderbysalselect*fromtb_employeewheresal>200orderbysalselectem_name,((sal-2000)*0.2)fromtb_employeewhereselectem_name||'的应该缴税:'||((sal-2000)*0.2)asfromtb_employeewheresal>2000orderbydesc;updatetb_employeesetbirthday=to_date('1969-1-1','yyyy-dd-mmwhereselect*fromtb_employeewhereorselect*fromtb_employeewherebirthdayisnullor--between3and5查询条件为：大于等于3同时小于等于5select*fromtb_employeewhereem_idnotbetween3and5;select*fromtb_employeewhereem_id>any(1,3,5);select*fromtb_employeewhereem_id<all(3,5);select*fromtb_employeewhereem_namelikeselect*fromtb_employeewherebirthdaylikecreatetabletb_stu_temp1asselect*fromtb_stuwhereinsertintotb_stu_temp1(select*fromtb_stu);select*fromtabselect*fromtabwhereCREATESEQUENCEINNERIDMINVALUE1MAXVALUESTARTWITHINCREMENT