Oracle newbie question - Deleting Records

nickelmedia posted this at 18:56 — 18th March 2005.

They have: 1 posts

Joined: Mar 2005

I have a web app that accesses an Oracle DB to store user accounts and sales data. When this app was written, there was no option included to delete any records. I need to add this functionality. I'm not really familiar with Oracle DB's and our company's DBA is in India and cannot assist us because we don't know the specific tables that need deleting.

What information would anybody need to help me with either:

A) Adding a delete button next to the User accounts in our admin panel.

B) Is there something similar to phpMyAdmin for an Oracle DB because I AM familiar with that.

Any help would be greatly appreciated.

timjpriebe posted this at 06:03 — 19th March 2005.

He has: 2,667 posts

Joined: Dec 2004

I'm not sure if there's something similar to PHPMyAdmin or not.

That said, Oracle's SQL usage is fairly standard, so you could just write a web program yourself that at least let you run queries. A standard SQL statement like the following should work fine in your program:

DELETE FROM tablename WHERE condition;

But it looks like you don't even know what tables the records are in. Can you not just look at the code that is displaying the data and find out what table they're in? I wouldn't think an Oracle admin program would be able to tell you that either.

Tim
http://www.tandswebdesign.com