column

Parent: lov

Applies whenlocation in (localDatabase)location in (restEnabledSql)location in (jsonDualityView)location in (jsonSource)location in (restSource)location in (sampleData)

Direct Properties:

PropertyTypeRequiredDefault ValueDetails
columnNamestringYesdata type=string; maxLen=128
showbooleanYestruedata type=boolean

Property Groups:

  • heading
  • layout
  • source
  • appearance
  • advanced
  • comments
heading
PropertyTypeRequiredDefault ValueDetails
headingstringNodata type=string; maxLen=4000
 
heading {
  heading: value
}
layout
PropertyTypeRequiredDefault ValueDetails
sequencenumberYesdata type=number; maxLen=22

Enter the display sequence for this column. The sequence setting determines where this column is displayed in relation to other columns within the list of values.

Note: If two columns, within the same list of values, have the same sequence value then they may be displayed in a different order when the application is exported and imported into another environment, such as a test or production environment. To ensure consistency, Oracle recommends you specify unique sequence numbers for every item, or at least for those within the same list of values.

 
layout {
  sequence: 42
}
source
PropertyTypeRequiredDefault ValueDetails
dataTypeenumYesdata type=string; maxLen=128; lov=STATIC
Valid values: varchar2 number date timestamp timestampWithTimeZone timestampWithLocalTimeZone intervalYearToMonth intervalDayToSecond clob blob boolean rowid bfile sdoGeometry
 
source {
  dataType: varchar2
}
appearance
PropertyTypeRequiredDefault ValueDetails
formatMaskstringNodata type=string; maxLen=255
Applies whendataType in (date)dataType in (timestamp)dataType in (timestampWithTimeZone)dataType in (timestampWithLocalTimeZone)
formatMaskstringNodata type=string; maxLen=255
Applies whendataType = number
formatMaskstringNodata type=string; maxLen=255
 
appearance {
  formatMask: value
}
advanced
PropertyTypeRequiredDefault ValueDetails
searchablebooleanYestruedata type=boolean
 
advanced {
  searchable: false
}
comments
PropertyTypeRequiredDefault ValueDetails
commentsmultiline stringNodata type=multiline string; maxLen=4000
 
comments {
  comments: ```
    value
  ```
}

APEXlang Example

column sample (
    columnName: value
    show: false
    heading {
        heading: value
    }
    layout {
        sequence: 42
    }
    source {
        dataType: varchar2
    }
    appearance {
        formatMask: value
    }
    advanced {
        searchable: false
    }
    comments {
        comments: ```
          value
        ```
    }
)