O'Reilly logo

OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide by Steve Ries

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Data Manipulation with DML

Thus far, our efforts to utilize database data have been limited to pulling data from the database. We've looked at how to select data, how to limit it based on conditions, and how to sort it. However, we've only worked with data that already existed in our Companylink database, which was created back in Chapter 1, SQL and Relational Databases when you ran the companylink_db.cmd batch file. In this chapter, we examine some of the types of statements that were actually used in that script. These commands allow us to create and modify data in our Companylink database.

In this chapter, we shall:

  • Examine the concept of DML—Data Manipulation Language
  • Create data using the INSERT statement
  • Copy data using INSERT/SELECT ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required