log: 2021

2020-11-17: … Excel: application.volatile, … =info(), … Excel: intersection operator

2020-11-18:

• Excel object autoFilter, function printFilteredColumns to print filtered columns
• get-cimClass, get-cimInstance, get-wmiObject
• battery (script)

2020-11-19:

• get-azResourceProvider
• pragma udf
• Writing a logger with pragma autonomous_transaction

2020-11-20:

• Oracle data-type timestamp
• Python standard-library argparse
• utl_call_stack

2020-11-21:

• $ORACLE_HOME/rdbms/admin/utlsampl.sql
• insert_statement_creator.sql
• PL/SQL: collection types

2020-11-22:

• Azure Blob Storage

2020-11-23:

• PowerShell module az
• connect-azAccount

2020-11-24:

• PowerShell: Iterate over array that contains name/value pairs
• Powershell command noun: azAccessToken
• U-SQL

2020-12-01:

• register-argumentCompleter
• System.Collections.Hashtable
• XPath
• get-psReadLineOption

2020-12-04:

• ANSI escape sequences

2020-12-05:

• $host.ui
• $host.ui.rawUI
• get-credential
• osk.exe
• System.Data.SqlClient

2020-12-06:

• Azure SQL Managed Instance

2020-12-08:

• JIRA
• Azure DevOps
• ORA-06502: PL/SQL: numeric or value error: character string buffer too small
• PowerShell: Redirection Operators

2020-12-09:

• out-file
• Changing line endings

2020-12-10:

• PowerShell parameter attribute: validateScript
• Azure Pipelines

2020-12-11:

• $psDefaultParameterValues

2020-12-12:

• ORA-00257 Archiver error. Connect AS SYSDBA only until resolved
• Checking the space limit and the used space
• Encodings of Scripts
• System.IO.StreamWriter

2020-12-13:

• Azure CLI
• Azure DevOps: Personal Access Tokens
• Git Credential Manager Core

2020-12-14:

• Oracle SQL verb rename
• https://github.com/ReneNyffenegger/temp-PLSQL-logger
• alter session …
• authid

2020-12-15:

• C-Sharp: verbatim and interpolated strings
• .NET: format strings
• Remove SQL comments with C-Sharp

2020-12-16:

• authid
• Effects of ALTER SESSION SET CURRENT_SCHEMA in AUTHID DEFINER and AUTHID CURRENT_USER packages

2020-12-17:

• register-objectEvent
• session
• PowerShell: CmdLets with the -ComputerName parameter
• receive-job

2020-12-18:

• tracefile_identifier
• PL/SQL block
• plan_table
• Windows File System: Reparse Points

2020-12-19:

• Powershell command noun: executionPolicy

2020-12-21:

• git remote
• .git/config
• Sync forked github repository
• dbms_comparison
• alter system
• Stellarium API: core.output()

2020-12-22:

• PowerShell: The automatic variables $PSScriptRoot and $PSCommandPath
• PowerShell: module manifest file
• X as code
• Powershell command verbs
• ADO vs DAO
• DAO: Object Model

2020-12-23:

• Excel (State)
• scrnsave.scr
• reflect.ps1

2020-12-24:

• Oracle: Collection types stored in table
• dbms_sql.describe_columns
• Oracle DBMS_UTILITY: FORMAT_xxx functions

2020-12-26:

• LibreOffice: Tools -> Options | Libre Office -> Security -> Macro Security

2020-12-28:

• nls.sql

2020-12-29:

• LWP::Simple
• NET::SSLeay
• Outlook Object Model: Application.GetNamespace
• PowerShell: class inheritance

2021-01-02:

• Vim: looping commands

2021-01-04:

• Team Foundation
• %APPDATA%\Microsoft\Windows\Recent\AutomaticDestinations and %APPDATA%\Microsoft\Windows\Recent\CustomDestinations
• Shell Automation Service
• TF.exe add

2021-01-05:

• Shell Automation Service
• explorer_exe: Quick Access
• start shell:::{GUID}
• PowerShell host

2021-01-06:

• vsDiffMerge.exe

2021-01-11:

• Oracle.DataAccess.Types.OracleClob
• PowerShell example for Oracle.DataAccess.Client.OracleParameter.

2021-01-12:

