A man's skills

A friend of mine had this posted in his cubicle. I have been thinking about this on and off and finally adding it to my blog.

 

"A human being should be able to change a diaper, plan an invasion, butcher a hog, conn a ship, design a building, write a sonnet, balance accounts, build a wall, set a bone, comfort the dying, take orders, give orders, cooperate, act alone, solve equations, analyze a new problem, pitch manure, program a computer, cook a tasty meal, fight efficiently, die gallantly.”

 

 Robert Heinlein (original is obtained from this site)

oracle sql - use of case syntax - example

select pm_policy_no_0,
'LOOP' as pm_lob,last_name,
first_name,
(CASE
WHEN LENGTH( INCEPTION_DATE ) = 3 THEN
'20000' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 4 THEN
'2000' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 5 THEN
'200' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 6 THEN
'19' || trim( INCEPTION_DATE )
WHEN LENGTH( INCEPTION_DATE ) = 8 THEN
trim( INCEPTION_DATE )
ELSE
trim( INCEPTION_DATE )
END) AS INCEPTION_DATE,
from tblPol

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