If i have a column in a table with numeric values in it (e.g. projectnr 1|2|3|5|10). How can i get the next value in the table. I want to fill up the holes so that the next time i create a new project, the projectnr will automatically set to 4. And the time after that, is has to be a 6 etc.
I tried it with a cursor for the numbers in the table and a loop with i 1..999 but that doesn't work.
In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.