• setx.exe
• Microsoft.VisualBasic.VariantType
• Scripting.FileSystemObject
• Scripting.Dictionary
• Filling an Excel range fast with PowerShell

2021-01-13:

• orastart
• Oracle sessions
• Oracle maintained roles
• Visual Studio menu: View -> Other Windows -> Source Control Explorer
• ora_hash()
• dbms_crypto

2021-01-14:

• Oracle: System privileges
• dbms_crypto.hash
• returning clause for identity columns in Oracle

2021-01-17:

• SQL Developer: View -> Connections

2021-01-18:

• SQL Developer: View -> Show Only Editor

2021-01-19:

• Microsoft products
• Dataverse: table
• FetchXML for SQL developers

2021-01-21:

• v$sql_workarea
• NLS related init parameters
• C:\Windows\System32\winevt\Logs
• PowerShell event log

2021-01-22:

• Oracle procedure KILL_MY_SESSION to kill a session
• C-Sharp: modify an App.exe.config file
• C-Sharp: read settings from an App.exe.config file
• System.Runtime.InteropServices.RuntimeEnvironment

2021-01-26:

• SCClient.exe
• PowerShell: Get an object's property value by a dynamic property name

2021-01-27:

• Vim modes
• Deleting every 2nd line in Vim (:g/^/+d)
• %LOCALAPPDATA%\Packages\Microsoft_Windows_ContentDelivery_Manager_cw5n1h2txyewy\LocalState\Assets

2021-01-28:

• dbms_debug_jdwp
• nls_sort
• cmd.exe / Character set (UTF8)
• Oracle: Influence of NLS_SORT and NLS_COMP to equality of text (strings)
• ORA-24344: success with compilation errors
• set autotrace
• PL/SQL loop (continue)

2021-01-30:

• Oracle: Temporarily change an NLS setting in a session
• Oracle: v$sql_plan vs v$all_sql_plan
• Group by LOB columns not permitted
• Oracle Trace files
• dbms_sqltune
• Oracle: ALTER SESSION SET INIT_PARAMETER …
• sql_trace
• trigger
• ORA-01722: invalid number
• Init parameter event.

2021-01-31:

• List of possible(?) values for the Oracle parameter EVENT
• Oracle system privilege: SYSDBA
• ORA-00942: table or view does not exist
• v$process_memory_detail

2021-02-01:

• query block
• dbms_utility.name_resolve
• v$metric_history

2021-02-03:

• SQL statement
• dbms_sqltune
• System.Windows.Media.MediaPlayer
• orastack.exe

2021-02-04:

• Oracle: Semantical parsing of SQL statements with UTL_XML.PARSEQUERY

2021-02-05:

• DBA_TABLESPACE_USAGE_METRICS / CDB_TABLESPACE_USAGE_METRICS

2021-02-06:

• Oracle: diff table structure

2021-02-07:

• v$latch vs v$latch_parent vs v$latch_children
• dbms_system.get_env

2021-02-09:

• Oracle PL/SQL: PRAGMA DEPRECATE
• dbms_utility.compile_schema
• plsql_warnings
• comp.sql
• anydata.getType
• Oracle: Nested tables
• v$sql_bind_metadata

2021-02-10:

• Oracle SQL: show table columns, their data types and primary key positions
• Exporting data from SQL Developer to Excel
• with clause
• Oracle PL/SQL: PRAGMA INLINE
• fixed table

2021-02-11:

• cl /FA

2021-02-12:

• WinDbgx.exe
• %WindowsSdkDir%\Lib

2021-02-14:

• cl /w
• Debugging tools for Windows: scripting
• ln

2021-02-16:

• Oracle PL/SQL: Errors and warnings
• convert-path
• System.IO.File::ReadAllText
• PowerShell Scripts

2021-02-18:

• System.Management.Automation.PathIntrinsics
• new-timeSpan
• XML related SQL functions
• XQuery

2021-02-19:

• Concatenate strings in PowerShell
• register-scheduledTask

2021-02-21:

• KernelBase.dll: time

2021-02-22:

• System.IO.File: ReadAllBytes and WriteAllBytes
• PowerShell: byte arrays
• Static compilation of Zydis with gcc

2021-02-23:

• HTTP Header: Content-Type
• PowerShell: switch parameter

