Updating Oracle tables with one of the columns in DataTables with editable drop down box

siyali

I have a datatable with 4 columns. It is displaying data from Oracle database. There is 1 column which has a drop down box, it is displaying those values fetched from a database table and you can choose one of the drop down values and set it to that column which will ultimately update the database table.

Ex: There are 4 columns in the datatable. 1 column is status, in oracle table it can take values from A to F. So on the web page it will show A to F values in a drop down box for that column and you can choose any of the statuses and use save button which will ultimately update the value in oracle table.

I am not able to add the drop down box code in datatable. Could you please help me with this. Ultimately it should update the oracle table.