Search Results

Hi Thanks,

But after cutting will 23 be stored as a char or number in a var another_var..

because i am passing that var to a plsql procedure and there i am assigning it to a number..?

Hi,

I have a var sdt='23032011000000'

now if i want only 23 out of above? hw to cut?

also..after cuttint-will it be stored in another var as a varchar or as a number?

Hi,
How to get count of number of sundays in month in unix shell script ..


ideally i need 2 get last sunday of month
so i used cmd:

for eg: for june:

cal 06 2011 | tail -2 | head -1...

hi..thanx fr reply..But i need that after i find duplicate,i shud remove d oldest l_date entries for d record and then only latest l_date entry for record shud b present..dont need shell script...

can any1 explain me hw is below wrking:
wat is substr and dd,mmyear used for
wat values will go in dese?

sdt='31122010235959'

sdate=`validate_date $sdt`

validate_date()
{
dt="$1"
...

Hi.
I have 2 create 2 temporary tables.the data will be same with same cols..but after creating 2 tables..i have to merge data in file and send..however the query is after merging data no duplicates...