Oracle--sql Developer Create connection and use

After installing Oracle, there are several ways to manage the database in Oracle, first of all, landing on the web version of the interface: Https://localhost:1158/em, this way to manage too many things, it is a little inconvenient to use, The second way in the CMD on the use of sqlplus input user name password login, this way need to remember SQL statement used to be convenient, a bit bad, such as find a query a table what constraints, this statement I search for a half a day not found, and in MySQL just use show create Table <tablename>, accustomed to the show command of MySQL, was a bit sad with this sqlplus. The third uses a graphical management interface, such as

SQL Developer, Plsql Developer. SQL Developer After installing Oracle, configure the JDK to work. The steps to connect to a database using SQL developer are as follows:

1. Create a new connection

Click on the New Connection button will be able to pop up the connection to create the connection interface settings related parameters, click on the parameters set up the interface as follows:

Need to fill in the parameters have connection name, user name, password, sid options, the default has been filled with the host name, port, if you modify the port, then you can not use the default value

When you are done, you can click the Test button to test the success.

See a status of success, then click the Connect button

The above window is successful, you can manipulate the data sheet now.

Oracle--sql Developer Create connection and use