A table was accidentaly truncated. The data in that table is kind of snapshot and even if we re-run the program that populated the table we will not able to reconcile it to the data the table previously contained before truncating.
Is there a way to recover this data from db backups (level 0 or level 1)
you might be lucky and have flashback configured and running, so you might not need to "restore" anything, just "flashback" the table:
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
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.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…