filmov
tv
SQL with Oracle 10g XE - Using DELETE to Remove a Row from a Table

Показать описание
In this video I use the DELETE command to remove an entire row from a table. When using the DELETE command be sure to use the keywords FROM and WHERE to choose the table and record you wish to delete. The code I used is:
DELETE
FROM BOOKS
WHERE BOOK_ID = '11';
DELETE
FROM BOOKS
WHERE BOOK_ID = '11';
SQL with Oracle 10g XE #1 Creating Student Table
SQL with Oracle 10g XE - Creating a New User
Basic SQL commands - Oracle 10g XE
SQL with Oracle 10g XE - Using AND and OR with SELECT
SQL with Oracle 10g XE Using the UPPER and LOWER Functions
SQL with Oracle 10g XE - Getting Started
SQL with Oracle 10g XE - Using the DISTINCT Function
SQL with Oracle 10g XE - Using INSERT to Add Data to a Table
SQL with Oracle 10g XE - Using CREATE TABLE to Build a Table
SQL with Oracle 10g XE Using the ROUND and FLOOR Functions
SQL with Oracle 10g XE Creating a New User
SQL with Oracle 10g XE Using DESCRIBE to View the Table Structure
SQL with Oracle 10g XE - Using SELECT and WHERE to Query a Table
SQL with Oracle 10g XE 2 How to Alter Table
SQL with Oracle 10g XE - Using IN and BETWEEN with SELECT
SQL with Oracle 10g XE - Using SELECT to View the Entire Table
SQL with Oracle 10g XE - Table Overview and Basic Data Types
SQL with Oracle 10g XE - Creating Calculated Columns with SELECT
SQL with Oracle 10g XE Using CREATE TABLE to Build a Table
SQL with Oracle 10g XE - Using ORDER BY to Sort Data with SELECT
SQL with Oracle 10g XE Using DELETE to Remove a Row from a Table
SQL with Oracle 10g XE - Using DELETE to Remove a Row from a Table
SQL with Oracle 10g XE Using the DISTINCT Function 1
SQL with Oracle 10g XE Using SELECT to View the Entire Table
Комментарии