Q&A BY TAG 'Invalid query in create base view from query'

You must sign in to ask a question. If you do not have an account, you can register here

Base view deployed even though table not present in database
answered 27-03-2020 12:22:06 -0400

Hello team, We are deploying a view created from A database from A environment to B environment. When deployed a view from A to B we found that the table was not present in the database B yet the view was deployed. we got to know that table was not pr...

Answers: 1

SolutionManager Invalid query in create base view from query Base view Deployment using Solution Manager Best Practice

Invalid Query because of Oracle REGEXP_LIKE pattern
answered 03-03-2020 04:40:24 -0500

Hi, I am trying to create a base view from query with below sql syntax. However it is failiing with invalid query so i came to know that it is because of '<(1\d{3}(.\d+)?)+>'). Now i tried escaping { and } with '\' but still no success. i am ...

Answers: 1

Invalid query in create base view from query