Toad and Plsql default date display, ROWID display, tnsname modification

Source: Internet
Author: User

First, the problem to be solved:

Selectrowid,acct_id,state_date from acct;

Modified, 1) SQL indicates ROWID, can be displayed 2) time format shown as YYYYMMDD HH24:MI:SS 3) for numbers that are very long, do not use scientific notation to display

    1. Installation and Environment (toad and Plsql coexist)

TOAD 64BIT, Plsql DEVELOPER 32BIT, respective oracleinstant CLIENT

Toad Select the Oracle instanct client path installation through the installation package, Plsql developer manually put the path, select Oracle_home and Oci.dll in the settings

Environment variables: Simply configure Nls_lang, tns_admin

    1. Toad changes to the default configuration

Set the time display and ROWID display to avoid windows formatting effects (different Windows default settings in English and Chinese):

Time display: Yyyy/mm/dd HH24:MI:SS, query rowID can be displayed

?

Export INSERT Statement Modification:

Number super long Cancel scientific counting method shows:

SELECT * from uses shortcut characters instead:

    1. Plsql Developer Default configuration modifications
Time Display: Yyyy/mm/dd HH24:MI:SS

Number super long Cancel scientific counting method shows:

?

Windows format settings

Toad and Plsql default date display, ROWID display, tnsname modification

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.