Search notes:
log: 2022
2022-01-03:
Outlook Object Model: Items.Restrict
2022-01-04:
Microsoft Exchange
SQL Server: SET SHOWPLAN_ALL / SHOWPLAN_TEXT / SHOWPLAN_XML
execution plan
2022-01-05:
dbms_xplan.display_cursor
Oracle: Find tables with given set of column names
2022-01-06:
Oracle: Using SQL to create a SELECT statement with a table's column names
ORA-00904: invalid identifier
Examples for DBMS_METADATA: Recreate tables
2022-01-07:
vartabstop
SP2-0027: Input is too long (> 4999 characters) - line ignored
Oracle DBMS_METADATA: Write selected DDL statements in a file with SQL*Plus' command SPOOL
2022-01-10:
PowerShell: Search and replace text in a directory
Using Oracle Data Cartridge Interface for User Defined Aggragation Functions
2022-01-11:
indirect
2022-01-12:
Using Excel's AutoFilter object in the Immediate Window
dbms_sql_translator
Oracle: DBMS_LOB.CREATE_TEMPORARY
Oracle: Extract lines from a CLOB
2022-01-13:
dbms_advanced_rewrite
textjoin
Excel: Create comma separated values from a (selected) range
System.Management.Automation.PSControl (class)
2022-01-14:
PowerShell: Calculated Properties
SQL precedence (AND, OR)
cursor_sharing_exact
2022-01-16:
Windows: Language Bar
2022-01-17:
ORA-01489: result of string concatenation is too long
ORA-01704: string literal too long
2022-01-18:
System.Management.Automation.StopUpstreamException (internal class)
2022-01-19:
git gui
ORA-01476: divisor is equal to zero
2022-01-20:
ORA-06512: at
, line N
ORA-12727: invalid back reference in regular expression
2022-01-21:
Oracle: Apply an expression on all columns of a table
2022-01-22:
Excel: Data -> Data Tools -> Text to Columns
Access: DoCmd.FindRecord
2022-01-23:
#pragma once
Libre Office Basic
2022-01-24:
model
2022-01-25:
Access: DoCmd.TransferSpreadsheet
2022-01-26:
Sort
2022-01-27:
v$temporary_lobs
Oracle: An alternative for LISTAGG to avoid ORA-01489
2022-01-28:
Excel: Turn selected region into SQL Insert Statements
2022-02-01:
Access: DoCmd.OpenQuery
MS Access SQL data types
Highlighting differences in two ranges in Excel
2022-02-02:
Oracle: Tables with PERIOD DEFINITIONS
2022-02-05:
control_management_pack_access
2022-02-07:
Oracle: Introduction to AWR of 2014-11-03
dba_hist_sqltext
DBA_HIST_ACTIVE_SESS_HISTORY: Query duration of SQL statement executions
Security Support Provider Interface
Oracle: Private Temporary Tables
2022-02-09:
dbms_sqlhash
Git directory: introduction
2022-02-10:
registrymodifications.xcu
Get-ChildItem, Parameter -Include
dbms_wm
2022-02-11:
namespace
dbms_privilege_capture
2022-02-12:
SQL*Plus: WHENEVER SQLERROR
Python library: certifi
2022-02-13:
Grant privileges on columns
2022-02-14:
Oracle: ALTER SESSION SET CONSTRAINTS …
2022-02-15:
dbms_transaction
Oracle Transaction Isolation Levels
bin_to_num
SQL Server: Hints
2022-02-16:
D3.js
Oracle: Enabling PL/SQL functions for parallel execution
Oracle SQL: WHERE clause in hierarchical queries
workarea_size_policy
Oracle Resource Manager
dbms_duma_internal
2022-02-17:
Oracle SQL: Implict data type conversion
2022-02-18:
Oracle: Conventional Path vs Direct Path Load
OPTIMIZER STATISTICS GATHERING
Oracle: Conventional Path vs Direct Path Load
2022-02-19:
match_recognize
2022-02-20:
Oracle: Default Degree of Parallelism for tables
2022-02-21:
Oracle: Change data types in a table
DBMS_XPLAN.DISPLAY_CURSOR: cannot fetch plan for SQL_ID …
2022-02-24:
DBMS_PARALLEL_EXECUTE examples
set echo
2022-02-25:
UTL_RAW.CONVERT
max_string_size
Oracle: NLS related data dictionary views
convert
2022-02-26:
Oracle Analytic Functions: FIRST_VALUE, NTH_VALUE etc.
Oracle SQL: Fill missing values (gaps) with previous value
2022-02-28:
Oracle SQL example: lendings
2022-03-01:
Oracle SQL Plan operation INDEX SKIP SCAN
2022-03-03:
mspdbcore.dll
Oracle SQL Plan operation: Nested NESTED LOOPS
no_nlj_batching
2022-03-04:
Oracle SQL: Selecting data with a hierarchical structure
Oracle: Partition pruning
2022-03-07:
SDDL
System.DirectoryServices.AccountManagement.UserPrincipal (class)
ORA-22288: file or LOB operation … failed
2022-03-10:
Oracle PLAN_TABLE: column PARTITION_START and PARTITION_STOP
clustering factor
2022-03-11:
cost
INDEX FAST FULL SCAN
2022-03-13:
Oracle: Row source statistics
2022-03-14:
Oracle: JSON_VALUE
2022-03-16:
Oracle JSON example
accept
2022-03-17:
variable
2022-03-18:
Oracle: LONG to VARCHAR2
DBMS_SHARED_POOL.PURGE
2022-03-19:
Prerequisites for filling V$SQL_PLAN_STATISTICS and V$SQL_PLAN_STATISTICS_ALL
PLS-00201: identifier … must be declared
2022-03-23:
max_idle_blocker_time
2022-03-27:
SQL*Loader: FOR INSERT option, table must be empty. Error on table …
2022-03-29:
git clone - Effects on the .git/config file
2022-03-30:
Oracle SQL Plan operation MERGE JOIN
2022-03-31:
oradebug dump modified_parameters
set feedback
Oracle: log file sync
2022-04-01:
DBMS_METADATA example: Export a schema
2022-04-02:
Python library: beautifulsoup4
Herman Charles Hoskier
2022-04-04:
System.Text.RegularExpressions.Regex - Matches()
ALTER SESSION SET EVENTS TREEDUMP
ORA-14767: Cannot specify this interval with existing high bounds
ORA-25122: Only LOCAL bitmap indexes are permitted on partitioned tables
2022-04-05:
where clause
Oracle: Row sources for INDEX SCAN operations
Oracle: SQL Plan for Scalar Subqueries
2022-04-06:
Oracle: Table aliases in FROM clauses
Oracle: View merging
SNB Reporting
Oracle SQL Plan operation: WINDOW (BUFFER)
WINDOW SORT
Oracle: Full Table Scan vs. Using Index
2022-04-08:
Terraform module structure
2022-04-10:
Stemma
2022-04-11:
object_alias
format file
2022-04-12:
Oracle: Indexes not being used
compilation
cardinality
2022-04-13:
binary data
tabular data
2022-04-14:
ODP.NET / ORA-00911
DTUtil.exe
2022-04-16:
Python: re (regular expresion) examples
2022-04-17:
Koptisch
Python: re.Match
2022-04-18:
NoneType
Python - sqlite3: Select single row (fetchone)
2022-04-19:
Python: using the global statement in modules
2022-04-20:
PEP 249 - Python Database API Specification v2.0
2022-04-21:
EXP_…$
ORA-03297: file contains used data beyond requested RESIZE value
2022-04-24
Reinigungsmittel
2022-04-25:
Using V$SQL_PLAN_MONITOR to count the STARTS in a SORT JOIN operation
2022-04-26:
HTML Living Standard
Using the <video> element to render a webcam stream in a HTML page
Determine the JavaScript Version
Browser object model: navigator
2022-04-30:
structured data
HTML attributes: item*
2022-05-01:
Certificate Signing Request (CSR)
X.500
2022-05-02:
Web APIs
2022-05-04:
Oracle: Example for Adaptive Plan
2022-05-05:
Oracle Plan Operation FILTER for Uncorrelated Subqueries
2022-05-11:
XAMPP: Create and use certificates
2022-05-12:
PARTITION RANGE ITERATOR
2022-05-13:
PART JOIN FILTER CREATE
alter system cancel sql
2022-05-17:
JDK: bin directory
2022-05-18:
TABLE ACCESS BY USER ROWID
2022-05-19:
SP2-0552: Bind variable … not declared.
2022-05-21:
external table
2022-05-24:
Oracle: Capture a job's produced output
Oracle Scheduler: Calendaring Syntax
2022-05-26:
Oracle Scheduler: Events
Oracle Scheduler: Event based job (queue)
2022-05-27:
DBMS_SCHEDULER.GET_FILE
Oracle File-Watcher Example
2022-05-30:
Oracle: Creating a scheduler-program to call a PowerShell script
2022-05-31:
Git: --format | --pretty
Oracle: Deferrable constraints
2022-06-01:
EXTENDED DATA LINK FULL
2022-06-03:
Outlook Object Model: Application
Git: Credentials etc.
2022-06-04:
/proc/sys/fs/binfmt_misc/register
touch.ps1
2022-06-05:
Storage Sense
2022-06-07:
System.Threading.ApartmentState (enum)
CoCreateInstanceEx
COM Apartments
NT_CONSOLE_PROPS
2022-06-10:
PowerShell module NtObjectManager
.NET attributes for caller information
2022-06-12:
Swap ESC and CAPS LOCK with VBA
2022-06-13:
Python library: openai
2022-06-15:
dbms_stats.create_extended_stats
2022-06-23:
Talmud: Seder Kodaschim - Traktat Arachin
2022-06-27:
Baal
2022-06-28:
Excel chart types: Creating a column-clustered chart using a Pivot Table
2022-07-04:
BITMAP INDEX RANGE SCAN
SORT ORDER BY
Oracle SQL Plan operation INDEX MAINTENANCE
2022-07-05:
System.Management.Automation.CommandInvocationIntrinsics
Javascript/CSS: show styles of a given element
text-transform
CSS: min-content, max-content (fit-content)
SVG example: Horizontal bars
2022-07-08:
SVG: styled text
2022-07-09:
Python: printf using ctypes
Python: (some) _io types
2022-07-12:
SVG - foreignObject: HTML embedded in HTML
HTML link element: media query
2022-07-15:
Excel: Page Setup Dialog
2022-07-18:
System.Management.Automation.Host.KeyInfo
2022-07-19:
System.Globalization.RegionInfo
C:\Program Files\Oracle\VirtualBox\UnattendedTemplates
2022-07-21:
DBA_HIST_ACTIVE_SESS_HISTORY: Query begin and end of sessions
WMIC.exe cpu
2022-07-22:
VBoxManage modifyvm
VB Editor: Tools -> References…
2022-07-23:
Vagrant
HKEY_LOCAL_MACHINE\System\LabConfig
C:\Program Files\Oracle\VirtualBox Guest Additions
Git option: safe.directory
2022-07-24:
VBoxManage.exe
2022-07-25:
Rename a Windows computer (change hostname)
Microsoft.PowerShell.Commands.ComputerInfo
2022-07-30:
Windows Settings: System -> Multitasking
2022-07-31:
IWbemServices
mofcomp.exe
2022-08-02:
Chrome profile directory: Login Data
2022-08-03:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\StuckRects3
PowerShell: the preference variable $MaximumHistoryCount
Registry: HKLM|HKCU\Software\Clients\StartMenuInternet
2022-08-04:
VBA module Clipboard
Outlook: Home -> Find
2022-08-07:
System.Diagnostics.Process - WaitForExit()
2022-08-08:
PowerShell module console: get-consoleFont, set-consoleFontSize and set-consoleFontName
2022-08-10:
System.Drawing.FontFamily
Powershell command noun: vsSetupInstance
2022-08-14:
HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Applets\Regedit\Favorites
2022-08-15:
enter-vsDevShell
2022-08-17:
System.IO.Packaging
Oracle: PL/SQL package ZIPPER to create ZIP files
Oracle: PL/SQL package BLOB_WRAPPER
2022-08-20:
Oracle: Execution plan for subquery in WHERE clause
2022-08-20:
System.Net.SecurityProtocolType
2022-08-23:
Registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Defender\Exclusions
2022-08-30:
Microsoft.Extensions.Hosting.Environments
2022-09-05:
Powershell command noun: winAcceptLanguageFromLanguageListOptOut
2022-09-08:
Klitikon
2022-09-10:
query statement
2022-09-11:
Overpass API: functions
2022-09-16:
Overpass Turbo extension for the Overpass API: {{style …}}
2022-09-17:
ISO 6709
2022-09-20:
Oracle: DROP TABLE … CASCADE CONSTRAINT
C:\Program Files\Oracle\VirtualBox Guest Additions
2022-09-20:
$ORACLE_HOME/runInstaller
$ORACLE_HOME/install/orabasetab
2022-09-22:
23c
Oracle SQL hints: use / prevent using indexes in views
2022-09-23:
dbms_mle
2022-09-24:
sumif
2022-09-25:
Overpass Turbo extension for the Overpass API: {{style …}} / Icons
WebAPI: openweathermap
R package: osmplotr
GeoJSON
Leaflet
Overpass API queries
2022-09-26:
v$services
Oracle Database Service
$ORACLE_BASE_HOME
2022-09-27:
Powershell: Param(Parameter(ParameterSetName=…))
Python library: mpmath
Leaflet example: layerGroup with popups
2022-09-28:
Making Overpass-API requests from a webpage
2022-09-29:
HKEY_LOCAL_MACHINE\SOFTWARE[\Wow6432Node]\Microsoft\VisualStudio\14.0\VC\Runtimes[\Debug]{x86|x64|ARM}
ss
2022-09-30:
Oracle Virtual Box: Network / Port forwarding (guest with NAT)
SELinux
package manager
Oracle Virtual Box: Shared folder
2022-10-01:
invoke-restMethod
Formatting SQL statements with PowerShell and the sqlformat.org online API
2022-10-02:
_rowsets_enabled
/var/lib/rpm
2022-10-03:
Python standard library: os.scandir
Leaflet example: placing icons onto a map
2022-10-04:
compile
2022-10-07:
convertTo-CSV
2022-10-08:
Querying the Wikidata SPARQL endpoint with PHP
2022-10-09:
json_decode
2022-10-17:
standard_hash
Javascript/BOM: Demonstration of the asynchronicity of window.fetch()
2022-10-20:
Querying OpenStreetMap data with SPARQL
2022-10-21:
first_rows
2022-10-23:
Cytoscape.js
2022-10-24:
ORA-01422: exact fetch returns more than requested number of rows
ORA-01403: no data found
2022-10-25:
Oracle: Errors ORA-01403 and ORA-01422
2022-10-26:
heat map
2022-10-27:
sys_op_c2c
Python Webserver for CORS compatible HTTP requests
2022-10-29:
PowerShell: Annotating a function with CmdletBinding
2022-10-30:
CSS: flex-* properties
2022-11-01
Oracle Subquery: IN, NOT IN
ORA-22818: subquery expressions not allowed here
ORA-00998: must name this expression with a column alias
2022-11-02:
ORA-14155: missing PARTITION, PARTITIONS, SUBPARTITION, or SUBPARTITIONS keyword
2022-11-03:
Oracle: RESULT_CACHE Tables
2022-11-05:
DBpedia
2022-11-06:
unlink
ORA-00903: invalid table name
2022-11-07:
PHP: ksort
PHP: array_is_list
2022-11-08:
ORA-02292: integrity constraint (…) violated - child record found
2022-11-09:
dba_col_comments
2022-11-10:
$ORACLE_HOME/olap/awm/awm.sh
Oracle: GROUP BY extension CUBE
2022-11-12:
ORA-01733: virtual column not allowed here
ORA-01410: invalid ROWID
2022-11-14:
add_months
ORA-01843: not a valid month
Wikimedia
2022-11-15:
ORA-02436: date or system variable wrongly specified in CHECK constraint
ORA-38101: Invalid column in the INSERT VALUES Clause
2022-11-17:
leading
truncate table
2022-11-18:
window.PublicKeyCredential
2022-11-19:
D3.js - Reading data
2022-11-21:
months_between
CSS - JavaScript example: document.styleSheets
CSSStyleSheet
CSSRule
Experiment: When is JavaScript executed
2022-11-22:
ORA-02438: Column check constraint cannot reference other columns
ORA-54002: only pure functions can be specified in a virtual column expression
2022-11-23:
d3.js - Bar Charts
2022-11-24:
sys_op_map_nonnull
ORA-00957: duplicate column name
2022-11-26:
box-sizing
EventTarget
Element
writing-mode
2022-11-27:
HTMLElement
dataset
2022-11-28:
ORA-01027: bind variables not allowed for data definition operations
ORA-01723: zero-length columns are not allowed
SVG: style element
D3.js: enter merge exit
2022-11-30:
JavaScript: import declaration
2022-12-01:
ORA-24333: zero iteration count
JavaScript library: geodesy
2022-12-02:
Javascript: create all element pairs of an array
Event
CanvasRenderingContext2D
2022-12-03:
HTML element: base
2022-12-04:
<code>
<pre>
white-space
2022-12-05:
DBA_DB_LINKS
Python: str.split() / str.rsplit()
ucd
2022-12-06:
Oracle: SQL statement to find primary-foreign key relations
2022-12-07:
Python library: tabulate
ORA-22992: cannot use LOB locators selected from remote tables
ORA-02021: DDL operations are not allowed on a remote database
2022-12-08:
PLS-00262: incorrect placement of AUTHID clause
replace
2022-12-09:
materialize
ORA-12008: error in materialized view refresh path
ORA-30483: window functions are not allowed here
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
http.proxySSLCAInfo
2022-12-13:
.show
2022-12-15:
ORA-01779: cannot modify a column which maps to a non key-preserved table
HASH JOIN ANTI NA
HASH JOIN SEMI
Oracle Subquery: EXISTS, NOT EXISTS
2022-12-16:
ORA-01732: data manipulation operation not legal on this view
Oracle: DBA_UPDATABLE_COLUMNS
ORA-30926: unable to get a stable set of rows in the source tables
2022-12-17:
CSS: Tables with fixed header
CSS: Table header with vertical text
nth-child
2022-12-18:
lastrowid
2022-12-19:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view
2022-12-20:
Oracle: An alternative for LISTAGG to avoid ORA-01489 / order aggregated values
ORA-12051: ON COMMIT attribute is incompatible with other options
2022-12-21:
replace
VBoxManage unattended
2022-12-22:
ORA-01731: circular view definition encountered
ORA-00920: invalid relational operator
ORA-14039: partitioning columns must form a subset of key columns of a UNIQUE index
2022-12-23:
Outlook: File -> Options -> Mail
ORA-01481: invalid number format model
2022-12-25:
/dev/vcs
2022-12-26:
/etc/X11/default-display-manager
2022-12-31:
pkg-config
See also
log: 2021
Index