Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    69

    Unanswered: TEXTPTR conversion

    I have a query in SQL Server as

    SELECT @textpt = TEXTPTR(corres)
    FROM almod UPDATETEXT almod.corres @textpt null 1 'b'

    is there an equivalent for this in Oracle ?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    And I have a function in my DB called QXZ_1F18. Is there an equivalent for this in SQL Server?

    What does TEXTPTR do?

  3. #3
    Join Date
    Apr 2004
    Posts
    69
    I am not sure if you are serious about answering my question.

    anyways,
    TEXTPTR returns a pointer to a table column whose datatype is "text" in SQL Server. the UPDATETEXT clause is used to update the field with a value.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I was just joking

    I've never heard of TEXTPTR function before. Now that you've explained it, I must admit that I wouldn't know. I'm quite sure that (as of Oracle 7) such a function doesn't exist. However, I'm not familiar with all the new stuff in Oracle 9 (and even 10) so there *might* be something you need, but that I don't know.

    Sorry ... I'm useless.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •