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

  • Users: djbjr
  • Order by date
  1. djbjr

    update column

    Wouldnt that be starcasm?
  2. djbjr

    Create View and Set Datatypes

    I imagine the following will work CREATE OR REPLACE FORCE VIEW "SYS"."NICHECOM_SITES3_VW" AS select to_number(substr(to_char("site_id"), 1, 15)) "site_id", substr("site_name", 1, 55) "site_name", substr("status", 1, 15) "status" from sites@nichecom2; EXAMPLE SQL> create table sites...
  3. djbjr

    Strange SQL Loader problem

    Post your Control file and a sample from the "bad" file
  4. djbjr

    Top row by group

    and yes I know I should have said an in-line view
  5. djbjr

    Top row by group

    Thanks Dave, I was answering with my Monday brain. It is a in-line view.
  6. djbjr

    Top row by group

    I believe that is simply called a sub-query.
  7. djbjr

    Top row by group

    Try the following SELECT c.* FROM csq_mc c, (SELECT mc_location, MAX(mc_date) max_date FROM csq_mc GROUP BY mc_location) m WHERE c.mc_location = m.mc_location AND c.mc_date = m.max_date; RESULTS: SQL> create table csq_mc 2 (mc_date date, 3 mc_location varchar2(10)...
  8. djbjr

    When was the last CD Burned?

    Thanks bcaster but I dont think that will help in our situation. What happened was he sat at his desk and a window popped up that certain files were ready to be burned, they were all confidential data files. I was trying to help him out to figure out if the person that was let go actually...
  9. djbjr

    When was the last CD Burned?

    I am the resident computer geek amoung my friends but I was stumped today and was wondering if any of you guys might know. My friend wants to know when the last CD was burned on his computer. He had to fire someone recently and he is afraid that person may have took his data and made a copy...
  10. djbjr

    Next sequence number jumps sometimes

    Post the script for your trigger and perhaps we can help
  11. djbjr

    Perl job failing on UNLESS command

    Paul- Thanks for the help, I have figured it out. The problem was that the file was not being created because the sql*loader command that I was running earlier in the script was not executing. Thanks a ton and I will post again if I need more help dj
  12. djbjr

    Perl job failing on UNLESS command

    Paul- Thanks for the hint but that isnt going to work. The .data file is the flat file that I am going to use to load into Oracle. I changed it to look like .log instead of .data.log and it is still giving me the same error.
  13. djbjr

    Perl job failing on UNLESS command

    Thanks for your replys, the problem was that I had an incomplete parameter file so the full path of the file was not being searched for. Now I have a new problem. I am getting an error that it cant open the log file. hr_load 08/24/106 08:58:47 ps_disability STARTED hr_load 08/24/106 08:58:47...
  14. djbjr

    Perl job failing on UNLESS command

    I hear what your two are saying but my thoughts that the file name was wraping to the next line. If you look at my error log, it continues with the filename....or maybe you are right and this is an additional message. Thanks for your help In the meantime I will try the -e approach.
  15. djbjr

    Perl job failing on UNLESS command

    ...line but I really dont know what I am doing. I am an Oracle developer that has inherited a 9 year old Perl script that moves files and kicks off Sql*Loader scripts. We are moving off of Unix and on to Linux and this script is acting crazy now. I wonder if any of you guys can help me out. My...
    • djbjr
    • Thread
    • Replies: 10
    • Forum: Perl
  16. djbjr

    Query running problem

    If you look at the schema browser in toad at each table you can see the last time it was analyzed on the Stats/Size pane on the right side. You can also analyze the tables by clicking on the calculator icon while highlighting the table name in the schema browser.
  17. djbjr

    Regathering Stats on Tables that have not changed

    OK So I need a point in the right direction. Every month I load several snapshot tables based on end of month data. They are all stored in partitioned tables. At the beginning of each month I have several users running thousands of reports from Business Objects using these tables (amoung...
  18. djbjr

    analytic function instead of correlated subquery

    Thanks Dagon for that Valueble Post.
  19. djbjr

    Dealing with my ADDICTION to Tek-Tips...

    Great....now I am going to have to pretend I know what I am doing at work. You are very selfish Dave. Congrats on the wedding. It is a wonderful occasion to celebrate. ~Cheers dj
  20. djbjr

    Can this be done using SQL Loader?

    Also are you using UNIX? Is it possible to use Shell to solve your problem? How many rows total are you trying to insert?

Part and Inventory Search

Back
Top