2021-02-24:

• json_table
• v$diag_trace_file, v$diag_trace_file_contents.
• Oracle SQL: using the LAG analytic clause to show values only when they change
• Oracle: finding kernel-internal function names with V$DIAG_TRACE_FILE_CONTENTS

2021-02-25:

• C:\Program Files\DTrace

2021-02-26:

• PL/SQL: Conditional Compilation
• Powershell: Param(Parameter(Mandatory=$true|$false))
• BitLocker
• Kernel Patch Protection
• OpenDTrace - Windows
• Windows: set date in process (faketime for Windows)

2021-02-27:

• System.Runtime.InteropServices.GCHandle
• WinAPI and C-Sharp: EnumWindows
• PowerShell script to reflect a given type
• System.Runtime.InteropServices.Marshal
• MASM Macro Assember: Hello world

2021-02-28:

• x$ksmfsv
• dbms_describe
• Oracle internals: process (Windows)

2021-03-01:

• Debugging tools for Windows: scripting with JavaScript

2021-03-02:

• Logging function parameter values with the JavaScript extension of Windows Debugger

2021-03-06:

• Oracle internals: functions

2021-03-08:

• exception
• disassembler

2021-03-11:

• v$sqlfn_metadata

2021-03-13:

• LibreOffice: Tools -> Language -> For All Text
• sigcheck

2021-03-17:

• DbgShell

2021-03-18:

• tracerpt.exe
• PL/SQL: PIPE ROW

2021-03-19:

• v$result_cache_objects

2021-03-21:

• Pin
• latch
• C: modulo operator %

2021-03-22:

• SQL Developer user information directory: SystemV.W.X.Y.Z/o.ide.x.x.x.x.x.x/preferences.xml
• cluster

2021-03-23:

• Oracle SQL: ROW_NUMBER, RANK and DENSE_RANK
• Visual Studio menu: Debug -> Windows

2021-03-25:

• constraint
• Oracle: SQL query to recursively query referential integrity dependencies

2021-03-26:

• Excel: File -> Options -> Advanced
• Excel: Importing and displaying CSV data

2021-03-27:

• System.Management.Automation.Cmdlet (abstract class)
• PowerShell cmdlet: Parameter sets

2021-03-28:

• Integral numeric types

2021-03-29:

• PowerShell example for Oracle.DataAccess.Client
• Powershell + Microsoft.Office.Interop.Excel
• PowerShell: Convert CSV files in a directory to Excel Workbooks
• Powershell module: filesystem
• Powershell module: zip

2021-03-30:

• PowerShell: ANSI colors
• Excel Object Model: Worksheet.protect/unprotect
• workbook.linkSources

2021-03-31:

• Oracle SQL: CROSS APPLY
• notif.ps1

2021-04-01:

• System.Convert
• Registry filtering driver

2021-04-03:

• autoread
• WinAPI: Interlocked* functions
• Enumerate Windows Services in C/WinAPI

2021-04-05:

• Oracle SQL functions related to text (VARCHAR2, NVARCHAR2, CHAR, NCHAR, CLOB and NCLOB)
• VIM script 9

2021-04-06:

• Excel Object Model: Connections
• Excel: File -> Info
• Excel functions: char, unichar, code, unicode

2021-04-07:

• dbms_utility.expand_sql_text
• resolve-relativePath and write-file

2021-04-09:

• System.Management.Automation.VTUtility
• PowerShell: -split operator
• PowerShell: Create a char array from a string
• PowerShell: coloring the output of a command
• Regular expressions: start and end of line ($, ^)

2021-04-11:

• System.Type InvokeMember
• Power Query M Formula: Hello world example

2021-04-12:

• Powershell module: console

2021-04-13

• PowerShell cmdLet get-AIPFileStatus
• Power Query M formula language standard library: Table.TranformColumnTypes
• Excel Object Model: OLEObject / MSForms / CommandButton

2021-04-14:

• Power Query M formula language standard library: Csv.Document
• PowerShell module filesystem, example: copy and modify files in a filesystem tree

2021-04-16:

• $errorActionPreference

2021-04-17:

• PowerShell: common parameter -errorVariable
• Power Query M formula language standard library: Table.Join
• Power Query M formula language standard library: Table.ExpandTableColumn

