CODEWITHSUNDEEP
oracle-databaseoracle-apex
Pavlos
Pavlos

Reputation: 35

Restrict the status in Oracle Apex

I have started to learn Oracle Apex, and I follow this document - https://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-spreadsheet-hol-5532109.pdf

I can't understand why on page 27 they use this query 

select distinct status d, status r 
from spreadsheet
order by 1

They use status twice on one table

Thanks in advance

Upvotes: 0

Views: 98

Answers (1)

chrisis
chrisis

Reputation: 1993

It's generating values for a select list. The first column is what is displayed in the select list and the second the value returned when selected. In this case both columns are the same but that isn't required

Upvotes: 3

Related Questions