Sqldeveloper Installation and Usage tutorials

1. Installation

: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index-098778.html

After unpacking, run the file below the directory.

The operating interface is as follows:

Sqldeveloper is JDBC-based, so you need to create a connection.

2. Connecting to the Oracle database and its use

For example, enter a 1

3 connecting MySQL database and its use

When you're done, click New Connection to see the MySQL database. It is also necessary to connect to other databases and add the JDBC driver.

Then click Connect

To view the database that is currently in use

Execute Query

View local offline documentation for 4 PL/SQL documents

Online documentation

Website: https://docs.oracle.com/pls/db102/homepage. The operation is the same as above.

To view packages by using commands

The name of the DESC package

Sql> descDbms_outputPROCEDUREDISABLEPROCEDUREENABLE Argument Name Typein/OutDefault? ------------------------------ ----------------------- ------ --------Buffer_size Number( -)inch     DEFAULTPROCEDUREget_line Argument Name Typein/OutDefault? ------------------------------ ----------------------- ------ --------LineVARCHAR2Out STATUS Number( -) outPROCEDUREget_lines Argument Name Typein/OutDefault? ------------------------------ ----------------------- ------ --------LINESTABLE  of VARCHAR2(32767) out Numlines Number( -)in/ outPROCEDUREget_lines Argument Name Typein/OutDefault? ------------------------------ ----------------------- ------ --------LINES Dbmsoutput_linesarray out Numlines Number( -)in/ outPROCEDURENew_linePROCEDUREPUT Argument Name Typein/OutDefault? ------------------------------ ----------------------- ------ --------AVARCHAR2                inchPROCEDUREput_line Argument Name Typein/OutDefault? ------------------------------ ----------------------- ------ --------AVARCHAR2                inch

Sqldeveloper Installation and Usage tutorials