How to write a script or database connectivity to connect oracle databse

[v_selvam]

@Saket - When you connect oracle database, you need the oracle service name which you configured in the 'tnsnames.ora' file.

Here is the example for oracle service name configuration

Code:

ORA_Servicename =
(DESCRIPTION =
   (ADDRESS_LIST =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
   )
(CONNECT_DATA =
   (SERVICE_NAME = DataBaseName)
)
)

In the above code, 'ORA_Servicename' is service name. The connecting string is given below
ConnectionString = "User Id=scott;Password=tiger;Data Source=ORA_Servicename;"