Oracle Create a List of Values in PL/SQL

I had a unique issue trying to determine values in an table, not in another, but in a hard coded list.

Using the Oracle COLUMN_VALUE Pseudocolumn did the trick.

select column_value as SOME_NUMBER
from table(sys.odcinumberlist(135074433,350776765,35047670))

Windows 10 and Windows.OLD Disk Space

Windows 10 left a Windows.OLD folder to revert the machine back. That folder was chewing up 20+ GB of disk.

Microsoft claims you can remove it under the Windows cleanup, but no luck it would not delete the folder. Try deleting it as Admin, nope still cannot.

I came across a post that showed how to delete this stubborn beast via a command prompt. You have run the command prompt as admin. I keep a short-cut on my desktop to cmd.exe and to run it as Admin I right-click > run as admin.

  • Take Ownership: takeown /F C:\Windows.old\* /R /A
  • Modify Access Control: cacls C:\Windows.old\*.* /T /grant administrators:F
  • Delete Folder: rmdir /S /Q C:\Windows.old\