Sql Fundas

sometimes we spend very hard time by using some weird inner joins, group by clauses and nested queries for retrieving set of data from our database. Thumb rule : when finding the rows that you want is moving very hard , then try eliminating rows that you don’t want to be there. one simple delete … Continue reading Sql Fundas

Rate this:

ORA – 1205, TNS: listener does not currently know of SID given in connection descriptor

This error occurred in my code when i was trying to connect oracle 11g using java . 1. Jdbc connectivity code was perfect 2. Oracle service was running 3. Was able to login sqlplus 4. Database startup and shutdown commands were working . 5. All sql queries worked fine Even thought i was not able … Continue reading ORA – 1205, TNS: listener does not currently know of SID given in connection descriptor

Rate this: