e-Commerce Applications Using Oracle8i and Java from Scratch

Querying and Manipulating JavaStop Using SQL

Oracle provides several commands for manipulating data. We will look at the basic commands for data retrieval and manipulation, namely, SELECT, INSERT, UPDATE, and DELETE. Each of these commands is quite a complex syntax when you consider the various options available with them. Please refer to the Oracle SQL Reference guide for the complete set of options available. In this chapter we will look at the basic but most powerful options available with these DML statements.

The INSERT Statement

The INSERT command is used with existing tables or views to add new information to the database. In order to insert data into an existing table or view, you should have the INSERT object privilege for that object ...