A collection of 17 FAQs on Oracle SQL DDL statements. Clear answers are provided with tutorial exercises on creating, altering and dropping tables, indexes, and views; adding, renaming, and dropping table columns. Topics included in this FAQ are:
What Are DDL Statements?
How To Create a New Table?
What Happens If You No CREATE Privilege in a Database?
How To Get a List of All Tables in a Database?
How To Get a List of Columns in an Existing Table?
How To See the CREATE TABLE Statement of an Existing Table?
How To Create a New Table by Selecting Rows from Another Table?
How To Add a New Column to an Existing Table?
How To Delete an Existing Column in a Table?
How To Rename an Existing Column in a Table?
How To Rename an Existing Table?
How To Drop an Existing Table?
How To Create a Table Index?
How To Get a List of Indexes of an Existing Table?
How To Drop an Existing Index?
How To Create a New View?
How To Drop an Existing View?
Monday, October 16, 2006
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment