Tag Archives: 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

Oracle SQL Joins

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

SQL to convert Comma Separated String to Rows

Convert Comma separated List to rows SELECT TRIM( SUBSTR ( txt , INSTR (txt, ‘,’, 1, level ) + 1 , INSTR (txt, ‘,’, 1, level+1 ) – INSTR (txt, ‘,’, 1, level) -1 ) ) AS u FROM ( … Continue reading

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

SQL to Mongo Mapping Chart

This is a PHP-specific version of the » SQL to Mongo mapping chart in the main docs. SQL Statement Mongo Query Language Statement CREATE TABLE USERS (a Number, b Number) Implicit or use MongoDB::createCollection(). INSERT INTO USERS VALUES(1,1) $db->users->insert(array(“a” => 1, “b” => 1)); … Continue reading

Posted in MongoDB, PHP | Tagged , , | Leave a comment

How to fill a increasing values in a column of a table?

How to fill a increasing values in a column of a table? Lets assume we have a tableTable name : test Name Value Yogesh 0 Yogesh 0 Yogesh 0 Yogesh 0 Yogesh 0 Suresh 0 Suresh 0 Requirement : to … Continue reading

Posted in Database, Oracle, Oracle PL/SQL, Server Side Programming | Tagged , | Leave a comment