Wednesday, December 12, 2018

Changing SQL Prompt to Custom value

set sqlprompt "_user '@' _connect_identifier > "

How to detect if the Java / JRE installed is 32 bit or 64 bit

Programmatically:

System.getProperty("sun.arch.data.model");


Command Prompt:

java -XshowSettings:properties -version

Look for the sun.arch.data.model - it should be either 32 or 64

Convert Java SQL String to Oracle SQL Format in TOAD

At times Toad might reset the capability to strip off / convert the the SQL in Java string format to SQL format. You can have that back...