Oracle Application Express 5.1 Basics & Beyond: A practical guide to rapidly develop data-centric web applications accessible from desktop, laptops, tablets, and smartphones by Riaz Ahmed
Author:Riaz Ahmed [Ahmed, Riaz]
Language: eng
Format: azw3
Published: 2017-01-18T16:00:00+00:00
7.5.7 Add LOV
Right-click the Existing Customer sub-region and select Create Page Item. Set the following properties for this item. The Type value (under Source) is set to Null, because the IDs and names of customers are retreived using a SQL query and displayed in a Popup LOV.
Property
Value
Name
P11_CUSTOMER_ID
Type
Popup LOV
Label
Customer
Template
Required
Width
70
Value Required
No
Type (under List of Values)
SQL Query
SQL Query
select cust_last_name || ', ' || cust_first_name d,
customer_id r
from demo_customers
order by cust_last_name
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(8299)
Azure Data and AI Architect Handbook by Olivier Mertens & Breght Van Baelen(6737)
Building Statistical Models in Python by Huy Hoang Nguyen & Paul N Adams & Stuart J Miller(6713)
Serverless Machine Learning with Amazon Redshift ML by Debu Panda & Phil Bates & Bhanu Pittampally & Sumeet Joshi(6590)
Data Wrangling on AWS by Navnit Shukla | Sankar M | Sam Palani(6375)
Driving Data Quality with Data Contracts by Andrew Jones(6322)
Machine Learning Model Serving Patterns and Best Practices by Md Johirul Islam(6089)
Learning SQL by Alan Beaulieu(5995)
Weapons of Math Destruction by Cathy O'Neil(5779)
Big Data Analysis with Python by Ivan Marin(5362)
Data Engineering with dbt by Roberto Zagni(4359)
Solidity Programming Essentials by Ritesh Modi(4009)
Time Series Analysis with Python Cookbook by Tarek A. Atwan(3866)
Pandas Cookbook by Theodore Petrou(3577)
Blockchain Basics by Daniel Drescher(3294)
Hands-On Machine Learning for Algorithmic Trading by Stefan Jansen(2905)
Feature Store for Machine Learning by Jayanth Kumar M J(2814)
Learn T-SQL Querying by Pam Lahoud & Pedro Lopes(2796)
Mastering Python for Finance by Unknown(2744)
