songs that remind you…..most

My love failure playlist

—————————-

unnarugil varugayil….          Film : Kalloori

yaaro manathile….                Film : Dhaam dhoom

Po nee po …                            Film :3

kannalaga …                           Film :3

New york nagaram …           Film :Jillunnu oru kadal

pirai thedum …..                    Film :Mayakkam enna

venmathi venmathiye….      Film :Minnale

ovvoru padalilum _ Sad …  Film :Ennavale

Mandram vantha ……           Film :Mouna raagam

anbe anbe en anbe…             Film :Nenjinile

Nee kosam …                          Film:Desamuduru

Neeya pesiyathu…                 Film:Thirumalai

vazhve maayam …                 Film:vazhve maayam

YedhedhoEnnangal…           Film:Pattiyal

nee illai nillal illai…              Film:Poochoodava

Ninaivugal nenjinil…           Film:Authograph

unakkena iruppen…            Film:Kadhal

Nammaka_Thappani….     Film:Bommarillu

Tuhi Meri Shab..                 Film:Gangster

OSaathiRe…                         Film:Omkara

unna nenaichen…               Film:Aboorava sagotharargal

Vidigindra Pozhudhu…     Film:Raam

Sundari Kannal…               Film:dhalapathi

…..list goes on….

 

Advertisements

Transform from vertical rows to horizontal columns in oracle sql

Syntax:

————

select
Primary column,
max((case vertical_column_name when  ‘val1’
THEN  ‘display value’
else  null
end )) col1,

max((case vertical_column_name when  ‘val2’
THEN  ‘display value’
else  null
end )) col2,

max((case vertical_column_name when  ‘val3’
THEN  ‘display value’
else  null
end )) col3
from

table1 t1

where  conditions
group by primary_column;

Example:

—————

SELECT

st.roll_no,

max((case Phone_number_type when  ‘1’
THEN  Phone_number
else  null
end )) Land_Line_Number,

max((case Phone_number_type when  ‘2’
THEN  Phone_number
else  null
end )) Hand_Phone_Number

FROM

STUDENTS st

WHERE

st.rollno between 100 and 200

GROUP BY st.rollno;

 

 

 

 

Categories: SQL, Technical

add indent or tab to the beginning of the line in VI editor

open the vi editor

press Esc, :> — for one indentation

press Esc, :5> — for one indentation at line 5

press Esc, :5,10 > — for one indentation from line 5 to 10

Categories: Technical, VI editor

set Print area for excel using xml /Print certain columns in excel

Use the following XML tags to print only certain area in Excel (Note: excel should have only one table otherwise it wont work)

<x:ExcelName>

<x:Name>Print_Area</x:Name>

<x:SheetIndex>1</x:SheetIndex>

<x:Formula>=Sheet1!$A:$C</x:Formula>

</x:ExcelName>

Categories: Technical

Grep Before and after lines in unix

Syntax: Before lines (3- is the number of lines before your search text here)

grep -B3 “Your search text” your file name

Syntax: After Lines (3- is the number of lines after your search text here)

grep -A3 “Your search text” your file name

 

Categories: Technical, unix commands

How to remove cap in the barcode generated in unix from postscript

printf(“0 setlinecap\n”);

Print the above line to the output postscript file before generating the barcode….

 

 

Table not listed under connections in SQLDeveloper

When I created a connection with an existing user name, i was able to connect to the sql server but in the Tables tree i cannot see any tables list.

Solution: Use another user who has access to the table list(i.e. user sa)the user which i tried previously is not having access to the table listing, thats why the table tree was empty

Categories: PL/SQL, SQL