Wednesday, August 26, 2020

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

No comments:

Post a Comment