Results 1 to 3 of 3

Thread: Plsql

  1. #1
    Join Date
    Jul 2003

    Thumbs up Unanswered: Plsql

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

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


  3. #3
    Join Date
    Jul 2003
    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