PowerShell Tip: Specify Select Column List (Attributes/Properties) Dynamically

As we pipe stuff through a pipeline, we may have the need to add/remove/rename columns. These three operations are easy to do. Remove/Add/Rename Remove: Here we remove all attributes returned from Get-Process except Handles and ProcessName by not selecting them Add: Here we add a new attribute name "NewAttribute" to the existing two attributes Handles … Continue reading PowerShell Tip: Specify Select Column List (Attributes/Properties) Dynamically

Advertisements

Oracle – Capture OS Command Output Using Oracle External Tables

Case for the OS side: Some things are best done on the OS side and there is no question about that. Case for the DB side: Some things are best done on the database side and there is no question about that either. What if? Some things need the output of one in the other … Continue reading Oracle – Capture OS Command Output Using Oracle External Tables

PowerShell – No Mouse, Search & Activate A Tab In ISE With Partial String Search – e.g.: “Popt register”

Search and activate PowerShell ISE tabs using partial search strings

Oracle – Why Is Toad Asking Me To Commit/Rollback A SELECT With No Transaction?

Commit or rollback a SELECT, really? Occasionally, you would be working with your favorite Oracle tool and when you are ready to close the tool, it will prompt you to either commit or rollback your work. “What work?”, you wonder. The problem is, you have only done SELECT’s. Why is it prompting you to commit … Continue reading Oracle – Why Is Toad Asking Me To Commit/Rollback A SELECT With No Transaction?

Oracle Tip – ORDER BY with NULLS LAST or NULLS FIRST

The purpose of this tip is to introduce you to an seldom-used by very useful clause within the ORDER BY of a SQL statement – NULLS FIRST or NULLS LAST. Here is a situation that I ran into: I was looking into the Oracle 11g system view v$sql_plan_monitor to find out the top execution plan … Continue reading Oracle Tip – ORDER BY with NULLS LAST or NULLS FIRST