Recent content by lasd

Hi I have a bit of a problem. Below I have pasted the row_number function i am using in my code. However i want to select where RowNumber=1 in my where clause but it doesn't recognise it. could anyone help here. ROW_NUMBER() OVER (PARTITION BY item_key ORDER BY execution_time desc)as...

Hi Another question. I have a value in my table employees for eg. sender=15...... so this value is referenced by employees.sender...... for another column in my sql i want to add in 00 before the 15. How do i do this. i want the last column to have for eg 0015 0031 0051 instead of 15 31...

Hi Just wanted some help concerning flexfields.. how do i declare and call flexfields within my SQL code. whatever help you have would be very grateful kindest regards Lasd

PS... the error it is bringing up is because the poll.quantity_received field is of a different number format i think

Hi, I am currently trying to multiply out two numbers but i am getting some error. There is probably a simple solution to this but my head isn't working properly at all today i'm afraid. I would really appreciate someones help. select poll.quantity_received *to_char(nvl(poh.rate,1)...

Thanks so much. this works perfectly. many thanks Lasd

Hi Thanks for that, that is working but one question. select replace(profile.abstract,CHR(10),'')||' '|| TRIM(components.path) Above is the code I am using to replace chr(10)with a space. This is working fine but i also want to get rid of the chr(13) from this string profile.abstract. I...

Thanks for that reply... i was trying to use the replace function yesterday but i am not sure how to represent the character return in the replace function. for eg replace(profile.abstract,',','') this will replace the comma's within the address but how do i ask it to look for the character...

Hi I am having a problem with character returns in SQL. I am extracting data from a database and one of the address colunns that i am extracting the data from contains character returns within the text. this is throwing my results out of sync and I cannot see the end of some of the address...

yep this is correct. What i want to do is extract the value of components.path(this is a file name with a file extension)from the docsadm.component table, and change the name of components.path to 100000.tif, 100001.tif, 100002.tif etc........ my copy file statement that is being run under a...

Hi I really hope someone can help. I am copying over files. I want to change the name of the file being copied over. I want the first one to start at 100,000 and increment from there. for eg. copy 1232.tif(source file) as 100000.tif and the second one to be 100001.tif and so on. here is the...

was wondering if it is possible to do the following. i am still copying the files but instead of naming them with the creation_date and component.path name i was wondering could i number them, say from 100000.tif up to the last file, which could be 120000.tif. for eg. copy file...

thanks for that reply it worked perfectly. i am very grateful. i was wondering if it is possible to do the following. i am still copying the files but instead of naming them with the creation_date and component.path name i was wondering could i number them, say from 100000.tif up to the last...

sorry made a mistake showing the first copy statemen. it would be like this. copy file || 1235@2.tif over to 1235@2.tif

Hi I hope someone can help again. I am attaching the piece of code i am using to copy files from the components.path field over to another file in a different location. I am using a .bat file to copy over the documents. But where i am stuck is that i want to add in the creation date to be part...