SQLDeveloper copying Connections.xml

Sharing connections across the team members in SQLDEVELOPER is a breeze.
Step1: get the connections.xml from any one of the users and copy to your local directory (In Linux it is found at .sqldeveloper/system2.1.1.64.45/o.jdeveloper.db.connection.11.1.1.2.36.55.30/ directory).

Step 2: When I started the SQLDEVELOPER (if you want to know how to add SQLDEVELOPER to your linux menu click here), and clicked on one of the connections that appears on the left, I got an error (Screen 01)

Screen -1

A little investigation showed that I had missed setting the ORACLE_HOME variable correctly. After correcting this, reclicking on the connection I got ocijdbc11.in.java not in library path (Screen -2)

Step 3:
 If I select connection type as Basic (instead of TNS), and the enter values needed, I am connected!. (Screen -3)

Screen -3

SQLDeveloper: Sharing Shortcuts across the team

SQLDeveloper has an utility to export the short-cuts. It is an excellent way to ensure that short-cuts, are kept uniform, can be shared across the team. I have listed below steps to export the preferences and import them back.
1) Navigation: Tools-->Preferences (Screen -1)

Screen -1

2) Select Shortcut Keys (Screen -2)

Screen -2

3) Click on More Actions and select Export in the drop-down list (Screen -3)

Screen -3

4) Select the directory to save the file (Screen -4)

Screen -4

5) Importing the preferences is similar; follow the steps 1 & 2 and in step 3, select "Import" instead of "Export" and select file to import. (screen -5)

Screen -5

6). An confirmation window will appear (Screen -6), click on "yes" and the Short-cut preferences will be imported.

Screen -6

ORA-01427: single-row subquery returns more than one row

I faced today, "ORA-01427:sub-query returns more than one row" error. The problem is easy to identify:This error is raised, when a sub-query returns more than one row to an Equality or in-Equality operator. The reason being there are restrictions on the legal comparison operators (Screen -1).

Screen -1

For any comparison operator listed in the table shown below, the sub-query must return single row (in other words, the sub-query, must be a single-row sub-query, otherwise it will fail)

Single-row Sub-query Operators

Symbol	Meaning
=	equal
>	greater than
>=	greater than or equal
<	less than
<=	less than or equal
<>	not equal
!=	not equal

The operators in the following table can use multiple-row sub-queries:

Multiple-row Sub-query Operators

Symbol	Meaning
IN	equal to any member in a list
NOT IN	not equal to any member in a list
ANY	returns rows that match any value on a list
ALL	returns rows that match all the values in a list

There are several approaches to resolve this, most popular one being changing the inequality operator to a multiple-row operators (say, if the operator is "=" than change it "IN", "ANY", "ALL", so that it does not matter if multiple rows are returned.).
However, I found that if you use inline views, you can retain inequality operator as shown below in (Screen -2)

Screen -2

Note: In order to get consistent result, use the sub-query based on primary key. The above method is based on unique key

How to open linux folders in the same window?

Default behavior while opening folders in Linux, meant, a new window for each folder I double-clicked on. To prevent that, and to ensure Linux opens folders in the same window, I followed the steps listed below:
Go to home folder (Screen -1)

Screen -1

Select Edit from the Menu and scroll down to click on Preferences (Screen -2)

Screen -2

Click on Behavior Tab and select "Always open in browser window" (Screen -3)

Screen -3

The explorer view is shown below (Screen -4)

Screen -4