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 Chriss Miller 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: *

  1. mikedaruke

    Unable to SCSI unload drive

    Hi, I am getting alot of errors in the messages log, Unable to SCSI unload drive. Drives are constantly going down. They are ndmp drives that are controlled by nas devices. I am not sure what the problem is or where to look Thanks Mike
  2. mikedaruke

    Searing from Left to Right?

    Doesn't work, it still goes from the first _ rather then the last one.
  3. mikedaruke

    Searing from Left to Right?

    I have a string $string = 'I_Love_Perl_So_Much'; I want to capture the 'Much' word, or the last match for _.*?$ I am currently doing $string =~ m/_(.*?)/; but it finds _Love_Perl_So_Much How can I get perl to search from the Left to the Right instead of Right to Left? Thanks
  4. mikedaruke

    triggers on views

    Dagon, I am not set on triggers or think its right! Thats what I am asking for advice. Hmm a Pl SQL script, I didnt think of that. That sounds like a good idea. The views just relie on each other and I have them set to refresh once a day. So I never did any PL SQL script, can you give me a...
  5. mikedaruke

    triggers on views

    Hello, I am not sure if this is the correct way to do this or not, I am trying to have my views update one after another. With the basis being one view relies on another. Currently I have them setup to update at a certain time, but if one of the views take longer then expected things get...
  6. mikedaruke

    error 800

    I did all that already, and tried all the troublshooting and nothing worked.
  7. mikedaruke

    error 800

    Receiving error 800 when trying to backup to disk. I am just backing up a directory on a media server to another directory on the same media server. any ideas?
  8. mikedaruke

    Local or SAN attached storage

    If I log onto a Solaris box, how do I tell the difference between local or san attached storage? I would like to know which filesystems are local and which are SAN. This way I can move some important directories to SAN. Thanks
  9. mikedaruke

    stored procedure to update materialized view

    Can someone write me a stored procedure that updates a materialized view? Reason is I am trying to use perl to update the view, via cron, and it gives me errors, so I am thinking maybe just running a stored procedure to update it. Any ideas?
  10. mikedaruke

    Updating Materialized Views via Perl

    Anyone know how I can have perl update materialized views in Oracle? I know the command do it via SQL* Plus, but not sure how to do it via the DBI module. I am currently connected and can run SQL against the DB and get results. Any ideas? Want to execute. execute...
  11. mikedaruke

    Multiple Update statements

    How can I run multiple update statments at once? I have 9k to run. I tried Update ... ; Update ... ; But it just freezes
  12. mikedaruke

    Query help

    no that would get me the min and max. I need the next day, based off the last date.
  13. mikedaruke

    Query help

    sorry wrong query, here it is, it works if i put a client name in, well some of them, some take to long to come back. I need it to be faster or it will never work with temp1 as( select * from table1 where client_name = 'Bob' ) select * from temp1 a, temp1 b where b.s_date = (select max(s_date)...
  14. mikedaruke

    Query help

    select client_name, store_name, product_date, s_date , b.s_date "return_date" from table1 a, table1 b where b.s_date = (select min(start_date) return_date from table1 where start_date > a.start_date)
  15. mikedaruke

    Query help

    I need some help taking a table with the following Client_name, Store_name, product, date Bob, Joes Cars, Oil, 3/01/08 Bob, Joes Cars, Oil, 4/07/08 Bob, Joes Cars, Oil, 5/08/08 Bob, Joes Cars, Oil, 5/25/08 Bob, Joes Cars, Oil, 6/10/08 Chris,Joes Cars, Oil, 3/10/08 Chris,Joes Cars, Oil, 3/28/08...
  16. mikedaruke

    update materalized view

    Can I update the materalized view from an SQL worksheet? I try execute DBMS_REFRESH.REFRESH('TEST'); But get ora-000900 error. How can I do it threw the SQL worksheet?
  17. mikedaruke

    perl newbie trying to get just one word

    $invoice =~ s/Inv no\.//gsi;
  18. mikedaruke

    Connecting to Sybase

    All, What can I use to connect to a Sybase server? I can't seem to find a module. I am using DBI for Oracle, and that works great. But for Sybase I have so many problems. Any idea on what I need to install? Thanks
  19. mikedaruke

    help with query

    Hi, I have dates like this 11-APR-08 10-APR-08 09-APR-08 08-APR-08 07-APR-08 04-APR-08 03-APR-08 I want to be able to find out how many days are between, but I cannot count Sat and Sun. So 4/7/08 - 4/4/08 = 0 So somehow I need to compare the first date to the date under it, then if a...
  20. mikedaruke

    temp table or something

    If I have 10 values I want to put in a temporary table, or somewhere where I can do an outer join real quick to see if they match, if they don't i want null. So I have 10 values like Peter Bob Christine Mike Jack etc Just want something like Name Peter Bob chistine etc This way I can out...

Part and Inventory Search

Back
Top