I have the string structure as "l0adad@15-apr-1999@success@select count(*) from dual"
In this I need to extract string separated by the delimiter '@'. For example in this case I need to extract l0adad
and select count(*) from dual
into separate variables. Could anyone help me in suggesting a way for this. Do you have any direct functions for doing this?
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux.
Script may need to be modified depending on OS-installation.
Please deploy and verify the script in a test environment.