Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How this regex is working ?

AS08May 23 2022

Hi All,
Please refer below examples -
When i am doing

  1. select regexp_substr('P/HOO/282/KWE/08/LATE TO LAND OR NO SHOW','(^|/)([^/]*)+(\s) (\S*).*') from dual;
    This is the correct O/p that i am getting - LATE TO LAND OR NO SHOW
    Now, when i am doing same for the below text it's giving below output.
  2. select regexp_substr('H/12/JHS/DSRP/UNKOWN/UNKOWN', '(^|/)([^/]*)+(\s)(\S*).*') from dual;
    O/p - null; -- The output i want is this /DSRP/UNKOWN/UNKOWN

Why the expression is not working for the 2 example as it is working for the 1 example ?
Also, Can anyone also explain this expression - '(^|/)([^/]*)+(\s) (\S*).*)

Please advise !

Thanks
This post has been answered by Paulzip on May 24 2022
Jump to Answer

Comments

How can they bypass squid all together for all calls to access the website as well as direct links into the content server? Is that best done inside IIS, UCM, Squid or somewhere else?

Couple of places.

1. Expose the direct / web server url for the website / wcc instead of port 8080 one on external configuration.

2. Check in config.cfg if the webserver url parameter is set to point to 8080 or is it still showing native port.

Whoopass

Thanx. How do I do that?

Open SS Designer - On the left hand pane - system / site properties are listed .

There is a setting which shows the url setting , it is there the change has to be done.

1 person found this helpful
1 - 3

Post Details

Added on May 23 2022
#oracle, #pl-sql, #sql, #sqldeveloper
9 comments
169 views
3 mentions