Results 1 to 3 of 3

Thread: Plsql

  1. #1
    Join Date
    Jul 2003
    Posts
    12

    Thumbs up Unanswered: Plsql

    I want to get numbers from a string,
    for example:
    my_str=1234567abcdef
    then all I want to get is: 1234567
    So plz give me a function in PLSQL.
    Much thankssssssssss,

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Look up the translate() function in the SQL manual as this can remove characters u dont need i.e. all the non numerics.

    Alan

  3. #3
    Join Date
    Jul 2003
    Posts
    12
    Sorry for not enough information. I mean that, I have a tableTAB, a varchar2 field, its name: DESCRIPTION , data in this field is stored as following: [some_space][some_numbers][some_spaces][some_characters]
    And other column MONEY (number(10))
    I wrote a function NOSPACE that delete all space in the data that I get from DESCRIPTION field. It’s ok.
    Now I want to write an after insert or update trigger that insert just the [some_numbers] into another field in the same table.
    For example: the data in DESCRIPT column is ‘ 200.000 good well better’
    So all that I want my trigger to get 200.000 to insert into MONEY column after inserting or updating on my table TAB. (I use Ora9i R2)
    Please help me this problem, thanks very much

Posting Permissions

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