CODEWITHSUNDEEP
oracle-databaseoracle-apex
StarCrossed
StarCrossed

Reputation: 361

editable oracle apex table

I would like to create an editable table with long paragraphs in the left side and input columns in the right something like that: assessment table where values 5 and test are inputs

kindly help.

Upvotes: 0

Views: 376

Answers (1)

Littlefoot
Littlefoot

Reputation: 142705

Such a table might be one option:

SQL> create table assessment
  2    (id            number constraint pk_asmt primary key,
  3     elements      clob,
  4     bond_scale    number,
  5     remarks       varchar2(200)
  6    );

Table created.

SQL>

In Apex, create a "Report with Form on a table" layout; the Wizard will create Interactive report (so that you could review what you've got; don't display the whole elements column, maybe just a substring of first e.g. 200 characters) and a Form. Icon at the beginning of each report line will lead you to form so that you could update/delete those records. Also, report will have a Create button to let you create new entries.

Upvotes: 1

Related Questions