Oracle Database 10g SQL > Introduction > Modifying an Existing Row in a Table - Pg. : Safari Books Online

Table of Contents

Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

This Book

Oracle Database 10g SQL

Oracle Database 10g SQL

Search

Contents

Table of Contents

About the Author

Acknowledgments

Ch. 1. Introduction

What Is a Relational Database?

Introducing the Structured Query Language (SQL)

Performing a SELECT Statement Using SQL*Plus

The SQL*Plus Worksheet

Creating the Store Schema

Adding, Modifying, and Removing Rows

Modifying an Existing Row in a Table

Removing a Row from a Table

The New Oracle10g BINARY_FLOAT and BINARY_DOUBLE Types

Quitting SQL*Plus

Introducing Oracle PL/SQL

Ch. 2. Retrieving Information from Database Tables

Ch. 3. Using Simple Functions

Ch. 4. Storing and Processing Dates and Times

Ch. 5. Using SQL*Plus

Ch. 6. Subqueries

Ch. 7. Advanced Queries

Ch. 8. Changing Table Contents

Ch. 9. Database Security

Ch. 10. Creating Tables, Sequences, Indexes, and Views

Ch. 11. Introducing PL/SQL Programming

Ch. 12. Database Objects

Ch. 13. Collections

Ch. 14. Large Objects

Ch. 15. Running SQL Using Java

Ch. 16. High Performance SQL Tuning

Oracle Data Types

URL

Help

Modifying an Existing Row in a Table

You use the UPDATE statement to change rows in a table. Normally, when you use the UPDATE statement, you specify the following information:

The table containing the rows that are to be changed
A WHERE clause that specifies the rows that are to be changed
A list of column names, along with their new values, specified using the SET clause

You are currently reading a PREVIEW of this book.

Get instant access to over
$1 million worth of books and videos.

Start a Free Trial