Friday, March 02, 2007

Delete a Row From a Database Table

Deleting rows from a database table is fairly simple, too. Here is the syntax to delete row(s) containing the CUST_ID attribute 10001. I wouldn't have added this post but I noticed the SQL action was being routinely searched on via a meta data program I'm using.

Here's the SQL syntax.

ORACLE
SQL> delete from CUSTOMER where CUST_ID = 10001;

SYBASE
1> delete from CUSTOMER where CUST_ID = 10001
2> go

The ";" is the execute command for Oracle and "go" is the execute command for Sybase.

No comments: