TOAD and PLSQL default date display, rowid display, TNSNAME modification, plsqlrowid

TOAD and PLSQL default date display, rowid display, TNSNAME modification, plsqlrowid

First, let's talk about the problem to be solved:

Selectrowid, acct_id, state_date from acct;

After modification, 1) the SQL statement specifies the rowid, which can be displayed. 2) The time format is YYYYMMDD HH24: MI: SS. 3) if the number is too long, it is not displayed using scientific notation.

TOAD 64BIT, plsql developer 32BIT, and their respective ORACLEINSTANT clients

Select the path of oracle instanct client to install TOAD through the installation package; manually place the path of plsql developer, and select oracle_home and oci. dll in the settings

Environment variable: you only need to configure NLS_LANG and TNS_ADMIN

Set the time display and ROWID display to avoid the impact of windows format settings (the default settings for windows in Chinese and English versions are different ):

Time Display: YYYY/MM/DD HH24: MI: SS, can be displayed when querying rowid

 

Modify the export insert statement:

Number super long cancel scientific notation display:

Select * from is replaced by a shortcut character:

Time Display: YYYY/MM/DD HH24: MI: SS

Number super long cancel scientific notation display:

 

Windows format settings