oracle-11g | Docker image for Oracle 11g database | Database library
kandi X-RAY | oracle-11g Summary
kandi X-RAY | oracle-11g Summary
Image for running Oracle Database 11g Standard/Enterprise. Due to oracle license restrictions image is not contain database itself and will install it on first run from external directory.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of oracle-11g
oracle-11g Key Features
oracle-11g Examples and Code Snippets
Community Discussions
Trending Discussions on oracle-11g
QUESTION
I'm attempting to register change notifications from Oracle tables (19c) using Oracle JDBC . Since the query contains a JOIN I'm using BEST effort mode. My user has been "granted" CHANGE NOTIFICATION rights.
At this point I'm just trying to get the notifier accept any query. This is not the final version but I do know that we'll need a query that involves two tables with a join.
Changing the query to something simpler like SELECT * from SCDAT.SECURITIES WHERE SCDAT.SECURITIES.INSTYPE = 28
gives the same output.
Test code
...ANSWER
Answered 2021-Mar-30 at 12:11You will have to switch to "table change notification" because your table has too many columns to support "query change notification". Remove this line or comment it out:
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install oracle-11g
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