Shulou(Shulou.com)05/31 Report--

This article mainly introduces the Oracle commonly used tools-oracle sql developer how to install and use, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

Step 1: check the environment variable [oracle@prod ~] $env | grep ORAORACLE_SID=PRODORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 step 2: enter the sqldeveloper path under $ORACLE_HOME [oracle@prod ~] $cd $ORACLE_HOME/sqldeveloper [oracle@prod sqldeveloper] $ls-lrttotal 196RW Murray. 1 oracle oinstall 4185 Feb 7 2006 otn_new.css-rw-r--r--. 1 oracle oinstall 1355 Jun 1 2007 raptor_image.jpg-rw-r--r--. 1 oracle oinstall 24179 Feb 26 2009 relnotes.html-rwxr-x---. 1 oracle oinstall 71 Jun 12 2009 sqldeveloper.sh-rw-r--r--. 1 oracle oinstall 577 Jun 12 2009 sqlcli.bat-rw-r--r--. 1 oracle oinstall 489 Jun 12 2009 sqlcli-rw-r--r--. 1 oracle oinstall 1404 Jun 12 2009 icon.png-rwxr-x---. 1 oracle oinstall 102400 Jun 12 2009 sqldeveloper.exedrwxr-xr-x. 3 oracle oinstall 4096 Sep 9 2017 dvtdrwxr-xr-x. 3 oracle oinstall 4096 Sep 9 2017 BC4Jdrwxr-xr-x. 3 oracle oinstall 4096 Sep 9 2017 jdbcdrwxr-xr-x. 3 oracle oinstall 4096 Sep 9 2017 j2eedrwxr-xr-x. 9 oracle oinstall 4096 Sep 9 2017 idedrwxr-xr-x. 6 oracle oinstall 4096 Sep 9 2017 jdevdrwxr-xr-x. 3 oracle oinstall 4096 Sep 9 2017 rdbmsdrwxr-xr-x. 7 oracle oinstall 4096 Sep 9 2017 sqldeveloperdrwxr-xr-x. 2 oracle oinstall 4096 Sep 9 2017 timingframeworkdrwxr-xr-x. 3 oracle oinstall 4096 Sep 9 2017 libdrwxr-xr-x. 2 oracle oinstall 4096 Sep 9 2017 jlib step 3: execute the. / sqldeveloper.sh command [oracle@prod sqldeveloper] $. / sqldeveloper.shOracle SQL Developer Copyright (c) 2008, Oracle. All rights reserved.

Then a prompt box "would you like to migrate settings from a previous release?" pops up.

Here we can choose no.

Click close, then right-click on the left and select "New Connection"

Pop-up configuration information interface

Click "test" after the configuration information, and see the description of Success in the lower left corner that you can connect successfully.

After clicking connect, you can perform the query operation.

Next, it's time for free operation.

Thank you for reading this article carefully. I hope the article "tools commonly used in Oracle-how to install and use oracle sql developer" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.