Sqldeveloper Installation and Usage tutorials

Source: Internet
Author: User
Tags documentation

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.