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

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