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
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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…