How do you delete rows specified from an object in oracle?

Question

I have a drop down box on a page in my oracle apex application, I'd like to use the drop down box which displays a company's data(company name) within the company table (which I have achieved); which the user can use to identify specifically what company they'd like to delete. I'd then like to use a button to delete the selected company, and that's what I cannot figure out.

So far I have got as far as using dynamic actions to delete every entry in the table.

Pseudo code for what I am trying to achieve:

SELECT COMPANY_ID FROM COMPANYLIST,
DELETE SELECTED;

Company list being the drop-down box name.

20 hrs. Does no one have an answer to this? @Dmitry

Jurdun
– Jurdun

2017-12-05 20:43:06 +00:00
Commented Dec 5, 2017 at 20:43 — Jurdun
– Jurdun, Commented Dec 5, 2017 at 20:43

RLOG · Accepted Answer · 2017-12-06 09:19:19Z

1

It sounds like you are just struggling with the delete statement?

It should be something like this.

DELETE FROM company
WHERE company_id = (SELECT company_id 
                    FROM companylist
                    WHERE upper(company_name) = upper(:P1_COMPANY_NAME) );

Replacing company with whatever your company table is called, and :P1_COMPANY_NAME with whatever your select list item is.

answered Dec 6, 2017 at 9:19

RLOG

6406 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Jurdun Over a year ago

The ':' selects the element on the page? in my case the drop down box.

Jurdun Over a year ago

Where is says "delete from company" and "select company_id from companylist" did you not mean to write them both the same? company = companylist?

RLOG Over a year ago

Yes : references the page item. If it is just one table then they will both be company list yes, I assumed two tables from reading your first post.

RLOG Over a year ago

Can you post your select list query?

Jurdun Over a year ago

It's fine now, it seems to be working. I had trouble as I was using the code in a dynamic action, however using it instead in a process seemed to work for me.

Collectives™ on Stack Overflow

How do you delete rows specified from an object in oracle?

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related