oracle - How to add custom column in tabular form? -
my current tabular form displaying columns table.
how/where can add together custom column in tabular form, link or button , take page input info row?
example
id [name] [address] [link or button here]
to add together custom column:
go "region definition" -> "source", add together new column sql query there. example:
select col1, -- column of table col2, -- column of table 'some text' custom_column -- custom column contain text "some text" -- in every row my_table
go "report attributes", select column name "custom column" , click "edit" button (pencil picture), go "column link" , fill fields:
link text - text display, can write own static text, text column of query or picture target - page in application or link outer site page - number of target page item - item on target page receive value link value - value, send item. can either static value or value of column of query (in case utilize substitution string: "#" symbol , column name: #column_name#).see documentation understanding apex url syntax: http://docs.oracle.com/cd/e37097_01/doc/doc.42/e35125/concept_url.htm
oracle oracle-apex
No comments:
Post a Comment