For the use of Oracle databases, it is important to create a table that meets your needs, so let's create the first table of our own
There are two ways to create a table:
(1) More needs to be created inside CMD
(2) created in SQL Developer, and there are two ways to create in the visual interface Sqldeveloper, one is to create using the command directly, and the other is to use the Visual interface button to create a click
The following are the specific processes that are created:
(1) First, we carry out data connection, in the Sqldeveloper operation, in the use of sqldeveloper need to download Sqldeveloper, click here to download: Download sqldeveloper, download installation, Open the Sqldeveloper software, and then click on the upper left corner of the green "+", will pop up as shown in the following dialog box, (in the setting of the first need to unlock the account, the first login is best to use the administrator has unlocked the account to login, login mode and this similar) and then set
Figure 1 Login to Oracle System
After the connection is successful we can see the interface shown below
Figure 2 The results of the successful connection show
(2) to start creating a table, we create a simple table about news information, which contains the following information:
Figure 3 The information table that you want to create
The following table is created: Left click on the database connection name to build the table open, in the "Table (filtered)" option to right-click Select "New Table", and then the New Table dialog box appears, as shown in the following figure:
Figure 4 New Table
Then in the pop-up dialog box to set the table format, as shown in the following steps, for the fields that need to add characters double-click Modify can be, and then save:
Figure 5 Table creation
After you save it, you can see the following table samples on the right:
Figure 6 The new table created
Then let's insert the data, as shown in the following code:
Insert into newmessage values (1,1,1,1, ' Sue Girl's News management system website began operation ', ' today is the Gregorian calendar May 16, 2016, Monday, Sue Girl's website officially began operation, which, rich subject matter will be the highlight of this website ', ' Www.csdn.com contains a lot of good articles ', ' Sue Girl ', ' Sue girl ', ' admin ', 1, ' Monday May 16, 2016 ', 100,1,1; select * from Newmessage;
The post-insert interface looks like this:
Figure 7 The result interface after a successful insert
The above is the process of creating a new table.
The above is the entire content of this article, I hope to help you learn, but also hope that we support the cloud habitat community.