2021-04-18:

• Power Query M formula language standard library: Excel.CurrentWorkbook
• Power Query M formula language: data type table

2021-04-25:

• grammar

2021-04-27:

• Excel Object Model: workbook.connections

2021-04-29:

• settings.json

2021-04-30:

• System.Xml.XmlWriter
• System.Xml.XmlDocument
• product-preferences.ps1

2021-05-07:

• Oracle: SQL plan directive

2021-05-10:

• Drop Oracle objects
• ff.ps1
• Oracle: Dynamic Optimizer Statistics

2021-05-11:

• Excel function: Filter

2021-05-13:

• Oracle optimizer feature: subquery unnesting
• development/databases/Oracle/installed/data-dictionary/tab/statistics/stale-or-no-statistics.sql
• dbms_auto_task_admin
• v$sql_plan_statistics

2021-05-14:

• utl_file
• PowerShell error message: The 'xxx' command was found in the module 'xxx', but the module could not be loaded.
• Registry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Keyboard Layouts

2021-05-15:

• Altgriechisch

2021-05-16:

• Oracle: DBMS_SYSTEM.READ_EV
• PowerShell module await - A modern implementation of EXPECT for Windows

2021-05-17:

• System.Diagnostics.Process - Start()
• Oracle: global indexes
• Oracle: global vs ordinary indexes
• Oracle PLAN_TABLE: Column OTHER_XML

2021-05-18:

• choice.exe
• charmap.exe
• Office VBA: set Azure Information Protection Label

2021-05-19:

• Oracle SQL plans: filter predicate INTERNAL_FUNCTION()
• Oracle Interesting SQL statistics of V$STATNAME

2021-05-20:

• v$sql_plan_monitor
• Oracle: Lateral inline views

2021-05-21:

• Oracle: use EXPLAIN PLAN to find objects whose statistics weren't taken for a certain amount of time
• Show columns of an index
• Oracle: DBMS_UTILITY.GET_TIME

2021-05-22:

• method_opt

2021-05-24:

• Oracle: automatic indexing

2021-05-25:

• Powershell module: COM
• Set Azure Protection Label Tag with WinAPI CBTHook and VBA

2021-05-26:

• Oracle SQL: nesting aggregate functions
• INTERVAL related Oracle functions
• Oracle: PL/SQL package TIM for DATE and INTERVAL related functionality

2021-05-27:

• Oracle: Query last executed SQL statement by joining V$SESSION and V$SQL

2021-05-31:

• Oracle: Adaptive query optimization
• Oracle: Online statistics gathering

2021-06-01:

• Excel functions: Separating arguments with semicolon or commas

2021-06-02:

• VBA: A StringBuffer class for string concatenation
• OraOLEDB

2021-06-03:

• Python library Lark: rules
• Python Exception: UnboundLocalError: local variable '…' referenced before assignment
• Powershell module: Outlook

2021-06-04:

• VBA: Too many line continuations
• Powershell module: bypassEmailProxyRules
• WorksheetView

2021-06-05:

• System.Management.Automation.ErrorCategory (enum)

2021-06-06:

• System.Xml.XmlDocument - Save()
• System.Management.Automation.PSParser (class)

2021-06-07:

• PowerShell: set Zone.Identifier to simulate file being downloaded from the Internet
• PowerShell: formatting file

2021-06-08:

• PowerShell: displaying objects in the console
• System.Management.Automation.PSTypeConverter (abstract class)

2021-06-09:

• PowerShell cmdLet format-custom
• PowerShell: access module-private variables with the call operator

2021-06-14:

• Powershell module bypassEmailProxyRules: ZIP archives
• Examples for VBScript MS-Office App Creator: Change the codeName property of a worksheet
• betacode

2021-06-15:

• Excel worksheet function convert(): convert a number from one measurement system to another
• Excel: serial number

2021-06-16:

• Examples for VBScript MS-Office App Creator: compileApp
• VB Editor Object Model: VBE
• VB Editor Object Model: Iterate over controls of the VB Editor

2021-06-17:

• Excel Object Model: Workbook.runAutoMacros
• Excel Object Model: Application.caller
• VBA: attribute vb_predeclaredId

2021-06-18:

