Wednesday, June 10, 2015

passing multiple values for a single parameter in oracle apps Reports

passing multiple values for a single parameter in oracle apps Reports:

Here Comma delimited Multiple values parameter considering as a single sting .

Example : If passing parameter value as 'ABC,ABCD' This entire sting consider as a single string but i want to use this as a comma delimited like in ('ABC','ABCD')

By using below Example it could be Rectified.


 SELECT * FROM XX_TABLE WHERE XX_COLUMN in (SELECT REGEXP_SUBSTR (value,'[^, ]+',1,LEVEL) value
        FROM (SELECT 'ABC,ABCD' value FROM dual)
                  connect BY REGEXP_SUBSTR (value,'[^, ]+',1,LEVEL) IS NOT NULL) --ABC,ABCD

28 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Cloud Computing Training In Noida
    Webtrackker is IT based company in many countries. Webtrackker will provide you a real time projects based training on Cloud Computing. If you are looking for the Cloud computing training in Noida then you can join the webtrackker technology.
    Cloud Computing Training In Noida , Cloud Computing Training center In Noida , Cloud Computing Training institute In Noida ,

    Company Address:
    Webtrackker Technology
    C- 67, Sector- 63, Noida
    Email: info@webtrackker.com
    Website: www.webtrackker.com
    http://webtrackker.com/Cloud-Computing-Training-Institutes-In-Noida.php

    ReplyDelete
  3. Great Article, Thank you for sharing this useful information!!

    CEH Training In Hyderbad


    ReplyDelete
  4. Online BBA degree in India is one of the most popular couses for students who are keen to learn business statistics, communicating skills, marketing management, entrepreneurship and small business management, international business, etc. To know more, visit:
    Online BBA Degree in India,

    ReplyDelete
  5. outsource company
    Really cool post, highly informative and professionally written and I am glad to be a visitor of this perfect blog, thank you for this rare info!

    ReplyDelete
  6. Do this hack to drop 2lb of fat in 8 hours

    At least 160 thousand men and women are using a simple and secret "liquids hack" to drop 1-2 lbs every night while they sleep.

    It's very simple and it works on anybody.

    Here's how you can do it yourself:

    1) Grab a clear glass and fill it up with water half full

    2) Now learn this amazing HACK

    and become 1-2 lbs lighter as soon as tomorrow!

    ReplyDelete
  7. According to Stanford Medical, It is in fact the one and ONLY reason women in this country live 10 years longer and weigh on average 19 KG less than we do.

    (And actually, it really has NOTHING to do with genetics or some secret-exercise and really, EVERYTHING about "how" they are eating.)

    P.S, What I said is "HOW", and not "what"...

    CLICK this link to uncover if this brief test can help you discover your real weight loss potential

    ReplyDelete
  8. Do this hack to drop 2lb of fat in 8 hours

    More than 160k women and men are using a easy and SECRET "water hack" to burn 1-2lbs every night in their sleep.

    It is effective and works with anybody.

    Here's how you can do it yourself:

    1) Get a clear glass and fill it up half the way

    2) Proceed to use this weight loss HACK

    so you'll become 1-2lbs skinnier the very next day!

    ReplyDelete


  9. Litewingstravels
    Within a short span of its existence LITEWINGS Travels, has emerged as a name to reckon with in the business of Inbound/outbound Tourism. We have adapted our operations to the fast-paced cyber world and bring you India, online. Now you have access to a wealth of information at your desktop just a click away

    ReplyDelete


  10. Mortgage Broker in Toronto
    We work with Canada's premium financial institutions to offer you the best mortgages in the market and the lowest interest rates. Names such as Royal Bank, Scotia Bank, Bank of Montreal, TD Canada Trust, CIBC, National Bank, and more, guarantee the best service and highest savings for you.

    ReplyDelete
  11. Casino - Oyster Hotel Reviews - Goyang Cafe
    Book an Oyster Hotel room today 홀덤 용어 and make 실시간 스포츠 배팅 an appointment to view the 24/7 excitement and A large, m2슬롯 spacious, 토토 사이트 high-end restaurant 승인전화없는토토사이트 with a modern vibe.

    ReplyDelete
  12. it’s very helpful thanks for your valuable information follow us
    salesforce cpq online training Hyderabad

    ReplyDelete