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: Livia8
  • Content: Threads
  • Order by date
  1. Livia8

    Alternative to "locate" command

    Hi, I'm trying to find out in which directory a tmp file created today is. I usually use the "locate" command followed by the file name (with asterisks, if needs be), but that only works on files older than today. Could someone please suggest an alternative that would work for new items? I've...
  2. Livia8

    How to forcibly logout users

    Another day, another question! While the month-end processes are being carried out, we normally ask users to refrain from logging into Oracle. We then monitor who accesses it by runnning this query: select last_connect, usr.user_name, resp.responsibility_key, function_type, icx.* from...
  3. Livia8

    SQL SELECT - where date is null or greater than

    Hi again, I'm back with another basic question I'm afraid... (This forum is great for training, I must say!) I'm trying to select a list of user names, with start date, end date, last user date, etc. The problems start when I try to add a filter by date - I'm trying to get a list of all...
  4. Livia8

    Question re: SELECT DISTINCT

    Hi, I know very little about sql and Toad, so this will most likely sound like another stupid question. I'm trying to run the following query: SELECT * FROM FA_CATEGORIES_VL, FA_CATEGORY_BOOKS WHERE ENABLED_FLAG <> 'N' My problem is that the FA_CATEGORIES_VL table has one column called...
  5. Livia8

    Can deleted files/ directories (rm -r) be retrieved again?

    Hi, While I was making some room by deleting old archivelogs through asmcmd, I accidentally managed to delete the whole archivelogs directory and its contents. I'm not even sure how I did it, but I presume it was by adding an extra space after the rm -r command and the first slash (e.g. rm...
  6. Livia8

    SQL script to find number of characters allowed in &quot;Description&quot; column of &quot;AP_INVOIC

    Could someone kindly let me know how to find how many characters are allowed in a specific field? Is there a sql entry I can use or can this be done some other way? Some "Local Event Errors" have appeared in the Workflow, the description reads "Invoice Descr. field may be too long", although...
  7. Livia8

    Generate report/output on the basis of &quot;enquiry&quot; responsibilities only

    Hi all, I've asked this https://www.tek-tips.com/viewthread.cfm?qid=1810077 in the Microsoft Office forum, but since it's data extracted from Oracle I was wondering whether it was possible to obtain what I'm looking for with sql (the thinking behind it being that it might be easier to...
  8. Livia8

    Excel - extract/flag data (Pivot table? Data Filter? Formula?)

    Hi there, I know that there's probably a straight forward way of doing this, but I can't get my head around it. I've a list of usernames with the list of responsibilities associated to their profile, e.g. ALL RESPONSIBILITIES GREEN APPLES ADMIN GREEN APPLES CASH ENTRY GREEN APPLES CASH...
  9. Livia8

    How to list all the CPU (EBS) patches applied - Oracle 11.2.0.4.

    Hi, I've been asked to identify all the cpu (ebs) patches applied to our database. opatch lsinventory doesn't list them, I've also tried using select * from sys.registry$history but that didn't work either,. Two more attempts were SELECT * FROM ad_bugs; and SELECT * FROM...
  10. Livia8

    Excel - Pivot table or Formula?

    Hi there, I need to count the number of items that are below certain amounts, divided by the type of item. For instance, I need to count how many coffees I've sold <=€5, how many between €5.01 and €10, how many between €10.01 and €15, and so forth. In column A I've the type of item (e.g. tea...
  11. Livia8

    Adobe Acrobat 9 - Attacht to Email not working

    Hi there, I don't know if it's an Outlook or and Adobe problem, so I've posted this in the Adobe Acrobat forum too. I'm currently using Acrobat 9 on Windows XP. If I have an open pdf file and I go to File - Attach to email, the system seems to be doing all the right things and opening a new...
  12. Livia8

    Adobe Acrobat 9 - Attacht to Email not working

    Hi there, I don't know if it's an Outlook or and Adobe problem - I'm currently using Acrobat 9 on Windows XP. If I have an open pdf file and I go to File - Attach to email, the system seems to be doing all the right things and opening a new message with the attachment already included, but when...
  13. Livia8

    Outlook - Search by attachment type

    Hi there, Is there a way of searching for messages in Outlook 2003 on the basis of an attachment type (e.g. *.xls)? I know the system allows me to search for messages with one or more attachments, but I can't find a way to further restrict the search. Many thanks. (I've posted this on the...
  14. Livia8

    Outlook - Search by attachment type

    Hi there, Is there a way of searching for messages in Outlook 2003 on the basis of an attachment type (e.g. *.xls)? I know the system allows me to search for messages with one or more attachments, but I can't find a way to further restrict the search. Many thanks.
  15. Livia8

    MailMerge - Word 2003 vs Word 2000

    Hi there, I'm trying to use mailmerge (in Word 2003) to fill in a Word template with data held in Excel, but the whole process seems to be a lot more complicated and more time-consuming than it was in in Word 2000 - for instance, the system seems to need me to "match" the fields before allowing...
  16. Livia8

    Days, Moths and Years in Excel

    Hi tehre, I'm trying to find a function that would turn a figure (let's say 33.562) into 33 Years, nn Months and nn days. I'm sure it's probably something straight forward, but I can't see it. Thanks. Livia
  17. Livia8

    Visio - Converting Charts to JPG

    Hi there, I'm trying to savea Visio chart as a jpg file - so far, so good. However, when I open the jpg file or use it as background in Powerpoint, there are no margins and the drawing is stretched to the edges of the page. The Visio chart itself has some space around the drawing. I've tried...
  18. Livia8

    &quot;An error (6) occurred during action Save As. Number Overflow&quot;

    Hi there, I've a number of organisation charts that have all been created in the same way. I've had no problem in saving almost all of them into JPG format, except for one, which returns the following error message: "An error (6) occurred during action Save As. Number Overflow". As far as I'm...
  19. Livia8

    Excel - Insert Worksheet Shows all xl files

    Hi there, When I'm in a worksheet, if I right click on its tab and click on Insert, the system gets very slow, and when the "Insert" box appears it has lots of tabs, pretty much one for each of the subfolders of the shared drive. Each tab shows every excel file each subfolder contains. Why is...
  20. Livia8

    Excel - Calculate Return Date - Working Days only

    Hi there, I'm trying to set up a spreadsheet to calculate employee return dates: On cell A1 I've the start date of the absence; on Cell B1 I've the number of weeks; on cell C1 I've the number of days per week; on cell D1 I've the total (C1*D1); on cell E1 I've the return date (D1+A1), but...

Part and Inventory Search

Back
Top