Jijo K Jose

Personal Website

Archive for July, 2013

July 17th, 2013

Linux, OS, Software, Windows

No Comments »

How to fix dictionary tooltips addon in Firefox

The dictionary tooltips add-on is one of my favourite Firefox extension, But it fails to work after my Firefox update to 22. Since the add-on author may need a bit of longer time to release a official update.

NOTE: the add-on is not under an open source license , so using the following process is your risk.

Step 1

Go to your Firefox profile folder, am using windows 7 ( if you are using linux operating system then goto the Firefox profile folder in that OS ) so the profile folder is located in

C:\Users\{your username}\AppData

If you are not able to see AppData then you must enable show hidden files and folders option, to enable this feature do the following

Click Organize (Top left corner) –> Folder and search options –> View (Tab) –> Show hidden files, folders and drive (Radio button) –> Click Ok

Now you can see AppData inside C:\Users\{your username}\ folder, then move to the following folder

C:\Users\{your username}\AppData\Roaming\Mozilla\Firefox\Profiles\{profilename}.default\extensions\

Counting DISTINCT over multiple columns in SQL

My database contents

ID	CLASS_CODE	ROLL_NO	NAME
1	IX	1	Jijo K Jose
2	IX	3	James Jacob
3	X	1	Joy Mathew
4	X	2	Sam George
5	IX	2	Miller John
6	X	3	Thomas John

Display values of distinct rows over one column

select distinct(ROLL_NO) from STUDENT;

ROLL_NO
1
3
2

PL/SQL Procedure to INSERT values with EXCEPTION handling

By using PL/SQL we can execute multiple queries at a time. The following example is used to insert student details from STUDENT_TEMP table to STUDENT table and if any error occurred during the insertion process ( like primary key violation, unique key violation etc ) then the corresponding errors will be captured by the EXCEPTION block and will continue the execution.

create or replace
PROCEDURE STUDENT_ADD_PL AS
BEGIN
   FOR REC IN
   (
    SELECT
       STUDENT_ID,
       ROLL_NO,
       STUDENT_CODE,
       CLASS_ID,
       COLLEGE_NAME,
       PLACE
    FROM STUDENT_TEMP
   )
   LOOP
       BEGIN
           Insert into STUDENT
           (
               STUDENT_ID,
               ROLL_NO,
               STUDENT_CODE,
               CLASS_ID,
               COLLEGE_NAME,
               PLACE