Delete row - Dev Shed

Dev Shed Forums Sponsor:

Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!

February 9th, 2005, 06:42 AM

Civ247

ID10T

Join Date: Feb 2004

Location: Yes

Posts: 617

Time spent in forums: 4 Days 22 h 51 m 3 sec
Reputation Power: 21

Delete row

How do i delete aow drom a table? Delet doesnt seem to work. Keeps telling me invalid table name.

February 9th, 2005, 09:38 AM

dancesport_warr

Contributing User

Join Date: Aug 2004

Posts: 130

Time spent in forums: 1 Day 14 h 14 m 36 sec
Reputation Power: 4

U want your query to be something like this:

Code:

delete * from table_name
where some_condition;

So lets say u want to delete the row(s) that has the Name column set to "Bob":

Code:

delete * from table_name
where name = 'Bob';

to see all tables in your database:

Code:

select * from user_tables;

Hope this helps

Comments on this post

Civ247 agrees: Thanks

Viewing: Dev Shed Forums > Databases > Oracle Development > Delete row

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Get Flash