Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lasd
  • Order by date
  1. lasd

    row_number function

    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...
  2. lasd

    Strings

    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...
  3. lasd

    Using Flexfields

    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
  4. lasd

    Multiplying fields in SQL

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

    Multiplying fields in SQL

    ...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) * pol.unit_price, '999,999,990.99') Difference from apps.po_line_locations_all poll...
  6. lasd

    Ignoring Character Returns

    Thanks so much. this works perfectly. many thanks Lasd
  7. lasd

    Ignoring Character Returns

    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...
  8. lasd

    Ignoring Character Returns

    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...
  9. lasd

    Ignoring Character Returns

    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...
  10. lasd

    using variable x as filename and incrementing value

    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...
  11. lasd

    using variable x as filename and incrementing value

    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...
  12. lasd

    Copy files- rename using a count loop

    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...
  13. lasd

    copying files to different location, a naming problem.

    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...
  14. lasd

    copying files to different location, a naming problem.

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

    copying files to different location, a naming problem.

    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...
  16. lasd

    replacing a character in SQL

    Hi I was hoping someone could help me. I have written some SQL code to extract data from some tables. The data has been extracted but then i want to copy this data to a different file. The problem is that one of the fields(path field) contains some characters that i do not want. for eg...
  17. lasd

    Removing a character from file name

    Hi I was hoping someone could help me. I have written some SQL code to extract data from some tables. The data has been extracted but then i want to copy this data to a different file. The problem is that one of the fields(path field) contains some characters that i do not want. for eg...
  18. lasd

    Select Statement Problem

    hi i will just give you an example of what is coming up. I am linking this to the other tables for PO's using the po_line_id... i am getting the po number and the invoice number belonging to this PO number.then i want to show the receipt number and the receipt qty. but here is whats happening...
  19. lasd

    Select Statement Problem

    and rsl.SHIPMENT_HEADER_ID=rsh.SHIPMENT_HEADER_ID(+) sorry i just cut out some of the code as i was pasting it in to the thread. this is the line in which i join rcv_shipment_headers....
  20. lasd

    Select Statement Problem

    Hi I am trying to get the receipt num and the quantity_received value to appear once and not to multiply all the way down when it is connected to the other table. Is my order by statement correct or should i be doing something else? thanks very much in advance for the help kindest regards lasd...

Part and Inventory Search

Back
Top