Cookie Recipe (from Ms.Mae Washington)

Butter: 1/2 cup

Sugar: 3/4 cup

Egg: 1/2

Vanilla Extract: 3/4 tsp

Flour: 1 3/4 cups

Salt: 1/2 tsp

oracle sql - use of case syntax - example

select pm_policy_no_0,
'VOL' as pm_lob,
pm_last_name_of_customer,
pm_first_name_of_customer,
(CASE
WHEN LENGTH(PM_ORIG_INCEPTION_DATE) = 3 THEN
'20000' || trim(PM_ORIG_INCEPTION_DATE)
WHEN LENGTH(PM_ORIG_INCEPTION_DATE) = 4 THEN
'2000' || trim(PM_ORIG_INCEPTION_DATE)
WHEN LENGTH(PM_ORIG_INCEPTION_DATE) = 5 THEN
'200' || trim(PM_ORIG_INCEPTION_DATE)
WHEN LENGTH(PM_ORIG_INCEPTION_DATE) = 6 THEN
'19' || trim(PM_ORIG_INCEPTION_DATE)
WHEN LENGTH(PM_ORIG_INCEPTION_DATE) = 8 THEN
trim(PM_ORIG_INCEPTION_DATE)
ELSE
trim(PM_ORIG_INCEPTION_DATE)
END) AS PM_ORIG_INCEPTION_DATE,
(CASE
WHEN LENGTH(PM_EFF_DATE) = 3 THEN
'20000' || trim(PM_EFF_DATE)
WHEN LENGTH(PM_EFF_DATE) = 4 THEN
'2000' || trim(PM_EFF_DATE)
WHEN LENGTH(PM_EFF_DATE) = 5 THEN
'200' || trim(PM_EFF_DATE)
WHEN LENGTH(PM_EFF_DATE) = 6 THEN
'19' || trim(PM_EFF_DATE)
WHEN LENGTH(PM_EFF_DATE) = 8 THEN
trim(PM_EFF_DATE)
ELSE
trim(PM_EFF_DATE)
END) AS PM_EFF_DATE,
(CASE
WHEN LENGTH(PM_EXP_DATE) = 3 THEN
'20000' || trim(PM_EXP_DATE)
WHEN LENGTH(PM_EXP_DATE) = 4 THEN
'2000' || trim(PM_EXP_DATE)
WHEN LENGTH(PM_EXP_DATE) = 5 THEN
'200' || trim(PM_EXP_DATE)
WHEN LENGTH(PM_EXP_DATE) = 6 THEN
'19' || trim(PM_EXP_DATE)
WHEN LENGTH(PM_EXP_DATE) = 8 THEN
trim(PM_EXP_DATE)
ELSE
trim(PM_EXP_DATE)
END) AS PM_EXP_DATE,
pm_address_city,
pm_address_state_code,
trim(TO_CHAR(pm_zip_code_1,'09999')),
trim(SUBSTR((TO_CHAR(pm_zip_code_2,'0999')),2,5)),
pm_no_of_vehicles,
pm_policy_trans_type
from tblPolicy
where (pm_amend_trans_type = '21' and
(pm_version_date > '070924' and
pm_version_date < '071023') and pm_orig_inception_date > pm_version_date);

JDBC connection to Oracle RAC 10g

• Make sure that the url is used as follows:

static final String dbUri = "jdbc:oracle:thin:@"
+"(DESCRIPTION=(LOAD_BALANCE=on)"
+"(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbHost1*)"
+"(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=dbHost2*)"
+"(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=serviceName))";

*replace these with your own database configuration

• The driver class that needs to be in palce is:

oracle.jdbc.OracleDriver

• Get classes14.jar (JDBC Driver) from this link:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html

I tested this on Websphere Application Server v6 with RAD7 and it worked fine.

International Baggage

Each passenger can check in 2 bags each weighing 50 pounds or 23 kgs. Each gets to carry one piece on board which should be under 6kgs. I verified US air, Lufthansa and British Airways and all of them have the same rules for flights from US.

Podula paallu

Chaaru:
Miriyaalu - 1 cups
Dhaniyaalu - 4 cups
Jeelakarra - 1 cups
Kandipappu - 2 cups
Sanagapappu - 1 cups

Saambaaru:
Biyyam - 6 tsp
Dhaniyaalu - 2 cups
Mentulu - 3 tsp
Minapapappu - 0.75 cups
Sanagapappu - 0.75 cups

browsing internet at work

There is a lot of noise made about workers using internet at work. There are all kinds of statistics describing how much time was lost due to this. But everyone consents to the fact that there is no reduction in productivity levels. I am not sure if that is really the right perspective to look at it. Here are a few reasons why internet browsing at work is helping employees.

1. Employees are not going to someone else's desk to chat or disturb them.
2. They are at their desks more time than normally expected, so they are available to other folks more time.
3. They are accessing various personal/work related resources from their own workstations.
4. They are not bugging colleagues for help. They are finding it themselves by googling or by some other means.
5. They are finding their own entertainment instead of from other people at work.

