Manage PlItems

You may optionally enter a comparison operator (<, <=, >, >=, <> or =) at the beginning of each of your search values to specify how the comparison should be done.

Advanced Search

Displaying 271-280 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

247	ORACLE PL/SQL	Datenbank	CSV erstellen	SELECT FieldA, LISTAGG(CSVItem, ',') WITHIN GROUP (ORDER BY FieldA) AS Members FROM TableWithItems GROUP BY FieldA;
256	PowerShell	Textdateien	TextDatei auslesen	$myFilename = "file.txt" $fileContent = (Get-Content $myFilename)
257	PowerShell	Schleifen	For-Schleife	$elements ="A;B;C" $elements.Split(";") \| ForEach-Object { write-host $_ } Write-Host " - Next example -" $elements ="D;E;F" ForEach ($element in $elements.Split(";")) { Write-Host $element }
258	PowerShell	Exceptions	Try Catch Except	$DirectoryName = "C:\Temp\rename_test_new" Try { $newDirectoryName = $DirectoryName -replace "_new", "_old" Rename-Item -path $DirectoryName -newName $newDirectoryName } Catch { Write-host "Error. Exit!" Write-Error $_.Exception.Message exit # Wenn das Script hart beendet werden soll, dann kann exit verwendet werden }
259	PowerShell	Strings	Multiline String Variable	# In PowerShell such variables are called: Here-Strings $mySQLString = @" SELECT 1 FROM dbo.TestTable WHERE 1=1 "@
267	PowerShell	Array	Dictionary Basics	# empty Hashtable $myDict = @{} # some static values $myDict.Add("key1", "value1") $myDict.Add("key2", "valueY") $myDict.Add("keyX", "value98") # update a key programmatically $myDict.Remove("key1") $myDict.Add("key1", "new value") # iterate Foreach ($key in $myDict.keys) { $strKey = $key $strValue = $Parameter[$key] } # Exists If ($myDict.ContainsKey("key1") -eq $true) { write-host "yes" } # get an specific item $subdict = $myDict("key2") # valueY
278	PowerShell	Filehandling	Prüfen ob Verzeichnis existiert	$myFolder = "C:\TEMP" if ((Test-Path $myFolder) -eq $true) { write-host "Folder exists!" } else { write-host "Folder doesn't exist!" }
282	PowerShell	Datum, Zeit	Gestriges Datum	$d=(Get-Date).AddDays(-1) $output=Get-Date $d -format "yyyy-MM-dd" # 2014-02-27
227	PowerShell	Systeminfo	Hostnamen ermitteln	$myHostname = [system.environment]::MachineName; write-host $myHostname; # prints MyComputer1 or srvWindows2
228	PowerShell	Strings	Replace	$str1 = "abc#def"; $str1 = $str1.Replace("#",";"); write-host $str1; # Output: abc;def