Рет қаралды 5,100
Whenever you create a sales application you add a mandatory customer management module to it. This video of the Oracle APEX free tutorial series will guide you to maintaining profiles of customers including their ids, names, and addresses. This information is then used in other application segments - for example, customer orders and invoices. Every new customer is provided with a unique id, either manually or automatically, by a built-in process. Here, these ids will be generated automatically through a database object called a Sequence. Using this information you can analyze a business. For example, you can evaluate how much business you have done with your customers either by location or by product, as you did in the previous video where you created the Top Customers region.
Topics covered in this video
=======================
- Modify the Oracle APEX application and create a new page using a walk-through wizard
- Modify and customize wizard-generated page items
- Modify and customize wizard-generated processes
- Modify wizard-generated dynamic action
- Create an interactive grid page
- Map an application page to a navigation menu entry
- Hide table columns in an interactive grid at runtime
- Replace auto-generated SQL statement with a custom query
- Sort data in an interactive grid via the Actions menu
- Create a link using the Link Builder
- Add, update, and delete table records without coding
- Using substitution string as a column value parameter
- Save and run a page
- Make input page items mandatory with Value Required property
- Interactive Grid's search feature
- Remove a customer from the database
- Create application pages using wizards
- Using Interactive Grid to display information in tabular format
- Web input form to insert, update and delete data
- Use of Modal Page
- Change the type of page items
- Customizing wizard-generated pages to make them more professional
- Creating custom links to switch between two pages
- Positioning form input elements using 12 columns layout
- Marking mandatory fields
- Enforce data validation with PL/SQL Code and PL/SQL Expression
- Understand how APEX transparently manages DML operations (Insert, Update, and Delete) without writing a single line of code
- Modify form input items using 12 columns grid layout
- Change the default type of an item from simple text to a list of values
- Apply an input mask to page items.
- Create validations, to prevent customer record deletion with existing orders and to check customers’ credit limits.
- Use a dynamic action to automatically refresh a page.
This module is based on the DEMO_CUSTOMERS table, which was created in the part 2 video. In this video, you’ll create two pages with the help of the Oracle APEX wizard to view and edit customers’ information. The first one (Page 2) is an interactive grid, which displays a list of all customers from the aforementioned database table using a SQL SELECT query. The second one (Page 7) is an input form to receive details of a new customer, modify the record of an existing customer, and delete one from the database. To keep data integrity, those customers who have some existing orders cannot be removed from the database - see (Part-2 video). Each customer’s name appears as a link in the interactive grid. When you click the name of a customer, the form page appears with the complete profile of the selected customer.
Download Source Code From Here:-
drive.google.c...
The content of this video is taken from my book "Create Rapid Low-Code Web Applications in Oracle APEX"
www.amazon.com...