Javarasi Payasam

Ingredients:

1/2 cup javarasi (sago)
1/2 cup roasted semiya (vermicelli)
1 cup sugar
1/2 cup coconut milk
2 cup milk
a handful of raisins/cashews/pista
1 cardamon
2 spoons of ghee

Preparation:

Bring sufficient water to boil and add javarasi. Once it becomes transparent, it means its cooked. Then add semiya and cook. If un-roasted semiya, then roast it lighlty till golden brown in ghee.
Next add milk. Bring milk to boil and simmer. Add sugar, coconut milk and cardamon.
Seperately in a tawa, add ghee and roast the raisins/cashews/pista. Add these to the payasam and simmer for 1 minute again. Tasty Payasam ready.

What Kevin says...

7 yrs

Started a new award system to Kevin by awarding him with stars for every good thing he does...
When he earns 25 stars, he gets a toy. One day when he earned his reward and was about to go and buy a toy...

kevin: mum are we going shopping now to buy a toy for my reward
me: yes
kevin: (happy and asks) what else are you going to buy?
me: some onions and tomatoes too..
kevin: (unhappy) I did not earn rewards to buy those stuff too.
me: :))

What Keith says...

Keith - 2 month old

keith - Ingha!
meaning - I am hungry..give me food!

Merging changes in Subversion (SVN) with Trunk and Branch

Merging from Subversion (SVN) Trunk into Branch

From: Specify trunk <project_name>
Revision: Choose a revision number (Probably the revision no from which the Branch was created or if previous merges have happened, then the last revision when a merge was done)

To: Check 'Use From URL'
Revision: Head Revision

Merging from Subversion (SVN) Branch to Trunk

From: Specify Trunk <project_name>
Revision: Head revision

To: Specify Branch <branch_project_name>
Revision: Head revision

Trunc function in SQL

In sql when when we use the BETWEEN function to bring out data for a period of date range, some of the records might not come up in the result

for e.g.

SELECT *
FROM orders
WHERE order_date between to_date ('2003/01/01', 'yyyy/mm/dd')
AND to_date ('2003/12/31', 'yyyy/mm/dd');

If the order_date column in database has a time componenet in it, then the results might not come up for the dates 2003/01/01 and 2003/12/31

To solve this problem, we remove the time componenet from the query using the TRUNC function

SELECT *
FROM orders
WHERE trunc(order_date) between to_date ('2003/01/01', 'yyyy/mm/dd')
AND to_date ('2003/12/31', 'yyyy/mm/dd');

DECODE function in SQL

In sql, we can put validation logic by using the DECODE statement

For e.g. if we have a scenario such that all First Names are to be printed out for people who are aged 60, this can be written using decode statement such as

decode(age, 60, first_name, null),


If we add an extra condition to it such that print out the First Names only if they are a Male, then we write as below

decode(age, 60, decode(gender, male, first_name, null), null)

Subquery with NVL

Example 1
select
"EMPLOYEENUMBER",
"LASTNAME",
"FIRSTNAME",
NVL((select extension from classiccars.employee where lastname = 'Murphy'), 'Unavailable'),
"EMAIL",
"OFFICECODE",
"REPORTSTO",
"JOBTITLE"
from
"CLASSICCARS"."EMPLOYEE"

Example 2

SELECT
Parcel.Alt_Key,
substr(trim(Parcel.Full_Parcel_ID),1,8) SubDiv_Number,
NVL(LS.Sub_Name,
(SELECT NVL(V2.Sub_name,'Unknown Subdivision')
FROM SUBDIV V2
WHERE substr(trim(Parcel.Full_Parcel_ID),1,8) =
substr(trim(V2.Sub_Number),1,8)
AND V2.rowid = (select min(sub2.rowid)
from SUBDIV sub2
where (trim(substr(V2.sub_number,1,8))) =
(trim(substr(sub2.sub_number,1,8)))))) SubDiv_Name,
Parcel.Full_Parcel_ID
FROM PARCEL INNER JOIN SALES
ON Parcel.Alt_Key = Sales.Alt_Key
LEFT JOIN
SUBDIV LS
ON substr(trim(Parcel.Full_Parcel_ID),1,10) =
substr(trim(LS.Sub_Number),1,10)