SEMrush
adp-gmbh.ch

Please wait for loading...




    SEMrush

      (526):

    /
     1  ~ 2014 jul 16leer csv en htmlFilling a HTML table with values of a CSV filenumber:Int,english,french,german 1,one,un,eins 2,two,deux,zwei 3,three,trois, drei 4,four,quattre,four 5,five,cinque,fuenf 6,six,six,sechs 7,seven,sept,sieben 8 ...
     2  ~ 2014 oct 03connect by oracleSTART WITH and CONNECT BY in Oracle SQLThe start with .. connect by clause can be used to select data that has a ... If Oracle encounters such an SQL statement, it proceeds as described in the following ...
     2  ~ 2014 sep 14connect bystart with initial-condition connect by nocycle recurse-condition select ... The start with .. connect by clause can be used to select data that has a ...
     3  +2 2014 sep 29create database in oracleCreating an Oracle 10g database from the command line onlyThis article is the successor to Creating an Oracle 9i database on NT from the command line only. There are basically three ways to create an Oracle database : .
     3  +3 2014 sep 12perl mktimeConverting unix time and readable time with PerlConverting unix time and readable time with Perl ... my $wday = 0; my $yday = 0; my $unixtime = mktime ($sec, $min, $hour, $day, $mon, $year, $wday, $yday); ...
     3  +4 2014 sep 07no cycleconnect by nocycle [Oracle] - René Nyffenegger on Oracleinsert into directed_graph values ('A', 'C'); insert into directed_graph values ('A', 'B '); insert into directed_graph values ('B', 'E'); insert into directed_graph values ...
     3  +6 2014 aug 30apache log analyzer scriptParsing apache log files with Perl - René Nyffenegger on OracleThe following is a webalizer written in perl to analyze apache log files. Currently, four options can (should) be given when invoking the script : -n <number> prints the top <number> accessed documents,. #! ... Other log analyzers (or parsers).
     3  +71 2014 aug 23scrolling div javascriptScrolling a div with JavaScript - René Nyffenegger on Oracle<html> <head><title> Scrolling a DIV with JavaScript </title> <script language=' javascript '> function move_up() { scroll_clipper.scrollTop = 0; } </script> </head>  ...
     4  -1 2014 oct 05set serveroutput onset serveroutput [SQL*pluS] - René Nyffenegger on Oracleset serveroutput on set serveroutput off set serveroutput on size n set serveroutput on format word_wrapped set serveroutput on format truncated set ...
     4  ~ 2014 sep 30pl sql forLoops with PL / SQL - René Nyffenegger on Oraclebegin <<i_loop>> for i in 1 .. 10 loop <<j_loop>> for j in 1 .. 10 loop dbms_output. put(to_char(j, '999')); exit j_loop when j=i; end loop; dbms_output.new_line; end ...
     4  ~ 2014 sep 25authidauthid current_user vs pragma authid DefinerA stored procedure runs either with the rights of the caller ( authid current_user) or with the rights of the procedure's owner ( authid definer). This behaviour is ...
     4  +11 2014 sep 02javascript add daysAdding and subtracting days in JavaScriptvar today =new Date(); var in_a_week =new Date().setDate(today.getDate()+7); var ten_days_ago=new Date().setDate(today.getDate()-10);
     4  +21 2014 aug 11oracle create database
     5  +3 2014 sep 08oracle substrsubstr [ Oracle SQL] - René Nyffenegger on OracleThe position parameter indicates where the substring starts. It's not zero indexed, that is, in order to start with the fourth character, the parameter has to be 4:.
     5  +2 2014 aug 28drop table cascadedrop table [Oracle SQL] - René Nyffenegger on Oracledrop table table_name; drop table table_name cascade constraints; drop table ... The drop table command moves a table into the recycle bin unless purge was ...
     5  +3 2014 aug 18perl apache log parserusr/bin/ perl -w use strict; use Getopt::Std; open ( LOG , "/var/ log /httpd/adp-gmbh/ xlf_log"); my $options = {}; # n how many urls? # r print referers? # f print from ...
     5  +12 2014 aug 04telefonbuch der schweizStatistiken über das Telefonbuch der SchweizEin Eintrag im Telefonbuch ist entweder ein Business oder Residential (= privat). Die folgende Tabelle zeigt die Anzahl von Einträgen nach Eintragsart ...
     5  +17 2014 aug 04create database oracle
     5  -2 2014 jul 29oracle comment on columncomment [ Oracle SQL] - René Nyffenegger on Oraclecolumn comments format a50 select table_name, comments from user_tab_comments where table_name like 'SOME%';. TABLE_NAME COMMENTS  ...
     6  -1 2014 sep 27oracle tablespaceTablespaces [ Oracle ] - René Nyffenegger on OracleA tablespace is a logical storage unit within an Oracle database. It is logical because a tablespace is not visible in the file system of the machine on which the  ...
     6  -1 2014 sep 19hide table columnsHiding a column in a table with JavaScript<html> <head> <script> function show_hide_column(col_no, do_show) { var stl; if (do_show) stl = 'block' else stl = 'none'; var tbl = document.
     6  +21 2014 aug 20php passing by referencePHP : Pass by reference vs. Pass by valueThe code above prints 1, 2, 3, 4, 5. This is because the array is passed as reference , meaning that the function (pass_by_reference) doesn't manipulate a copy ...
     6  +2 2014 aug 12create table oraclecreate table [ Oracle SQL] - René Nyffenegger on OracleFor a user to be able to create a table, he needs the create table system privilege, otherwise he'll receive the ORA-01031: insufficient privileges error message.
     6  +3 2014 aug 01drop table in oracledrop table [ Oracle SQL] - René Nyffenegger on OracleNormally, a table is moved into the recycle bin (as of Oracle 10g), if it is dropped . However, if the purge modifier is specified as well, the table is unrecoverably ...
     6  +3 2014 jul 26oracle data types doubleDatatypes in Oracle - René Nyffenegger on OracleIn addition to the internal datatypes , Oracle also knows the following datatypes within PL/SQL: binary_double; binary_float; dec; decimal; double precision; float  ...
     7  -2 2014 sep 28javascript div scrollbar
     7  +94 2014 aug 19backup control filealter database in Oracle - René Nyffenegger on Oraclein Oracle. Whenever the database is altered, the control file should be backed up. ... alter database backup controlfile to ['filename' | trace]. This command ...
     7  ~ 2014 aug 18oracle for loopLoops with PL/SQL - René Nyffenegger on Oraclebegin <<i_loop>> for i in 1 .. 10 loop <<j_loop>> for j in 1 .. 10 loop dbms_output. put(to_char(j, '999')); exit j_loop when j=i; end loop ; dbms_output.new_line; end ...
     7  +3 2014 aug 11oracle create table
     7  +4 2014 jul 28create user oracleCreate user [ Oracle SQL] - René Nyffenegger on OracleIn the most simple form, the create user statement is one of the following three: create user alfredo identified by alfredos_secret; create user alfredo identified ...
     7  ~ 2014 jul 16sql errors whowShow [ SQL *Plus] - René Nyffenegger on Oracleshow all show system-variable show errors show errors [function|procedure| package|package body|trigger|view|type|type body|dimension|java class ...
     8  +3 2014 sep 30ora 00942 table or view does not existORA - 00942 : table or view does not exist - René Nyffenegger on Sometimes, when a view or a procedure is created that accesses a table, Oracle issues the error ORA - 00942 : table or view does not exist , although this table (or ...
     8  -3 2014 sep 18oracle explain planOracle's explain plan - René Nyffenegger on OracleOne of Oracle's task when it receives such a statement is to build a query execution plan . An execution plan defines how Oracle finds or writes the data.
     8  +35 2014 aug 31javascript date add daysvar today =new Date (); var in_a_week =new Date ().setDate(today.getDate()+7); var ten_days_ago=new Date ().setDate(today.getDate()-10);
     8  +4 2014 jul 28sql make directoryCreate directory in Oracle - René Nyffenegger on Oraclecreate directory some_dir; grant read, write on directory some_dir to micky_mouse; ... See also On reading trace files with PL/ SQL where a directory is used to ...
     8  +93 2014 jul 24html table hiddenUsing getElementById and setting the style to display:block and display:none respectively, it is possible to selectively show or hide html elements (such as entire ...
     8  +24 2014 jul 24javascript scroll div
     8  ~ 2014 jul 23oracle lead lagLAG analytic function in Oracle SQL - René Nyffenegger on Oraclelag is an Analytical function that can be used to get the value of an attribute of the previous row. If you want to retrieve the value of the next row, use lead instead ...
     9  +1 2014 oct 04database acid propertiesACID properties of databases - René Nyffenegger on OracleModification on the data in the database either fail or succeed. The beginning of such a modification starts with a transaction and ends when a transaction ...
     9  -5 2014 sep 20sqlplus startupstartup [SQL*Plus] - René Nyffenegger on Oraclestartup startup nomount startup mount startup restrict startup open recover startup pfile = /path/to/init.ora. startup starts (creates) an Oracle instance. While the ...
     9  -2 2014 sep 16execute immediateExecute Immediate - René Nyffenegger on Oracleexecute immediate 'sql-statement'; execute immediate 'select-statement' into returned_1, returned_2..., returned_n; execute immediate 'sql-statement' using ...
     9  +1 2014 aug 26csv to html tableFilling a HTML table with values of a CSV file. With Internet Explorer, it is possible to read a csv file (which resides on the web server) into a HTML table .
     9  +7 2014 aug 10sql for loopLoops with PL/ SQL - René Nyffenegger on Oracle
     9  +12 2014 aug 03javascript date add day
     9  +10 2014 jul 26oracle for updatePL/SQL: Cursor for Update Example - René Nyffenegger on Oracleset feedback off create table f (a number, b varchar2(10)); insert into f values (5,' five'); insert into f values (6,'six'); insert into f values (7,'seven'); insert into f ...
     9  +34 2014 jul 24parsing httpd logsusr/bin/perl -w use strict; use Getopt::Std; open ( LOG , "/var/ log / httpd /adp-gmbh/ xlf_log"); my $options = {}; # n how many urls? # r print referers? # f print from ...
     9  ~ 2014 jul 20oracle sql explainWhenever you read or write data in Oracle , you do so by issuing an SQL statement. One of Oracle's task when it receives such a statement is to build a query ...
     10  +1 2014 sep 30sqlplusSQL*Plus - René Nyffenegger on Oraclesqlplus username/password@net_service_name sqlplus username/password sqlplus sys/password@net_service_name as sysdba sqlplus sys/password as ...
     10  +2 2014 sep 14dll cCreating a dll with MinGW - René Nyffenegger on OracleIn MinGW, DLLs are basically created with the -shared option to gcc. In order to turn the following file into a dll , issue a gcc -Wall -shared mingw_dll. c -o ...
     10  +5 2014 sep 12oracle startup pfileThe pfile =init.ora indicates the location and name of the init.ora file that the instance reads when it is started. This method is used when the init.ora file is to be ...
     10  +36 2014 sep 08oracle xml dbOracle XML DB installation - René Nyffenegger on OracleXML DB can be installed with the database configuration assistant (dbca) or by calling the catqm.sql script. catqm stands for catalog script for sQl xMl  ...
     10  +24 2014 sep 08top n in sqlSelecting the first n rows with Oracle - René Nyffenegger on OracleSometimes, someone is tempted to select the first n rows of a table. In order to demonstrate that, the following table is created and populated: set feedback off ...
     10  +33 2014 aug 24comment sql oraclecomment [ Oracle SQL ] - René Nyffenegger on Oraclecomment on table some_table is 'some hopefully meaningful comment for some_table'; comment on table some_view is 'Views can also be commented, yet the ...
     10  +60 2014 aug 05oracle xml database
     10  +91 2014 jul 30sql connect statementThe start with .. connect by clause can be used to select data that has a ... If Oracle encounters such an SQL statement , it proceeds as described in the following ...
     10  +22 2014 jul 25perl web serverA webserver with Perl - René Nyffenegger on Oraclewebserver .pl is the core, so to speak, that accepts new connections and creates a thread for each connection. http_handler.pl is the file that actually defines what ...
     11  +13 2014 oct 02insert with selectOracle SQL: Insert with Select and Subqueryset feedback off; set pagesize 0; create table foo (a number, b varchar(10), c varchar(10)); insert into foo values ( 15, 'abc','def' ); insert into foo values (998, ' max' ...
     11  -6 2014 sep 26javascript hidden table
     11  ~ 2014 sep 22csv htmlFilling a HTML table with values of a CSV file. With Internet Explorer, it is possible to read a csv file (which resides on the web server) into a HTML table.
     11  -1 2014 sep 15perl win32 oleWord and PERL - René Nyffenegger on Oracleuse warnings; use strict; use Win32 :: OLE ; use Win32 :: OLE ::Const 'Microsoft.Word '; # wd constants use Win32 :: OLE ::Const 'Microsoft Office'; # mso constants my ...
     11  +65 2014 aug 29create or replace tablecreate table [Oracle SQL] - René Nyffenegger on OracleFor a user to be able to create a table , he needs the create table system privilege, otherwise ... create or replace type item as object ( item_id Number ( 6 ), descr ...
     11  +90 2014 aug 21alter database end backupalter database datafile 'DF' end backup . This command can be used for a hot backup. Note:There is no alter database datafile 'DF' begin backup command.
     11  +90 2014 jul 26loop statement in sqlCursor for loop . for rec in (select col_1, col_2 from table_a) loop /* Statements , use rec.col_1 and rec.col_2 */ end loop ;. for rec in cursor_name loop /* Statements , ...
     12  +3 2014 sep 24perl grep fileRecursive find and grep with perl - René Nyffenegger on OracleI find it unbelievable how hard it is to grep recursively on a windows system in files . There are many times I wished I had had something like grep and find on ...
     12  -8 2014 sep 20graphviz output file sizegraphviz [dot and/or neato] - René Nyffenegger on OracleIt basically takes an (textual) input file (for example this dot file ) that declaratively describes the graph and convertes it into a viewable output format (such as ... it is possible to retrieve the coordinates of the nodes as well as their dimensions .
     12  -5 2014 sep 18javascript hide tr in tableHiding a column in a table with JavaScript ... var rows = tbl. getElementsByTagName(' tr '); for (var row =0; row <rows.length;row++) { var cels = rows[ row ].
     12  +2 2014 sep 13csv hml
     12  +10 2014 sep 11shutdown immediateshutdown [SQL*Plus] - René Nyffenegger on Oracleshutdown shutdown abort shutdown immediate shutdown normal shutdown ... Shutting down an instance (and closing the database that is mounted on the ...
     12  ~ 2014 aug 29php function parameters reference
     12  -1 2014 aug 23oracle export tablespaceexp and imp in Oracle - René Nyffenegger on OracleIf the data is exported on a system with a different Oracle version then on that on which it is ... Use the tablespaces export parameter for a tablespace export .
     12  +9 2014 aug 01picture style perlmy $heading_1 = $document-> Styles ("Heading 1"); my $ heading_1_font = $heading_1 -> Font; $heading_1_font -> {Name} = "Bookmann "; ...
     12  ~ 2014 jul 24oracle query plan
     13  +8 2014 oct 02oracle sql decodedecode [ Oracle SQL ] - René Nyffenegger on Oracledecode [ Oracle SQL ]. decode (expression, search_1, result_1) decode ( expression, search_1, result_1, search_2, result_2) decode (expression, search_1, ...
     13  +1 2014 sep 19shell basenamebasename [Unix shell ] - René Nyffenegger on Oraclebasename /abc/def/ghi.txt ghi.txt. $ basename ghi.txt ghi.txt. $ basename ghi.txt . txt ghi. $ basename /abc/def/ghi.txt .txt ghi.
     13  -3 2014 sep 18css expressionUsing expression in CSS - René Nyffenegger on OracleThe following example demonstrates how expression can be used in CSS to lock a column of table on the left side: <html> <head> <title>Some Title</title> ...
     13  -6 2014 sep 16explain plan
     13  ~ 2014 sep 14sql plusSQL * Plus - René Nyffenegger on OracleUnfortunately, there is no built in history functionality in SQL * PLUS that would allow to go back a number of commands issued in SQL * PLUS . However, there is  ...
     13  +7 2014 sep 11grant create session to userORA-01045: user ... lacks CREATE SESSION privilege; logon deniedlacks CREATE SESSION privilege; logon denied ... someone this privilege, use: grant create session to the_user;. See also other Oracle ...
     13  +88 2014 aug 30c encode stringEncoding and decoding base64 with C++base64.cpp and base64.h Copyright ( C ) 2004-2008 René Nyffenegger This source code ... std:: string base64_encode(unsigned char const* bytes_to_encode , ...
     13  +24 2014 aug 15extract urls from textExtracting URLs from text with PERL - René Nyffenegger on OracleThis is an attempt for a script to extract urls from text with Perl. The script recognizes an URL if it either starts with
     14  +2 2014 sep 23schweizer telefonbuch
     14  +12 2014 sep 05imp and export entire databaseThat means, if something needs to be exported from 10g into 9i, it must be exported with 9i's exp. imp doesn't re-create an already existing table . It either errors ...
     14  +11 2014 aug 23oracle number formatNumber format elements [ Oracle SQL] - René Nyffenegger on Oraclecreate table some_numbers ( n1 number , n2 number , n3 number , n4 number , n5 number , n6 number , n7 number ); create table some_formats (f varchar2(25));.
     14  +87 2014 jul 17create or replace packageCreate procedure [Oracle SQL] - René Nyffenegger on Oraclecreate or replace procedure proc_name ([arg_1 in some-datatypes [,...]]) as variable-declarations begin do_stuff; end proc_name; /
     15  +3 2014 sep 28echo is offset echo [SQL*Plus] - René Nyffenegger on Oracleset echo on | off . With echo it is possible to control if echoing of SQL statements and SQL*Plus commands is enabled or not. If echo is set to off , SQL statements ...
     15  +56 2014 sep 27div scrolltop<html> <head><title>Scrolling a DIV with JavaScript</title> <script language=' javascript'> function move_up() { scroll_clipper. scrollTop = 0; } </script> </head>  ...
     15  -4 2014 sep 26what are css expressions
     15  +1 2014 aug 29csv to tableWith Internet Explorer, it is possible to read a csv file (which resides on the web server) into a HTML ... The following file (data. csv ) will be read into the table :.
     15  +13 2014 aug 20div move with scroll<html> <head><title> Scrolling a DIV with JavaScript</title> <script ... </head> < body> <a href='javascript:move_up()'> Move UP</a> <p> < div id='scroll_clipper' ...
     15  +33 2014 aug 05oracle sysdba passwordConnecting AS SYSDBA /SYSOPER [ Oracle ]A user must connect AS SYSDBA or AS SYSOPER if he wants to perform ... Altough I have connected myself as Rene, giving my (not sys') password , I am sys :.
     16  -1 2014 sep 28javascript hide table rowsgetElementsByTagName(' tr '); for (var row =0; row < rows .length;row++) { var cels = rows [ row ].getElementsByTagName('td') cels[col_no].style.display=stl; } ...
     16  -5 2014 sep 27div scrolling<html> <head><title> Scrolling a DIV with JavaScript</title> <script language=' javascript'> function move_up() { scroll_clipper.scrollTop = 0; } </script> </head>  ...
     16  -3 2014 sep 27oracle modmod [ Oracle SQL] - René Nyffenegger on Oraclemod (m,n). mod (=modulus) returns the reminder of m devided by n. If m = 0, it returns 0, if n = 0, it returns m. create table mod_exp ( m number(2), n number(2) ) ;.
     16  -1 2014 sep 17c dll
     16  +13 2014 sep 15oracle create synonymcreate synonym [ Oracle SQL] - René Nyffenegger on Oraclecreate synonym synonym-name for object; create public synonym synonym- name for object;. The object for which a synonym is created does not necessarily  ...
     16  +85 2014 jul 28top sql oracleset feedback off create table items ( id number primary key, name varchar2(20), price number(7,2) ); insert into items values ( 1, 'cup', 1.20); insert into items ...
    1 2 of 6 pages    




    SEMrush