![iWare Logic Technologies Pvt. Ltd. Aditi Samruddhi, Baner, Pune , India - 411045 Email: [email_address] Website: www.iwarelogic.com Thank You](https://image.slidesharecdn.com/webinarapexfinal-100330083025-phpapp01/75/Web-Development-In-Oracle-APEX-59-2048.jpg)
Uploaded byiWare Logic Technologies Pvt. Ltd.
Web Development In Oracle APEX
The document outlines a webinar on web development using Oracle APEX, covering its history, features, and application-building process. It highlights the architecture, components, and utilities of APEX, along with advanced topics like debugging, Java integration, and security measures. The session also introduces Iware Logic's APEX services and training offerings.
Web Development In Oracle APEX
- 1. Presents Webinar- WebDevelopment In Oracle APEX
- 2.
- 3. AGENDA APEX –Introduction Building applications with APEX APEX Features Advanced Topics
- 4.
- 5. APEX ORIGIN Initiallyknown as => “Project Marvel” Then it became => “HTML DB” Currently known as => “Application Express (APEX)”
- 6. What is APEX?Development & deployment tool for web based application Faster creation of reliable & secure web applications using Meta Data Includes all the functionality of SQL or PL/SQL Flexible look-and-feel options provided by themes and templates OS independent, configured in database Little programming knowledge required
- 7. Architecture A Versionsbefore to Oracle Database 11.1 HTTP Server (mod_pl/sql) Oracle Database Web Browser Application Express Engine
- 8. Architecture B WithOracle Database 11.1 & higher or Oracle Database 10 g Express Edition Oracle Database with Embedded PL/SQL Gateway Web Browser Application Express Engine
- 9. APEX Users AdministratorWorkspace Administrator Developer End User
- 10. Creating an APEX Application
- 11. Building an application Login with developer privileges Use the SQL tools to make your tables, constraints, triggers, procedures etc. Start a new application (use the wizard) Customize the application (check each change as you make it)
- 12. Example Hardware InventoryApp View and Record hardware inventory Searchable report Insert/ Update data using forms
- 13. Log into WorkspaceUse the Workspace provided to you, the username and password
- 14. Home Menu You’reready to begin Build Applications Work with Data Use Utilities
- 15. Migrate Data Importdata from Spreadsheets, XML or Delimited Files
- 16. Import Data fromSpreadsheet
- 17.
- 18.
- 19. Copy and PasteYour Data
- 20.
- 21. Create a PrimaryKey and sequence
- 22. Object Detail forTable Created (in Object Browser)
- 23.
- 24. Create the applicationform scratch
- 25. Add Report andForm based on Hardware table
- 26. Could add asmany pages as you want
- 27. Select Levels ofTabs
- 28. Can Share Componentsfor other applications
- 29. Specify Security andLanguage
- 30.
- 31.
- 32. Run your newApplication! (you will need to log in)
- 33. Instant Application !Searchable report Links to edit individual rows
- 34.
- 35. Instant Application !Analysis Chart and Report
- 36.
- 37. Main Components ApplicationBuilder SQL Workshop Utilities
- 38. Main Components ApplicationBuilder Centerpiece of APEX Loaded with wizards Reports, forms and charts Connect pages using branches Basic HTML, pop-up lists, calendars etc. Data entry validation
- 39. Main Components SQLWorkshop Interact with your database as with SQL*Plus Data dictionary and object browsing
- 40. Main Components UtilitiesLoad/Unload data into/from Database Generate DDL Object report
- 41. Components of anApplication Page Region Region Item Navigation Application Button Tabs Breadcrumbs
- 42.
- 43. Basic components of page
- 44. Basic components of page Page Rendering Regions Buttons Items Computations Processes
- 45. Basic components of page Page Processing Computations Validations Processes Branches
- 46. Basic components of page Shared Component Tabs Breadcrumbs Navigation Bar LOV’s (Lists of Value Theme Templates Security
- 47. Every Object has attributes and almost everything is editable All of the basic attributes collected through the wizards, and many more detailed attributes are editable through an elements attribute/edit page. All of this information is called Meta Data.
- 48. Attribute/Edit Pages Attributesin regions by logical groups Quick navigation to each region Many items are select lists Almost all have context sensitive help
- 49. Use the WizardsAPEX’s many wizards will simplify your life Reports, Forms, Charts, Calendars, Trees etc.
- 50.
- 51. Better Navigation Menusand tabs with images Site Maps Dashboards
- 52.
- 53.
- 54. Security Two levelsAuthentication - controls initial access to the application Authorization - can control access to tabs, pages, regions, items, buttons, read/write vs read only etc
- 55.
- 56. Advanced Topics DebuggingUsing Collections Incorporating JAVA functionality with JAVA Script and AJAX Sending Mail Securing Application
- 57. About iWare LogicTechnologies’ APEX Services iWare Logic, an Oracle Gold Partner, focuses on Oracle Enterprise Applications. Our competitive rate structure represents value that is unique in professional services today. iWare Logic’s Oracle APEX offerings: Offshore Development Fresh Development Migration Project Support End to End Training Basic APEX Training Advance APEX Training
- 58.
- 59. iWare Logic TechnologiesPvt. Ltd. Aditi Samruddhi, Baner, Pune , India - 411045 Email: [email_address] Website: www.iwarelogic.com Thank You