The bottom line is people no longer take up others' time. This is not abusing internet policies at work. People always waste time one way or the other and this is a better way to use time than disturbing others. So all the time they indulge in browsing is not lost rather used for relaxation, so they could work better once they come back to their regular duties. Don't you agree?

Kids and Patience

It is a combination of pleasure and pain to raise kids. But they certainly teach the virtue - 'patience'. Have you ever wondered why they give you so much trouble when doing any chore? Whether it be eating, writing or going to a movie. Every task small or big, easy or complex, with them becomes a task of patience. Every kid teaches you how to be patient in order to complete a task safely, properly and with the participation of the kid fully involved in it. If you have not seen this before, pay attention to this next time you happen to be next to a kid. Enjoy and learn from the experience!!!

A wiki introduction to telugu

A lot of people had already posted enough material on the web. So I am not trying to reinvent the wheel. This is needed on my blog as 'Telugu' is my mother tongue and if someone needs introduction, this is the fastest way to learn about it. As many language experts noted,(దేశ భాషలందు తెలుగు లెస్స!) Telugu is one of the sweetest languages and anything I say about it is less.

How to add a WSDL file to an ASP.net project:

1. open a web application project in visual studio 2003 (VS)

2. add the wsdl file to the project (physically copy the file)

3. See if the file is avaialble on the web server

4. open web references dialog in VS.

5. use url to refer to the wsdl file on the web server
eg: http://localhost/wsdl

6. once it is added and saved all the web service methods are available to the current project.

A few things a geek should live by

geek activism - http://www.scienceaddiction.com/2006/07/23/95-theses-of-geek-activism/

Oracle Ref Cursor

When building one of these to return data to the calling program, always maintain the same order and number of fields both in the declaration and body of a procedure or function or package.

Java Mail

Here is a sample that is explained in detail.

http://stardeveloper.com/articles/display.html?article=2001101101&page=1

When you use this make sure the port 25 is available on the SMTP Server. Without that, you get connectivity errors.

“I will” – home rules for our 5 year old kid

I will get up by 7 AM and brush my teeth
I will eat my breakfast, lunch or dinner within 15 minutes
I will listen to mommy and daddy
I will not ask anyone for gifts other than my parents
I will behave when we go out to parties or any other places
I will not ask for toys and snacks every time we go out
I will play with my little brother and treat him carefully
I will take a shower as soon as I come home from school
I will do my home work as soon as I come home from school
I will go to bed by 9 PM
I will drink my milk every day to grow big and strong
I will eat all vegetables and whatever mommy makes at home
I will not ask for restaurant food every day
I will play by myself quietly whenever my parents are busy
I will not talk or make sounds when my parents are talking or on the phone
I will be polite and friendly to all of family members, friends and strangers
I will use the computer when nobody is using it
I will not write on walls, carpet or any other place except on paper
I will not spill juice or milk every where
I will sit at the dining table every time I drink or eat
I will not watch television more than 2 hours a day
I will learn new things every day
I will tell my parents about all I learnt in school every day
I will finish all my food at school



Feel free to improvise this list.

Plato's Psychic prison

Guys and gals,

If you have a minute in your life, read about this concept. I came across this in a text book for a course called -"Organizational Management". I provided the details of the book below, but I am sure you can get related information on the web. It reveals all the maladies of an organization and root causes. It is very powerful. It just opens your eyes to all the realities of work life. Good luck!!

Title: Images of Organizations, (1997) Executive Edition

Author: Gareth Morgan,
Publisher: Sage Publications

web 2.0 sites (more) - 1

As you can see, I am fascinated with these sites (this is my flavor of month).
Here is another one referred on digg.

http://web2.0awards.org/

VBScript Runtime Error '800a0046' Permission denied

I have an intranet application built using ASP 3.0 and IIS 5.0. All it does is serve some PDF documents from oracle database to IE users on demand. A couple of users add these forms to the site (sort of application administrators) and when I tried to test that functionality, I was getting the above error message and went through some research (by the way the upload process uses FileSystemObject in ASP). KB articles 197619 and some more discussed about the problem, but the solutions did not really work for me.

So I added the so called admin users to administrator group locally to the physical folder of the application files on IIS box and asked them to try the site. Ola! It started working. Of course, I still get the error if try using any other accounts other than the ones I already gave full control. Though temporarily, I am off the hook, I want to solve this the right way. What was wrong here?

web 2.0 sites

Found this on digg.com. Quite useful if you are bulilding a site youself.

http://www.openbc.com/cgi-bin/forum.fpl?op=showarticles&id=1307054

I checked this site and this page is no longer available.

Web developer's hand book

Found this on http://www.blinklist.com. Really vast list of resources and links.

http://www.alvit.de/handbook/

boothu kathalu

boothu kathalu vrayatam sulabham, kaani vati meeda pathanaaskthini yenta kaalam chaduvarulalo nilapagalam anede prasna.

Technology and Life

I have been reading some stuff as usual and found this on http://www.squidoo.com
It is educating and entertaining simultaneously and I found it very interesting.
Check it out. http://blog.lifebeyondcode.com/