SQLcl connect to Oracle

EZconnect syntax

sql user/password@//hostname/service_name

OCI syntax

sql user/password@jdbc:oracle:oci:@(description=(address_list=(address=.......ODS)))

TNS definition syntax

sql user/password@(description=(address_list=(address=.......ODS)))

SQLcl language setting in Windows environment

I have a PL/SQL procedure doing data dump to a file running it through sqlplus. It was working fine until I switch sqlplus to sqlcl and all numeric fields ended up like 123,45 instead of 123.45.

After googling, I found that it is a java issue and there is a setting for it.

I add the following line to sql.bat and that solved the problem.

set JAVA_TOOL_OPTIONS=-Duser.language=en -Duser.region=US -Dfile.encoding=UTF-8