Oracle SQL in 10 Minutes - Asim Abbasi
CH1: SQL Basics | CH2: SQL Operators | CH3: SQL Built-in Functions | CH4: SQL Joins | CH5: UPDATE, INSERT & DELETE Statements | CH6: CREATE, ALTER & DROP Statements | CH7: Constraints | CH8: Linking Tables vs Joining Tables | CH9: SQL Statements for Other Database Objects | CH10: SQL Statements for Database Security
Chapter 5: UPDATE, INSERT & DELETE Statements
Page #: 1
UPDATE, INSERT & DELETE Statements:
UPDATE statement is used to edit the information already existing in the table. If you want to insert a new record in the table then we use the INSERT statement and if you want to delete any record or more than one record we use the DELETE statement.
Figure 11: Other DML Statements: UPDATE, INSERT,
DELETE.
________________________________________
Example:
UPDATE emp
SET comm = NULL
WHERE job = 'TRAINEE';
Example:
INSERT INTO dept
VALUES (50, 'PRODUCTION', 'SAN FRANCISCO');
Another version,
INSERT INTO emp (empno, ename, job, sal, comm, deptno)
VALUES (7890, 'JINKS', 'CLERK', 1.2E3, NULL, 40);
Example:
DELETE FROM emp
WHERE JOB = 'SALESMAN' AND COMM < 100;
Chapter 5: UPDATE, INSERT & DELETE Statements
Page #: 1
CH1: SQL Basics | CH2:
SQL Operators |
CH3: SQL Built-in Functions | CH4:
SQL Joins | CH5:
UPDATE, INSERT & DELETE Statements |
CH6: CREATE, ALTER & DROP Statements | CH7:
Constraints | CH8:
Linking Tables vs Joining Tables | CH9:
SQL
Statements for Other Database Objects | CH10:
SQL Statements for
Database Security Share with others: