Search results for query: *

I need to convert rows of data into table of columns for example id key val 1 A 11 1 B 12 2 A 22 2 B 33 i want ID A B 1 11 22 2 22 33 Can any one help me out please Thanks pavithra

hi Is it possible to remove coma from the select clause in a procedure For example lets say i Select a, b, c from table1, table2...etc where value of a is "Proctoer, Gamble" I need to remove the coma and replace it with space is it possible in a procedure , is there any built in fucntion i...

hi Is it possible to remove coma from the select clause in a procedure For example lets say i Select a, b, c from table1, table2...etc where value of a is "Proctoer, Gamble" I need to remove the coma and replace it with space is it possible in a procedure , is there any built in fucntion i...

i have more condition after that statement Can you please provide me with more hlp Thanks pavithra

Hi I have to create a procedure based on the input parameter i have to append the conditon in where clause for ex: Select * from table1 where if(status =live) status not in ... else status in ... Can some one please help me out on this pavithra

thanks a lot people, its really a great help from all of you pavithra

i need a script whihc loops thru all the files in a folder and checks out its timestamp and compare it with current date of the system and delete those files which are 2 weeks old or more

hi How can i delete a file from the directory which is 2 weeks old from the current date using the shell script and this script will be assigned to the crontab so date calculation should be dynamically done. Please help me out. thanks pavithra