how can i connect to mysql db using pl/sql in my Oracle db environment which I am using toad to manage ?
It doesnt eventually have to me pl/sql but I cant think of anything can use to program a real time trigger from a database change to directly trigger a code to push in data to other mysql database table.
I would try the Java route.
Here is an example:
And here is the Oracle Java Dev Guide
Working with Network Access Control Lists in Oracle 11g (part 2)
Part 1: http://www.e-e.com/A_8429.html
Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access. For many…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
This video shows syntax for various backup options while discussing how the different basic backup types work. It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…