gosp | strongly typed templating language | Natural Language Processing library
kandi X-RAY | gosp Summary
kandi X-RAY | gosp Summary
gosp - Go Server Pages.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Compile parses the directives in the given file .
- compile gosp .
- camelCase converts a string to CamelCase
gosp Key Features
gosp Examples and Code Snippets
Community Discussions
Trending Discussions on gosp
QUESTION
I'm trying to resolve below issue: I need to prepare table that consists 3 columns: user_id, month value. Each from over 200 users has got different values of parameters that determine expected value which are: LOB, CHANNEL, SUBSIDIARY. So I decided to store it in table ASYSTENT_GOALS_SET. But I wanted to avoid multiplying rows and thought it would be nice to put all conditions as a part of the code that I would use in "where" clause further in procedure. So, as an example - instead of multiple rows:
I created such entry:
So far I created testing table ASYSTENT_TEST (where I collect month and value for certain user). I wrote a piece of procedure where I used BULK COLLECT.
...ANSWER
Answered 2017-Aug-25 at 21:47I didn't create the table function described here but that article inspired me to go back to try regexp_substr
function again.
I changed:
ppln_jsta_symbol in (:subsidiary)
to
ppln_jsta_symbol in (select regexp_substr((select subsidiary from ASYSTENT_GOALS_SET where user_id=''fake_num''),''[^,]+'', 1, level) from dual
connect by regexp_substr((select subsidiary from ASYSTENT_GOALS_SET where user_id=''fake_num''), ''[^,]+'', 1, level) is not null)
Now it works like a charm! Thank you @Dessma very much for your time and suggestion!
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install gosp
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page