Have a string field which may contain one or more names seperated by a comma. I need to return just the Initials.
Fred Bloggs, Dave Smith, Eileen Bab FB, DS, EB
John Sayer JS
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.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.