430 likes | 443 Views
Discover how Oracle9i Designer can enhance productivity, reduce post-generation modifications, and streamline application development workflows. Learn about modeling structures, user interfaces, and managing configurations.
E N D
Boost Application Development by Using Oracle9i Designer Simon W Day simon.w.day@oracle.com Senior Group Manager Application Development ToolsProduct Management Oracle Corporation
Agenda • How Can Designer Help? • Modeling the Structure • Modeling the User Interface • Managing Configurations
Agenda • How Can Designer Help? • Modeling the Structure • Modeling the User Interface • Managing Configurations
How can Designer help you? • Are you using Designer 6.0 or earlier? • Why move to Designer6i • Why move to Oracle9i Designer? • How can you boost your application development productivity using Designer? • Do you need to track dependencies between your forms, and database objects?
Support Application Development Use Designer to support • Application development features that: • Enhance productivity • Reduce the need for post generation modifications • File management and dependency analysis • Configuration management
Design Editor Modeling and Generation
Style Guide Oracle Developer Generation FormsModule OnlineDictionary
Agenda • How Can Designer Help? • Modeling the Structure • Modeling the User Interface • Managing Configurations
Designing a Forms Module Data View Display View
Lookup link Master block Lookup details Data View - Structure Module component
Data View - Structure • Module • Module component • Sub-component • List of values • Lookup table • Bound items
Windows Canvases Item groups Tab canvases Action Items Display View - Structure
PASSPORT Module Components • Can be: • Specific - promotable for reuse • Reusable – encapsulateitems and logic • Can contain: • Base relation - bound and unbound items • Control block - unbound items • Generated PL/SQL API • Trigger / program logic
ModuleSubcomponent Multi-region Blocks
Window 1 Window 2 Multi-region Blocks • Two Windows
Window 1 Multi-region Blocks • Same window
Window 1 Tab 1 Multi-region Blocks • Tab Canvasses
New content canvas Same content canvas Right of Side by Side Blocks
Module Level Source Objects • New Module Level Property “Object Library Objects” • Lists objects to be included in the generated form • Can be Objects or Object Groups • Objects delimited by “;” • Benefits: • Improves modular development • Potentially smaller generated forms • Further removes need for template
Multiple Object Libraries Template Package Object Library Company Standards Object Library Local Standards Object Library Package.olb Company.olb Local.olb Preference STOOLB or Generate Dialog Object Library “Local.olb;Company.olb;Package.olb” Search Path
Generate for the Web • Use the Web template and object library • webtmplt.fmb • webobjlb.olb • Run in Web Preview mode
Agenda • How Can Designer Help? • Modeling the Structure • Modeling the User Interface • Managing Configurations
Schema definitionproperties: Name Data typeOptionality Generator display properties: Display type Display sequence Prompt / length Enhanced Data Schema Definition
Prompt Image Char Hint text Declarative Display Properties Available Software Products Name Logo Description Oracle Developer RAD and internet deployment Model-driven and generation Oracle Designer Oracle Discoverer Drill, pivot and chart The Product Name
Preference Value Meaning ITMIPG 2 Character cells BLKMAR 0.525 in Real inches BLKSLR 0.566 cm Real Centimeters GRPMAR 20.1 point Real points RADHIS 70 pixel Real pixels Decoration Preferences
Window 1 Salary Employee Number Gross Net Total Commit Submit Payroll Further Enhancements Preference Meaning ITMTIP Forms Native Tooltips BLKSBP Multi-Row Scrollbar Position BLKDEC, CONDEC, GRPDEC, OFADEC, STBDEC, RADDEC Decoration preferences
Layout Elements • Window • Canvas • Content • Stacked • Tab • Display items • Bound • Unbound • Action
Flight Bookings PASSPORT Page 1 of 2 Person Flight Bookings Flight Bookings Page 2 of 2 Membership Cost History Authorization Flights Page 1 of 1 Trips Segments Modeling Windows & Canvases Model Generated Form Flight Bookings New contentcanvas Person New contentcanvas Cost History Authorization New stackedcanvas Flights New contentcanvas Trips Segments Same contentcanvas
Window 1 Window 4 Window 2 Window 3 Module X Action Items
PASSPORT New contentcanvas New contentcanvas Flight Bookings Flight Bookings Page 1 of 2 Person History Flights Person Details Tabbedcanvases Name Email Cost History Flights Modeling Tabbed Canvases Model Generated Form
Relative Tabs 100 120 140 160 180 200
Agenda • How Can Designer Help? • Modeling the Structure • Modeling the User Interface • Managing Configurations
Repository Files and Folders This Allows: • Storage of any File Type • Full versioning • Branching • Some Merge and Diff • Inclusion in Configurations
Fine Grained Versioning 1 Tools to Allow: • Branching • Merging • Differencing 2 patch _set1 patch _set2 1 3 1 2 4 5
Q & Q U E S T I O N S A N S W E R S A