• VBA: Resource acquisition is initialization (RAII)
• ADO/VBA examples for Oracle: Transaction management
• Disable the right click on a sheet tab
• The Excel Menu Page Layout -> Themes

2021-06-20:

• PowerShell: Pass function/cmdlet parameters by reference

2021-06-21:

• Excel: View -> Window -> Freeze Pane
• Styles
• VBA operator: like

2021-06-22:

• VBA: colon, the statement separator

2021-06-23:

• dbms_json
• Excel Object Model: Application.onTime
• CommandBars.executeMso
• System1.mdw

2021-06-24:

• Excel Object Model: Range.clear*
• Powershell module: MS-Office

2021-06-25

• CSS property: border-spacing
• Examples for VBScript MS-Office App Creator: insertSheet
• VB Editor Object Model: VBE.MainWindow
• Excel Object Model: Order of Events
• Excel Object Model: Worksheet.scrollArea
• Excel GUI
• System.DateTime: file time related methods

2021-06-26:

• System.BitConverter (class)
• Excel Popup: Format Cells
• Oracle: PL/SQL package TIM: function ISO_8601

2021-06-28:

• Oracle SQL noun: USER
• Oracle: PL/SQL package ASSERT
• Oracle: package SES for session related functionality
• Oracle PL/SQL functionality for tasks
• Office Ribbon: File -> Save [As]

2021-06-30:

• unmanaged code
• COM Objects: Runtime Callable Wrappers
• Powershell module COM: function get-activeObject
• Oracle SQL/JSON

2021-07-03:

• Oracle: PL/SQL package TIM: function RFC_3339_SEC
• Oracle: materialized views / prebuilt tables
• Oracle: Materialized views - fast refresh

2021-07-04:

• Yarn
• Vim for VSCode

2021-07-05:

• URLs: Text Fragments

2021-07-06:

• Office Object Model: TextRange2
• slash-error.sql
• Windows: Performance Counters
• option
• Simple demonstration script for using Tim Halls VBA-JSON parser
• Office Ribbon: Developer tab
• Office Ribbon: File -> Options -> Save
• Excel: Home -> Editing -> Find & Select -> Go To Special
• Excel: Save a range as image

2021-07-08:

• functools: cache
• Oracle datatype VARCHAR2: BYTE vs CHAR
• utl_raw

2021-07-09:

• ORA-02449: unique/primary keys in table referenced by foreign keys
• ORA-02266: unique/primary keys in table referenced by enabled foreign keys
• ORA-14402: updating partition key column would cause a partition change
• VBA: UserForms

2021-07-12:

• Powershell + Microsoft.Office.Interop.Excel
• Powershell module: regex

2021-07-13:

• Tests for the VBA module ExcelHelpers
• Access Object Model: MacroError
• free SMS receiver

2021-07-15:

• explorer.exe: GUI
• OneDrive
• Registry: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideMyComputerIcons
• Registry: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\AllowedEnumeration

2021-07-16:

• set operator
• Oracle: Compare the data of two tables
• RstrtMgr.dll
• PowerShell module filesystem: get-openFileProcess

2021-07-17:

• Perl function: hex
• PowerShell: common parameter -errorAction

2021-07-20:

• VBA: file class
• Excel chart types: column-clustered / with data table
• Ole-DB Excel Client
• Power Query M formula language: Get data of a (named) range
• Power Query M formula language standard library: Diagnostics.Trace

2021-07-21:

• dba_errors

2021-07-22:

• Oracle: PL/SQL package JSN to assist in creation of JSON data

2021-07-23:

• Examples for VBScript MS-Office App Creator: creation of a form
• Command Palette
• workspace
• VS Code: Workspace Trust
• Excel Object Model: Window.ScrollRow and Window.ScrollColumn
• %LOCALAPPDATA%\Google\Chrome\User Data

2021-07-25:

• Chrome user data directory: Local State
• Chrome profile directory: History

2021-07-27:

• Test for function showRibbon of the VBA module ExcelHelpers
• Test for function resetExcelSheet of the VBA module ExcelHelpers
• Excel: Fill a range fast with VBA
• Excel Range object: sort

2021-07-28:

• PowerShell: the automatic variable $lastExitCode
• Data URLs

2021-07-29:

• VBA function: MsgBox

2021-07-30:

