O'Reilly logo

Oracle Database 11g The Complete Reference by Kevin Loney

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 17Creating and Managing Tables, Views, Indexes, Clusters, and Sequences

Until now, the emphasis of this book has been on using tables. This chapter looks at creating, dropping, and changing tables, creating views, and using options such as index-organized tables. You've seen numerous create table commands to this point; this chapter will reinforce those examples and show how to use the latest options. You will also see the commands for creating and managing views, indexes, clusters, and sequences.

Creating a Table

Consider the TROUBLE table. This is similar to the COMFORT table discussed earlier in the book, but it is used to track cities with unusual weather patterns.

describe TROUBLEName                            Null?     Type------------------------------- -------- ------------ ...

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