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.
This blog covers Unix system administration HOWTO tips for using inline for loops, find command, Unix scripting, configuration, SQL, various Unix-based tools, and command line interface syntax. The Unix OS supports tasks such as running hardware, device drivers, peripherals and third party applications. Share tips/comments. Read the comments. But most importantly: Read Disclaimer - Read Disclaimer.
No comments:
Post a Comment