• VS Code: Language support
• Oracle SQL: UPDATE … RETURNING INTO …
• Oracle PL/SQL: RETURNING INTO clause

2021-08-02:

• regat.ps1
• paths.ps1
• Powershell module: winFileExtProgId

2021-08-03:

• Power Query M formula language standard library: List.Accumulate

2021-08-04:

• Excel Object Model: moving (offsetting) and resizing ranges
• VBA module ExcelRange
• VBA: attribute name.vb_procData.vb_invoke_func

2021-08-05:

• PowerShell: Overriding the default ToString() method
• Registry: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Feeds

2021-08-08:

• Powershell module: SQL Developer

2021-08-09:

• Registry: HKEY_CURRENT_USER\Software\VB and VBA Program Settings
• Oracle: JSON_OBJECT
• json_array

2021-08-10:

• System.Security.Principal.WellKnownSidType (enum)
• Windows.Security.Principal.WindowsIdentity - AuthenticationType
• Claims based identity
• System.Security.Claims.Claim (class)
• System.Security.Principal.WindowsBuiltInRole (enum)

2021-08-11:

• Microsoft Defender
• enum

2021-08-12:

• Windows: Service SID (S-1-5-80-…)
• TFS Web API

2021-08-13:

• metaxlsparam$
• Examples for DBMS_METADATA
• PowerShell: Date and time arithmetics

2021-08-16:

• System.Runtime.InteropServices.CharSet (enum)
• System.Runtime.InteropServices.MarshalAsAttribute (class)
• System.Runtime.InteropServices.UnmanagedType (enum)

2021-08-17:

• VB Editor: Tools -> project-name Options …
• Registry: HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Power\PowerSettings
• Oracle SQL: Comma separated values to a table (using JSON_TABLE)
• Validation

2021-08-18:

• Excel Object Model: the xlCellType enumeration
• Access Object Model: Application.getOption / setOption
• Oracle columns: DATA_LENGTH, DATA_PRECISION and DATA_SCALE

2021-08-19:

• System.Data.OleDb.OleDbSchemaGuid (class)

2021-08-20:

• System.Management.Automation.Host.ReadKey

2021-08-22:

• System.Data.OleDb.OleDbTransaction (class)

2021-08-23:

• Dynamically create a VBA module while VBA is executing

2021-08-24:

• ORA-00997: illegal use of LONG datatype

2021-08-25:

• dbms_metadata_diff
• Oracle.DataAccess.Client.OracleCommand - ExecuteNonQuery()
• Excel Object Model: Range.CopyFromRecordSet

2021-08-26:

• ip.ps1 - Print IP Addresses of local non-loopback network interfaces.

2021-08-27:

• PowerShell: Convert Excel worksheets of workbooks in a directory to CSV files
• .NET Namespace OracleInternal.*

2021-08-28:

• Oracle: PL/SQL package TXT for string (text) related functionality

2021-08-30:

• Oracle: PL/SQL package SQL_STMT for management and execution of SQL statements
• Data Model

2021-09-01:

• ODAC
• regsvr32.exe

2021-09-02:

• System.IO.Path - ChangeExtension()

2021-09-03:

• Registry: HKEY_CLASSES_ROOT\Component Categories

2021-09-04:

• 94-Prozentige Wirksamkeit der COVID-Impfung

2021-09-18:

• Rezeptor
• ACE2
• Infektionsverstärkende Antikörper

2021-09-20:

• Oracle PL/SQL: Deterministic functions

2021-09-21:

• PL/SQL functions: Overhead when using in SQL
• Powershell script: rot13.ps1

2021-09-23:

• Oracle: JSON_DATAGUIDE
• json_arrayagg

2021-09-27:

