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