set sqlprompt "_user '@' _connect_identifier > "
Wednesday, December 12, 2018
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
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...

-
If you do not specify length of a character column in your control file it defaults to CHAR(255). And because of this reason most of the t...
-
I got below error while trying to deploy an already successfully compiled Oracle package from my QA environment to dev environment: ...
-
TWO_TASK variable is for Unix environment, there is a similar variable for Windows - LOCAL. In the Unix environment there are 2 variables ...