• Oracle: JSON related PL/SQL types
• Powershell: Param(Parameter(ValueFromPipeline=…)
• filter

2021-09-28:

• PowerShell: common parameter -informationVariable
• System.Management.Automation.Language.NullString

2021-10-01:

• context
• WebDAV

2021-10-04:

• Excel VBA: Insert numerical text as text

2021-10-05:

• VBA: module JSON
• VBA module ExcelRange - function excelRangeToJson

2021-10-06:

• System.Globalization.CharUnicodeInfo (class)
• Powershell: Param(Parameter(ValueFromRemainingArguments=$true|$false))
• Registry: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RecentDocs
• VBA class: StringJoiner - join strings on a given separator
• Virus

2021-10-07:

• Oracle: PROXY_USERS
• sys_refcursor
• Oracle: Pipelined PL/SQL functions

2021-10-08:

• DASL
• Outlook VBA: Show folder tree
• to_date
• Oracle: INSERT statement - log errors

2021-10-11:

• IGV

2021-10-12:

• VBA module ExcelRange - function excelRangeResize
• table_constraints

2021-10-15:

• PowerShell parameter attribute: validateSet
• Regular expressions: case sensitivity

2021-10-18:

• parallel_degree_policy
• Oracle: CREATE TABLE … AS SELECT …
• Oracle: INSERT statement with APPEND hint

2021-10-22:

• System.IO.FileSystemWatcher (class)

2021-10-27:

• Outlook Object Model: applying filters

2021-10-29:

• Oracle: DBA_STATEMENTS
• plscope_settings

2021-10-31:

• PowerShell: Invoke-WebRequest - Desktop vs Core edition

2021-11-01:

• PL/Scope
• Oracle SQL: select number of distinct values in a group

2021-11-02:

• SQL Server: OLE-DB
• SQL Server: sys.key_constraints

2021-11-03:

• ORA-01861: literal does not match format string
• define
• Powershell: Param(valueFromPipelineByPropertyName)

2021-11-07:

• iText

2021-11-08:

• Oracle: SELECT with PIVOT clause

2021-11-09:

• isNull

2021-11-10:

• to_number

2021-11-15:

• DBMS_STATS.GATHER_xxx_STATS: parameter ESTIMATE_PERCENT
• Oracle: Importing and exporting optimizer statistics with DBMS_STATS
• tq84-OCI: a simple C library for Oracle's Call Interface

2021-11-16:

• SQL Server: GROUP BY - ROLLUP clause
• WaitForDebugEvent

2021-11-17:

• Oracle SQL: INSERT INTO … SELECT * FROM …

2021-11-18:

• dbms_fga
• Oracle: Object types related to the PLAN_TABLE
• Oracle: DBMS_XPLAN.COMPARE_PLANS

2021-11-19:

• Oracle: ALTER SESSION DISABLE COMMIT IN PROCEDURE
• merge

2021-11-21:

• Oracle: ALTER SYSTEM DUMP DATAFILE
• VAERS

2021-11-22:

• dbms_xplan.display
• partition extension clause

2021-11-23:

• sql_variant
• SQL Server functions: year(), month() and day()
• SQL Server: functions and expressions that evaluate to 'now'
• Excel: Data -> Data Tools -> Remove Duplicates
• PowerShell: bitwise operators

2021-11-24:

• Salzsäure
• Access: DoCmd.ApplyFilter
• System.Windows.Forms.DataVisualization.Charting.DataPoint
• System.Windows.Forms.DataVisualization.Charting (namespace)

2021-11-25:

• Oracle: REGR_* functions
• approx_count_distinct
• segment header

2021-11-26:

• SQL Developer: Help -> About -> Properties
• Oracle Optimizer Tracing

2021-11-28:

• ORACLE_HOME/bin/wrap

2021-12-01:

• SQL*Plus: SET NUMFORMAT / NUMWIDTH

2021-12-02:

• ORA-00600: internal error code…

2021-12-03:

• PowerShell: Pipeline Chain Operators

2021-12-04:

• VAERS data
• DBMS_REDEFINITION example: Rename columns and change data types

2021-12-05:

• Python: sqlite3 - Cursor
• datetime

2021-12-06:

• Oracle: SELECT a random SAMPLE from a table

2021-12-23:

• WebGL: Draw points

2021-12-24:

• Create Personal.xlsb from command line

2021-12-25:

• 3D Algorithms: matrices
• WebGL: Clip space

2021-12-26:

• OpenGL ES Shading Language

2021-12-27:

• JavaScript: closure
• WebGLRenderingContext | WebGL2RenderingContext
• C:\Program Files\RStudio\bin\rstudio.exe
• R: string literals

2021-12-28:

• Access: DoCmd.SetOrderBy
• Access Object Model: Application.SysCmd
• SQL Server: Virtual System Columns