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

    SQL*PLUS - no rows returned on one laptop, 67k+ rows returned on anoth

    Hi, I'm having an issue where a user has been using SQL*PLUS to query a SID on an Oracle Database Server 11g Release 1. They have a read-only SQL account to run the query, which returns 67,000+ rows when they run it on their old laptop, but 0 rows when they run it on their current laptop...
  2. OMJ

    Command Prompt query (Extracting Day Number, Month Number etc)

    Hi, I've got a command prompt batch script which extracts the day of week, day number, month number, year, hour and seconds. Unfortunately, whilst it does work, it gets the day number and month number confused when ran with US regional settings - and it needs to work in both UK and US settings...
  3. OMJ

    Moving folders/directories using a *.bat batch script file...

    I'm unsure if this is the right forum so please let me know where to post this if this is the wrong place. My problem is this: I have about 2500+ folders located in a directory "C:\Projects", in a folder structure of "C:\Projects\0", "C:\Projects\100", "C:\Projects\200" and so on up to...
  4. OMJ

    Importing external data into Excel using VBA

    Hi, I have successfully managed to connect to a database on a server, and NOT using the wizard I executed the below query in Microsoft Query then return the data to Excel. select * from projects where team = 'TEAM1' and startdate > to_date( '01-apr-2007 00:00:00', 'dd-mon-yyyy hh24:mi:ss' )...

Part and Inventory Search

Back
Top