Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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