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:
Post a Comment