Stack Overflow
Stack Overflow

Questions tagged [tabular-form]

A tabular form enables users to update multiple rows in a table in an Oracle database at once from a single page. Use for questions about tabular forms, not an abbreviation for "tabular format".

A tabular form enables users to update multiple rows in a table at once using a single page. You can use the Tabular Form Wizard to create a tabular form that contains a built-in multiple row update process. This built-in process performs optimistic locking behind the scenes to maintain the data integrity.

Taken from http://docs.oracle.com/html/E39147_04/app_forms002.htm

54 questions
8
votes
1 answer

Update Apex Tabular form with PLSQL

How can I update an Apex Tabular Form with pl/sql instead of using a multi-row update(MRU), is it even possible? Thanks in advance.
maximus
  • 2,417
  • 5
  • 40
  • 56
4
votes
2 answers

APEX Tabular Form with [row selector]: How to set value of column in selected rows on submit

I have a tabular form that displays all requests submitted for processing. Submitters have the opportunity to cancel requests at any time. I would like this to be accomplished by simply checking the row selector checkbox of the row(s) that should be…
Spags
  • 531
  • 5
  • 13
  • 26
3
votes
3 answers

Convert JSON to vertical table

I have the below payload, and what I am trying to produce is a horizontal column output like such, with a newline between entries. Does someone know how this can be achieved? Either in jq directly or with some interesting bash. : StackId …
Christian Bongiorno
  • 5,150
  • 3
  • 38
  • 76
3
votes
2 answers

How to enable select list when related checkbox is checked in interactive report in APEX 5.1

I have created an interactive report on SQL query in Oracle APEX 5.1 and i have added two more columns to query. One is checkbox for each row in report and other one is select list containing numbers for each row. SQL query is written below. What i…
Arda Tümay
  • 77
  • 1
  • 10
3
votes
1 answer

Dynamic calculation in oracle apex tabular form : sys.htp.p

I have tabular form where col1 and col2 are numbers, and col3 should contain the difference between col1 and col2. col1 has already had data and col 1 is editable, based on change in col1, col3 data will dynamically change. To achieve this I have…
ApexDev
  • 187
  • 1
  • 2
  • 9
3
votes
3 answers

Oracle APEX tabular form, need to make a column Read Only. Except on a new row when “Add Row” is clicked

I am new to Oracle APEX. Can you please help me with below issue? I am using APEX 5.0 I have a master detail page where I have a Tabular form. One of the column is using LOV from select list. Now I have to make this column values as read only so…
user3780030
  • 81
  • 2
  • 8
2
votes
2 answers

APEX - Can a Tabular Form with its MRU functionality have filtering functionality like an Interactive Report?

What I really need is a Tabular form that allows me to update multiple rows at a time while being filterable like an Interactive report. Any chance this is even remotely possible? I would also like to hijack the row checkboxes on a tabular form that…
Spags
  • 531
  • 5
  • 13
  • 26
2
votes
1 answer

Present Matrix in tabular form C Programming

Currently, I am trying to use the linked node to represent the matrix. My codes are working fine, while I not sure it is possible to represent my matrix in tabular form instead of (x,y) = value I want to represent it like(consists of zero element…
RogerSK
  • 393
  • 1
  • 18
2
votes
4 answers

How to increase number of displayed rows in a tabular form using apex 5.0

Currently my tabular form displays 10 rows at a time. How do I increase the number of rows to be displayed, say from the current default number of 10 to something like 20? Is there a place somewhere in the page attribute where you can set the…
mmdbbldr
  • 21
  • 1
  • 1
  • 2
2
votes
1 answer

current row version identifier changed

I have a Master Detail form in my apex application. Here is my Tabular Form Region Source. select "ITEM_ID", "ORDER_ID", "QUANTITY", "PRICE", "NOTE", wwv_flow_item.md5(QUANTITY) "item_hash" -- set to 'hidden' in tabular form from…
Bishan
  • 15,211
  • 52
  • 164
  • 258
1
vote
1 answer

Calculate Sum of Oracle Apex Tabular Form Field

There is a column as Price in my oracle apex tabular form. I need to calculate sum of all fields under this column and assign it to hidden field in Master form for validation. Actually there is a filed as Total_Price in master form. Value of this…
Bishan
  • 15,211
  • 52
  • 164
  • 258
1
vote
0 answers

Converting time series to tabular form

I have 8 ids and want to build a model with these ids. Then make forecasting these labels because labels are our target variable and we want to predict it for each id. Additionally, I want to make the dataset tabular from the time series. How can I…
Şeyma Günönü
  • 11
  • 2
1
vote
1 answer

How to create a new calculated column in Excel - Getting data from SSAS model into an excel tabular form

We are loading data from an SSAS model into an excel tabular form and we are trying to put information in a second column depending on the first one, In this case we have 2 fields coming from the SSAS: Amendment Amount and Record Date, we are trying…
Mat.B
  • 31
  • 1
1
vote
1 answer

Represent Matrix in tabular form C++

Currently, I am trying to use the linked node to represent the matrix. My codes are working fine, while I not sure it is possible to represent my matrix in tabular form instead of (x,y) = value. While my printout() method only print it out when temp…
RogerSK
  • 393
  • 1
  • 18
1
vote
1 answer

Oracle Apex Tabular forms apex_application.g_f array not populating

I am in the process of developing a Tabular form based on a simple query from a table. I have added the add row functionality in the form. Now, here is what I want to do. Let's say my query is based on emp table, and when the user enters the empid I…
Jeby Sebastian
  • 41
  • 1
  • 2
  • 7
1
2 3 4