Category Archives: Oracle SQL

How to pass Service Name or SID in JDBC URL

Below is the way to send either Service Name or SID in JDBC URL to connect to Oracle SQL For Service Name @//host_name:port_number/service_name For example: jdbc:oracle:thin:scott/tiger@//myhost:1521/myservicename For SID @//host_name:port_number:service_name For example: jdbc:oracle:thin:scott/tiger@//myhost:1521:myservicename Oracle DOC

Posted in Oracle, Oracle SQL | Tagged , , , , | Leave a comment

When and how much to mix technologies for a project?

The main idea behind using a technology is to harness the power of code re-usability and libraries that have already been worked on and trusted to be working and functional with minimal or no issues. The term “Technology” does not … Continue reading

Posted in Oracle, Oracle ADF, Oracle SQL, OSB, Weblogic | Tagged , , , , , , , , , , | Leave a comment

Oracle SQL Joins

Image | Posted on by | Tagged , , | Leave a comment