Oracle Developer使用指南 (4)

54OracleDeveloperOracleDeveloperPL/SQLOracleDeveloper41112PL/SQL1112UnifiedModelingLanguage(UML)OracleDeveloperOracleDeveloper5.1OracleDeveloperOracleDeveloperOracleDeveloperOracleDeveloperScratchOracleDeveloperDeveloperOracleDeveloperOracleDeveloperPL/SQLOracleDeveloperOracleDeveloperScratchOracleDeveloper5.1.1OracleDeveloperFormsForms1.OracleDeveloperOracleDeveloperForms()(focus)WindowsMacintoshSQL(cursor)MDIMcGraw-HillWebwww.Osborne.comnavigation()()OracleDeveloperFormsOracleDeveloperForms(When-Validate-ItemWhen-Validate-BlockWhen-Validate-Record()NavigatetoFormLevel()(Level)NavigatetotheFormLevel()NavigatetotheBlockLevel()82OracleDeveloperNavigatetotheRecordLevel()NavigatetotheItemLevel()entersValidationUnit()OracleDeveloperFormsGo_ItemGo_Block.Go_RecordOracleDeveloperDeveloperDeveloper2.ObjectNavigatorOracleDeveloperFormsFormBuilderOracleDeveloperWhen-New-ItemOracleDeveloperExecutionStyle()OverrideBeforeAfterBeforeAfterExecutionStyle()BeforeAfterWhen-Validate-RecordSmartTriggers583ObjectNavigatorLayoutEditorSmartTriggersPL/SQLOtherOracleDeveloper(5-1)5-1OracleProperty-ClassSmartTriggers3.1)INSERTUPDATEDELECTOracleDeveloperPOST84OracleDeveloperOracleDeveloperPostinthewhen-Validate-Item10OracleDeveloperFormsSavepointCleanupcursors()(guard)5-25-2UMLOracleDeveloperOracleDeveloperOracleOracleDeveloper585Pre-Commit/Post-DatabaseCommitOn-CommitPost-Forms-OracleSAVEPOINTPOSTOpen_FormCall_FormOracleSAVEPOINTOracleDeveloperPre-Commit()()OracleDeveloperOracleDeveloper5-3DELETEINSERTUPDATEPre-Post-operation(Oracle)On-OperationOracleDeveloperPost-Form-Commit(On-Commit)Post-Database-CommitSQLOracleDeveloperValid()5-3UMLPrePost-Operation86OracleDeveloperPreOperationOnOperationOnoperalionOnOperationPostOperationOper-ationOracleDeveloperValid()Pre-InsertPre-UpdatePre-DeletePost-InsertPost-UpdatePost-Delete()Pre-Post-PL/SQLLedgerTalbotPre-Delete()2)Oracle()OracleOracleDeveloperOracleSQLSELECTFORUPDATEOFOracleDeveloperNULL()non-NULL()Record|LOCK(|)UPDATE()DELETEDELETE_RECORDENTER_QUERY(FOR_UPDATE)EXECUTE_QUERY(FOR_UPDATE)LOCK_RECORDSQLLOCKTABLE587OracleDeveloperOracleDeveloperOn-LOCKOracleDeveloper()OracleOn-LOCKOracleLockingMode()Immediate()OracleDeveloperDelayedOracleDeveloperOracleDeveloperLockRecordYesOracleDeveloper4.OracleDeveloper()ENTER(1)OracleDeveloperFormValidation88OracleDeveloperUnitOracleOracleValidationUnitOracleDeveloperFormsOracleDeveloper(2)5-45-4Creatingarecord()New()OracleDeveloperDuplicatingarecord()589NULLPREVIOUS-ITEMPREVIOUS-ITEMNULLPost-ChangeWhen-Vali-date-ItemLOVOracleDeveloperFetchingtherecord()On-FetchPost-Change()OracleDeveloperChanged(New)(Changed)NewChangedTrueOracleDeveloperPost-ChangedWhen-Validate-Item(Valid)Post-changeOracleWhen-Validate-ItemClear-Item5-4Formatmask:()(Valid()Invalid())Requiredandinputallowed()Fixedlengh()Datatype()Range()Listofvalues()(LOV)Formula()Post-ChangeWhen-Validate-Item(Valid)When-Validate-ItemCHECKSQLWhen-Validate-ItemWhen-Validate-ItemTalbotBuy()AuthorizedPurchaseLimit()When-Validate-ItemWhen-Validate-Item90OracleDeveloperPL/SQL()When-Validate-Item(3)New()Changed()()Valid()OracleDeveloper5-55-5()When-Validate-Record(Valid)When-Validate-Record591When-Valid-ate-RecordWhen-Validate-ItemCKECKFOREIGNWhen-Validate-RecordDBMS(4)OracleDeveloperChangeValid(5-6)5-6OracleDeveloper5-75-75.OracleDeveloperForms5-8OracleDeveloper()92OracleDeveloper(querybyexample)SQL5-8Countthequery()On-CountAbortandclosethequery()On-lose1)SQLSELECTOracleDeveloperFormsSELECTSelsct-listTableorder-by-listselect-listORDERBYWhereorder-by-listQuery-condition()SQLDefaultconditions()WhereColumnconditions()Specialconditions()WhereQueryDataSourceTypeFROMOracleDeveloper6593(=!=)SQLWHERESQLOracleDeveloper()FireinEnter-QueryModeTrueEnterQuery5-95-9BlockQueryAllowedDatabaseDataBlockNOcontrolblock()2)WHEREOracleDeveloper5-10()OracleDeveloper()ChangedOracleDeveloperPre-Query94OracleDeveloperWHEREOracleDeveloperOracleDeveloperSELECTPre-SelectOn-SelectSELECTPost-SelectWhen-Clear-BlockWindowsRegistryCNTL_BREAK=ONCTRL-C5-103)SQLOracleDeveloper595SQLPre-SelectOn-SelectSQLPost-SelectWhen-Clear-BlockOn-SelectPre-QueryOn-Select()On-FetchOracleDeveloper5-11ClearRecord()QueryArraySizeRecordtoFetchOn-FetchRecordtoFetchGet_Block_Propery5-1196OracleDeveloper=1=On-FetchOn-FetchDBOn-FetchPost-Querynon-NULLPost-ChangeOracleDeveloperPost-ChangePost-QueryPost-QueryPost-QueryDeveloperPost-Query501040Form_Trigger_FailurePost-QueryStreet2()LodgingPost-QueryASCII10CHROracleASCIIPost-QueryNumberofRecordsBuffered()NumberofRecordsBuffered()()6.597Pre-FormPre-BlockPre-RecordPre-Text-ItemPost-FromPost-BlockPost-RecordPost-Text-ItemWhen-New-Obiect-InstanceWhen-New-Form-InstanceWhen-New-Block-InstanceWhen-New-Record-InstanceWhen-New-Item-InstanceGo_ItemGo_BlockOracleDeveloperWhen-New-Form-InstancePost-FormPost-BlockPre-FormPre-BlockPre-Text-ItemWhen-New-Form-InstanceWhen-New-Form-InstanceWhen-New-Form-InstanceMDIWhen-New-Form-Instance600300(CoordinateSystem)OracleDeveloperWhen-New-Block-InstanceWhen-New-Block-In