User Profile

Collapse

Profile Sidebar

Collapse
student_help
student_help
Last Activity: Apr 10 '12, 08:37 AM
Joined: Aug 7 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • student_help
    replied to regular expressions in oracle
    in Oracle
    Thank you for your reply. You were correct the version were slight different. It is working now as expected.
    See more | Go to post

      Leave a comment:

    • student_help
      started a topic regular expressions in oracle
      in Oracle

      regular expressions in oracle

      Is there a setting which must be set in an Oracle database (11g) for the database to run regular expressions?

      I have a stored procedure which has a regular expression in it. This stored procedure is in 2 database (development database and a UAT database), it is working on one and it isnt working on the other one. This is impacting my work as I have to fix something which is got from the result of running the regular expression....
      See more | Go to post
      Last edited by student_help; Feb 10 '12, 07:23 PM. Reason: adding more info
      • student_help
        replied to Highest value from a column
        in Oracle
        It turned out the query was returning me the correct result - it was a join which was being used at a later stage in the query which was causing the issue.

        Apologies for wasting your time - this is the joy of working with code that has no comments or documentation anywhere in it.

        Thank you very much for your replies and help
        See more | Go to post

          Leave a comment:

        • student_help
          started a topic Highest value from a column
          in Oracle

          Highest value from a column

          Hi

          I need assistance. I have a column which can have random length but I need to find the highest value in this column. e.g. the Column could contain ABC1234 and ABC125 and I need to find the MAX value in this column which in this case would be ABC1234. I have tried the MAX(column_tabl e) but it was returning ABC125 as the highest value (I am guessing it was adding a zero to the end).

          Would someone be able to point...
          See more | Go to post
          • student_help
            started a topic objreader problem
            in .NET

            objreader problem

            HI

            I am trying to read from a number of different files using objReader. the problem i am having is that there is no set name file to work from. I was wondering if there was some other way to declare the file name. The thing with the files are when i am finished with them they are deleted so there is no set name. This declaration is no good for me
            Dim objReader As New System.IO.Strea mReader(FILE_NA ME)

            as...
            See more | Go to post
            No activity results to display
            Show More
            Working...