This displays the columns in the Connections window. To view the column names for a table, expand the Tables node and then expand the node for the table you wish to view.In chapter 7, you'll learn more about committing and rolling back changes.įigure 2-6 How to view the column definitions and data for a table Or, if you want to rollback the changes, you can click on the Rollback Changes button. Then, if you want to commit the changes to the table, you can click on the Commit Changes button. You can also use the Data tab to modify the data in a row, and you can use the Insert and Delete buttons at the start of this tab to add rows or delete rows. By switching back and forth between the Column and Data tabs, you can quickly see how the data corresponds to the data definitions. To view the data for a table, you just click on the Data tab after you display the column definitions for the table. By default, the columns are displayed in the sequence in which they were created. For each column, this table shows the column name, the data type, an indication of whether or not the column can contain null values, the default value, the position of the column within the table, whether or not the column is a primary key, and any column comments. In this figure, for example, the right-hand window shows a table that contains the definitions for each column in the Vendors table. To view the column definitions for a table, you can click on the table name to display a table that contains the definition of each column. This chapter is excerpted from the book, Murach's Oracle SQL and PL/SQL, authored by Joel Murach, published by Mike Murach & Associates, Inc., August, 2008. In figure 2-6, for example, I expanded the node for the Vendors table so the names for all of columns in the table are displayed below the table. To view the column names for a table, you can expand the node for the table. How to view the column definitions for a table How to use the Oracle Database SQL Reference manual How to use SQL Developer to run SQL statements How to view and edit table column definitions How to use SQL Developer to work with an Oracle database How to work with an Oracle database home page
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |