Wednesday, December 12, 2018

Changing SQL Prompt to Custom value 

set sqlprompt "_user '@' _connect_identifier > "
- No comments:

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
- No comments:
Labels:
Subscribe to: Posts (Atom)

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...