Welcome to Programmers Language v2

ID: 243
PlCodelang: Bash Script
PlGroup: Datum, Zeit
PlItemTitle: Gestriges Datum
Code: #!/bin/sh myDate=$(date +"%Y-%m-%d" -d "yesterday") echo $myDate # 2014-01-13 myDate2=$(date -d @$(( $(date +"%s") - 86400)) +"%Y-%m-%d") # 014-01-13 # today: $(date +"%Y-%m-%d") # 2014-01-14 # Hint: -d parameter doesn't work on Solaris

ID: 244
PlCodelang: T-SQL
PlGroup: Datenbank
PlItemTitle: SQL SELECT Statische Werte
Code: SELECT * FROM ( VALUES (1, 2), (3, 4) ) AS q (col1, col2) GO -- the same as: SELECT 1 AS col1, 2 AS col2 UNION ALL SELECT 3 AS col1, 4 AS col2 GO -- col1 | col2 -- =========== -- 1 | 2 -- ----------- -- 3 | 4

ID: 245
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: SQL SELECT Statische Werte
Code: SELECT * FROM ( VALUES (1, 2), (3, 4) ) AS q (col1, col2) ; -- the same as: SELECT 1 AS col1, 2 AS col2 UNION ALL SELECT 3 AS col1, 4 AS col2 ; -- col1 | col2 -- =========== -- 1 | 2 -- ----------- -- 3 | 4

ID: 246
PlCodelang: Bash Script
PlGroup: Filehandling
PlItemTitle: Filename-Manipultation Basics
Code: #!/bin/sh myFilename="$1" # or myFilename="/tmp/Test/myFile.txt" # Get only the path path_only=$(dirname "$myFilename") # /tmp/Test # if it is a local file in the path, then . will be prompted e.g. myFilename="myFile.txt" # Filename only filename_only=$(basename "$myFilename") # myFile.txt # get only filename without extention filename_without_ext="${filename_only%.*}" # myFile # get only the extension filename_extention_only="${myFilename##*.}" # txt # put them together again myFilename_together="${path_only}/${filename_without_ext}.${filename_extention_only}" # /tmp/Test/myFile.txt

ID: 247
PlCodelang: ORACLE PL/SQL
PlGroup: Datenbank
PlItemTitle: CSV erstellen
Code: SELECT FieldA, LISTAGG(CSVItem, ',') WITHIN GROUP (ORDER BY FieldA) AS Members FROM TableWithItems GROUP BY FieldA;

ID: 248
PlCodelang: PowerShell
PlGroup: Fallunterscheidung
PlItemTitle: Ternary operator
Code: ## Example from here: https://www.kongsli.net/2012/02/23/powershell-another-alternative-to-ternary-operator/ $thisVar='OK' $resultVar = @{$true=1;$false=2}[$thisVar -eq 'OK'] // same as if-else construction if ($thisVar -eq 'OK') { $resultVar = 1; } else { $resultVar = 2; }

ID: 249
PlCodelang: Python
PlGroup: Systeminfo
PlItemTitle: Betriebssystem ermitteln
Code: import os os.name # nt, posix import platform platform.system() # 'Windows', 'Linux', 'Darwin' platform.release() # Linux, Windows, Windows, Darwin '2.6.22-15-generic', 'Vista' ,'10', '8.11.1' # Example from https://stackoverflow.com/questions/1854/python-what-os-am-i-running-on from sys import platform as _platform if _platform == "linux" or _platform == "linux2": # linux elif _platform == "darwin": # MAC OS X elif _platform == "win32": # Windows elif _platform == "win64": # Windows 64-bit

ID: 250
PlCodelang: PHP
PlGroup: Strings
PlItemTitle: Erster Buchstable Groß in Wort
Code: $myString = "nothingspecial"; $uc = ucwords($myString); echo $uc; // Nothingspecial

ID: 251
PlCodelang: Python
PlGroup: Strings
PlItemTitle: Erster Buchstable Groß in Wort
Code: # Siehe auch: http://www.php2python.com/wiki/function.ucwords/ myString = "nothingspecial" import string uc = string.capwords(myString) print(uc) # Nothingspecial

ID: 252
PlCodelang: Python
PlGroup: Dateihandling
PlItemTitle: Textdatei schreiben
Code: # Modes # r: Read mode which is used when the file is only being read # w: Write mode which is used to edit and write new information to the file (any existing files with the same name will be erased when this mode is activated) # a: Appending mode, which is used to add new data to the end of the file; that is new information is automatically amended to the end # r+: Special read and write mode, which is used to handle both actions when working with a file myFile = open("myFile.txt","w") myFile.write("Hello World") myFile.close()