Q&A
| Q1: | With all the warnings about DELETE and UPDATE I'm a little afraid to use them. If I accidentally update all the records in a table because the WHERE clause was not used, can the changes be reversed? |
| A1: | There is no reason to be afraid, because there is not much you can do to the database that cannot be corrected, although considerable time and work may be involved. The next hour discusses the concepts of transactional control, which allows data manipulation operations to either be finalized or undone. |
| Q2: | Is the INSERT statement the only way to enter data into a table? |
| A2: | No, just remember that the INSERT statement is ANSI standard. The various implementations have their tools to enter data into tables. For example, Oracle has a utility ... |
Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
