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 31-40 of 300 results.

ID	PlCodelang	PlGroup	PlItemTitle	Code

219	ORACLE PL/SQL	Datenmengen	Anzahl Zeilen Resultset begrenzen	SELECT * FROM ( SELECT * FROM tableA ) WHERE ROWNUM <= 100
247	ORACLE PL/SQL	Datenbank	CSV erstellen	SELECT FieldA, LISTAGG(CSVItem, ',') WITHIN GROUP (ORDER BY FieldA) AS Members FROM TableWithItems GROUP BY FieldA;
201	Excel	Strings	Replace	/* Cell A1 contains text "abc#def" / =SUBSTITUTE(A1;"";"/") /* Result will be: "abc/def" */
182	Batch	Variablen	Deklaration einer Variable	@echo off SET myVariable=This is my content SET myPathVariableWithBlanks="C:\Temp\Path With Blanks\File.txt" echo %myVariable% REM This is my content echo %myPathVariableWithBlanks% REM "C:\Temp\Path With Blanks\File.txt"
183	Batch	Variablen	Wert einer Variable zuweisen	@echo off cd C:\Temp REM Aktuelles Verzeichnis in einer Variable setzen SET mydir="Mein Verzeichnis lautet %CD%" echo %mydir% REM "Mein Verzeichnis lautet C:\Temp"
184	Batch	Filehandling	Prüfen ob Datei existiert	@echo off SET checkFileExists="C:\Temp\myFile.txt" IF exist %checkFileExists% GOTO :EXISTS GOTO :EXISTSNOT :EXISTS echo There it is :-) GOTO :END :EXISTSNOT echo Sorry, the file isn't there :-( GOTO :END :END echo End of program
198	Batch	Konsolenverwaltung	Einlesen Konsoleneingabe	@echo off SET mydir=%CD% set /p number=search this number?: echo %number% > "%mydir%\lastnumbersearched.txt" echo dir/b/s %number%.* echo. echo. dir/b/s %number%.* echo. echo. pause
149	Perl	Datum, Zeit	Jahr aus Datum extrahieren	use POSIX qw/EXIT_SUCCESS EXIT_FAILURE/; # Datum Vorbereitung: my $DateTime = POSIX::strftime('%c', localtime(time)); my ($Date, $Time) = split(/\s+/, $DateTime); my ($Day, $Month, $Year) = split(/\./, $Date); my ($Hour, $Minute, $Second) = split(/:/, $Time ); my $Datum = "$Year"."$Month"."$Day"; #oder # my $Datum = "$Day"."$Month"."$Year"; my $Uhrzeit = "$Hour".":"."$Minute".":"."$Second";
142	JavaScript	URL-Handling	Aktuelle URL bekommen	// http://www.w3.org/TR/DOM-Level-2-HTML/html.html#ID-46183437 myURL = document.URL; // => http://myDNSNameOrIP:1234/path/testfile.html
143	JavaScript	URL-Handling	Domain und Port einer URL	domainAndPort = document.URL.split("/")[2]; // => 192.168.1.100:1234 // => myDNSname.com:6789