oracle10g ocp认证中文与真题精解lesobject

,和使用序 创建privatepublic NEXTVALCURRVAL 表Basicunitofstorage;composedof视图Logicallyrepresentssubsetsofdatafromoneormoretables序列Generatesnumeric索引ImprovestheperformanceofdataretrievalGivesalternativenamesto OneorNot CREATE[ORCE]]VIEW[(alias[,ASsubquery[WITHCHECKOP[WITHREADTION[CONSTRAINTconstraint]]Y[CONSTRAINTconstraint]]; CREATECREATE ASSELECTemployee_id,last_name,salary department_id=DESCRIBE CREATECREATE ASSELECTemployee_idID_NUMBER,last_nameNAME,salary*12ANN_SALARY department_id= SELECTSELECT CREATECREATEORCEVIEW(id_number,name,sal,department_id)ASSELECTemployee_id,first_name||''||last_name,salary,department_id department_id= 在子查询的同样的定制列中,CREATEORRE 中展示列别名(ColumnaliasesintheCREATEOR CEVIEWclausearelistedinthesameCREATECREATEORCEVIEW(name,minsal,maxsal,ASSELECT d.department_name,MIN(e.salary), employeeseJOINdepartments (e.department_id=d.department_id)GROUPBYd.department_name; CREATEORREASSELECT CEVIEWartment_id=20WITHCHECKPTIONCONSTRAINT; DMLDML DML操作，结果使Oracle服 DMLCREATEORASSELECTCEVIEWumber,employee_name,job_title)ployee_id,last_name,job_idartment_id=WITHREAD; DROPVIEWDROPVIEW NEXTVALCURRVAL Basicunitofstorage;composedyrepresentssubsetsofdatafromoneormoretablesGeneratesnumericImprovestheperformanceofsomeGivesalternativenamesto A CREATESEQUENCEsequence[INCREMENTBYn][STARTWITHn][{MAXVALUEn|NOMAXVALUE}][{MINVALUEn|NOMINVALUE}][{CYCLE|NOCYCLE}][{CACHEn| CREATESEQUENCEINCREMENTBYSTARTWITHMAXVALUE9999 ,甚至对于不同的用户。 INSERTINTOdepartment_name,location_id) 'Support',INSERTINTOdepartment_name,location_id) 'Support', ALTERALTERSEQUENCEINCREMENTBYMAXVALUE999999 DROPSEQUENCEDROPSEQUENCE NEXTVALCURRVAL Basicunitofstorage;composedyrepresentssubsetsofdatafromoneormoretablesGeneratesnumericImprovestheperformanceofsomeGivesalternativenamesto CREATECREATE[UNIQUE][BITMAP]INDEXONtable(column[,CREATEINDEX 的 AAcolumncontainsawiderangeofAcolumncontainsalargenumberofnullOneormorecolumnsarefrequentlyusedtogetherinWHEREclauseorajoinThetableislargeandmostqueriesareexpectedtoretrievelessthan2%to4%oftherowsinthetableThecolumnsarenotoftenusedasaconditioninThetableissmallormostqueriesareexpectedtoretrievemorethan2%to4%oftherowsinthetableThetableisupdatedTheindexedcolumnsarereferencedaspartof DROPDROPINDEXDROPINDEXDROPINDEXINDEX权限 NEXTVALCURRVAL Basicunitofstorage;composedyrepresentssubsetsofdatafromoneormoretablesGeneratesnumericImpr