'durvasudu' is the name of an angry sage (in a South Indian language called Telugu) from the great Indian epic 'Mahabharata'. So you have the reason for the title and the stories are my rants about everything I come across.
Friday, October 26, 2012
Thursday, April 05, 2012
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
'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
Subscribe to:
Comments (Atom)