Is it possible to RPAD/LPAD a null value string for spaces and if so what is the syntax? Example:
column NULL1 format a2
' ' as NULL1,
Is it possible to put rpad or lpad and the number of spaces in this statement? The user wants to rpad a char field in a script or lpad a numeric field the formatted number of spaces. The script is used for populating one database to another. Thank you.
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.