{"id":104,"date":"2010-09-14T18:08:59","date_gmt":"2010-09-14T18:08:59","guid":{"rendered":"http:\/\/nestor.nestasoft.fr\/?p=104"},"modified":"2011-05-10T15:11:58","modified_gmt":"2011-05-10T15:11:58","slug":"quelques-fonctions-pour-sgbdrs","status":"publish","type":"post","link":"https:\/\/nestasoft.fr\/?p=104","title":{"rendered":"Quelques fonctions pour SGBDRs"},"content":{"rendered":"<p><img decoding=\"async\"  width=\"30%\" class=\"alignleft\" title=\"Virus\" src=\"http:\/\/www.nestor.nestasoft.fr\/wp-content\/uploads\/2010\/09\/DBR_overview2.gif\" alt=\"Database\" \/><\/p>\n<p>Bonjour et bienvenue sur ce nouveau tour d&rsquo;horizon. Je vais vous pr\u00e9senter quelques fonctions permettant de manipuler les SGBRs (Syst\u00e8me de Gestion de Base de Donn\u00e9es Relationnalles).<\/p>\n<p><!--more--><br \/>\n<br \/>\n<font color=\"blue\"><\/p>\n<h2>Sommaire<\/h2>\n<ul>\n<li type=\"square\">\n<a href =\"#fn\" name=\"1\" >Quelques fonctions num\u00e9riques<\/a><\/li>\n<li type=\"square\"><a href=\"#ft\" name=\"2\">Quelques fonctions temporelles<\/a><\/li>\n<li type=\"square\"><a href=\"#ag\" name=\"3\">Agr\u00e9gation<\/a><\/li>\n<li type=\"square\"><a href=\"#fs\" name= \"4\">Quelques fonctions syst\u00e8mes<\/a><\/li>\n<\/ul>\n<p><\/font><\/p>\n<hr size=\"2\" color=\"black\">\n<p>On en trouve des tas et des tas de fonctions manipulant les bases de donn\u00e9es, cette liste sera mis \u00e0 jour au fur et \u00e0 mesure.<\/p>\n<h4>\n<table bordercolor=\"\">\n<tr>\n<th bgcolor=\"black\" ><a href=\"#1\" name=\"fn\"><font color=\"black\">Quelques fonctions num\u00e9riques<\/font><\/a><\/td>\n<\/tr>\n<\/table>\n<\/h4>\n<p><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col span=\"8\" width=\"80\"><\/col>\n<\/colgroup>\n<tbody>\n<tr height=\"28\" bgcolor=\"#C1CCFD\">\n<th width=\"80\" height=\"28\">Fonction<\/th>\n<th width=\"80\">Description<\/th>\n<th width=\"80\">Access<\/th>\n<th width=\"80\">MySQL<\/th>\n<th width=\"80\">SQL Server<\/th>\n<th width=\"80\">Oracle<\/th>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">ASIN<\/td>\n<td width=\"80\">Angle   de sinus<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">ATAN<\/td>\n<td width=\"80\">Angle   de tangente<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">ROUND<\/td>\n<td width=\"80\">Arrondi<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"58\">\n<td width=\"80\" height=\"58\">ASCII<\/td>\n<td width=\"80\">Conversion   de caract\u00e8re en code ASCII<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"58\">\n<td width=\"80\" height=\"58\">UNICODE<\/td>\n<td width=\"80\">Conversion   de caract\u00e8re en code UNICODE<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">?<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">COS<\/td>\n<td width=\"80\">Cosinus<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">COT<\/td>\n<td width=\"80\">Cotangente<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">POWER<\/td>\n<td width=\"80\">El\u00e9vation   \u00e0 la puissance<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">EXP<\/td>\n<td width=\"80\">Exponentielle<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">LOG10<\/td>\n<td width=\"80\">Logarithme   d\u00e9cimal<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"44\">\n<td width=\"80\" height=\"44\">LOG(n,m)<\/td>\n<td width=\"80\">Logarithme   en base n de m<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">LN<\/td>\n<td width=\"80\">Logarithme   n\u00e9p\u00e9rien<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">LOG<\/td>\n<td width=\"80\">Logarithme   n\u00e9p\u00e9rien<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">%<\/td>\n<td width=\"80\">Modulo<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">MOD<\/td>\n<td width=\"80\">Modulo<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"58\">\n<td width=\"80\" height=\"58\">+ &#8211; * \/ ( )<\/td>\n<td width=\"80\">Op\u00e9rateurs   et parenth\u00e9sage<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">PI<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">SQRT<\/td>\n<td width=\"80\">Racine   carr\u00e9e<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">SIGN<\/td>\n<td width=\"80\">Signe<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">SIN<\/td>\n<td width=\"80\">Sinus<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">TAN<\/td>\n<td width=\"80\">Tangente<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">TRUNC<\/td>\n<td width=\"80\">Troncature<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">TRUNCATE<\/td>\n<td width=\"80\">Troncature<\/td>\n<td width=\"80\"><\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">ABS<\/td>\n<td width=\"80\">Valeur   absolue<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">RAND<\/td>\n<td width=\"80\">Valeur   al\u00e9atoire<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"44\">\n<td width=\"80\" height=\"44\">FLOOR<\/td>\n<td width=\"80\">Valeur   approch\u00e9e basse<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"44\">\n<td width=\"80\" height=\"44\">CEILING<\/td>\n<td width=\"80\">Valeur   approch\u00e9e haute<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>\n<table bordercolor=\"\">\n<tr>\n<th bgcolor=\"\" width=\"\"><a href=\"#1\" name=\"ft\"><font color=\"black\">Quelques fonctions temporelles<\/font><\/a><\/td>\n<\/tr>\n<\/table>\n<\/h4>\n<p><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\" width=\"560\">\n<tbody>\n<tr bgcolor=\"#C1CCFD\">\n<th width=\"114\" valign=\"bottom\"><strong>Fonction<\/strong><\/th>\n<th width=\"114\" valign=\"bottom\"><strong>Description<\/strong><\/th>\n<th width=\"67\" valign=\"bottom\"><strong>Access<\/strong><\/th>\n<th width=\"67\" valign=\"bottom\"><strong>MySQL<\/strong><\/th>\n<th width=\"66\" valign=\"bottom\"><strong>SQL   Server<\/strong><\/th>\n<th width=\"66\" valign=\"bottom\"><strong>Oracle<\/strong><\/th>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">ADDDATE<\/td>\n<td width=\"114\" valign=\"bottom\">Ajout d&rsquo;intervalle \u00e0 une date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">AGE<\/td>\n<td width=\"114\" valign=\"bottom\">Age<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DATE_ADD<\/td>\n<td width=\"114\" valign=\"bottom\">Ajout d&rsquo;intervalle \u00e0 une date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DATE_FORMAT<\/td>\n<td width=\"114\" valign=\"bottom\">Formatage de date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DATE_PART<\/td>\n<td width=\"114\" valign=\"bottom\">Partie de date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DATE_SUB<\/td>\n<td width=\"114\" valign=\"bottom\">Retrait d&rsquo;intervalle \u00e0 une date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DATEADD<\/td>\n<td width=\"114\" valign=\"bottom\">Ajout de date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DATEDIFF<\/td>\n<td width=\"114\" valign=\"bottom\">Retrait de date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DATENAME<\/td>\n<td width=\"114\" valign=\"bottom\">Nom d&rsquo;une partie de date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DATEPART<\/td>\n<td width=\"114\" valign=\"bottom\">Partie de date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DAY<\/td>\n<td width=\"114\" valign=\"bottom\">Jour d&rsquo;une date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DAYNAME<\/td>\n<td width=\"114\" valign=\"bottom\">Nom du jour<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DAYOFMONTH<\/td>\n<td width=\"114\" valign=\"bottom\">Jour du mois<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DAYOFWEEK<\/td>\n<td width=\"114\" valign=\"bottom\">Jour de la semaine<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">DAYOFYEAR<\/td>\n<td width=\"114\" valign=\"bottom\">Jour dans l&rsquo;ann\u00e9e<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">EXTRACT<\/td>\n<td width=\"114\" valign=\"bottom\">Partie de date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">HOUR<\/td>\n<td width=\"114\" valign=\"bottom\">Extraction de l&rsquo;heure<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">INTERVAL (op\u00e9rations sur)<\/td>\n<td width=\"114\" valign=\"bottom\">Dur\u00e9e<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">LAST_DAY<\/td>\n<td width=\"114\" valign=\"bottom\">Dernier jour du mois<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">MINUTE<\/td>\n<td width=\"114\" valign=\"bottom\"><\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">MONTH<\/td>\n<td width=\"114\" valign=\"bottom\">Mois d&rsquo;une date<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">MONTH_BETWEEN<\/td>\n<td width=\"114\" valign=\"bottom\">MONTH_BETWEEN<\/td>\n<td width=\"67\" valign=\"bottom\"><\/td>\n<td width=\"67\" valign=\"bottom\"><\/td>\n<td width=\"66\" valign=\"bottom\"><\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">MONTHNAME<\/td>\n<td width=\"114\" valign=\"bottom\">Nom du mois<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">NEXT_DAY<\/td>\n<td width=\"114\" valign=\"bottom\">Prochain premier jour de la semaine<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">OVERLAPS (pr\u00e9dicat)<\/td>\n<td width=\"114\" valign=\"bottom\">Recouvrement de p\u00e9riode<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">SECOND<\/td>\n<td width=\"114\" valign=\"bottom\">Extrait les secondes<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">SUBDATE<\/td>\n<td width=\"114\" valign=\"bottom\">Retrait d&rsquo;intervalle \u00e0 une date<\/td>\n<td width=\"67\" valign=\"bottom\">N<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<td width=\"66\" valign=\"bottom\">N<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">WEEK<\/td>\n<td width=\"114\" valign=\"bottom\">Num\u00e9ro de la semaine<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<\/tr>\n<tr>\n<td width=\"114\" valign=\"bottom\">YEAR<\/td>\n<td width=\"114\" valign=\"bottom\">Ann\u00e9e d&rsquo;une date<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"67\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<td width=\"66\" valign=\"bottom\">O<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>\n<table bordercolor=\"\">\n<tr>\n<th bgcolor=\"\" width=\"\"><a href=\"#1\" name=\"ag\"><font color=\"black\">Agr\u00e9gation<\/font><\/a><\/td>\n<\/tr>\n<\/table>\n<\/h4>\n<p><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr height=\"28\" bgcolor=\"#C1CCFD\">\n<th width=\"80\" height=\"28\">Fonction<\/th>\n<th width=\"80\">Description<\/th>\n<th width=\"80\">Access<\/th>\n<th width=\"80\">MySQL<\/th>\n<th width=\"80\">SQL Server<\/th>\n<th width=\"80\">Oracle<\/th>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">ANY \/ SOME<\/td>\n<td width=\"80\">Au   moins un (bool\u00e9en)<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">AVG<\/td>\n<td width=\"80\">Moyenne<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">COUNT<\/td>\n<td width=\"80\">Nombre<\/td>\n<td width=\"80\">X<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">EVERY<\/td>\n<td width=\"80\">Tous   (bool\u00e9en)<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">MAX<\/td>\n<td width=\"80\">Maximum<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">MIN<\/td>\n<td width=\"80\">Minimum<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">SUM<\/td>\n<td width=\"80\">Total<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>\n<\/p>\n<table bordercolor=\"\">\n<tr>\n<th bgcolor=\"\" width=\"\"><a href=\"#1\" name=\"fs\"><font color=\"black\">Quelques fonctions syst\u00e8mes<\/font><\/a><\/td>\n<\/tr>\n<\/table>\n<\/h4>\n<p><\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col span=\"6\" width=\"80\"><\/col>\n<\/colgroup>\n<tbody>\n<tr height=\"28\" bgcolor=\"#C1CCFD\">\n<th width=\"80\" height=\"28\">Fonction<\/th>\n<th width=\"80\">Description<\/th>\n<th width=\"80\">Access<\/th>\n<th width=\"80\">MySQL<\/th>\n<th width=\"80\">SQL Server<\/th>\n<th width=\"80\">Oracle<\/th>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">CURDATE<\/td>\n<td width=\"80\">Date   du jour<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">CURRENT_DATE<\/td>\n<td width=\"80\">Date   courante<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">CURRENT_TIME<\/td>\n<td width=\"80\">Heure   courante<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"44\">\n<td width=\"80\" height=\"44\">CURRENT_TIMESTAMP<\/td>\n<td width=\"80\">Date   et heure courante<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">CURRENT_USER<\/td>\n<td width=\"80\">Utilisateur   courant<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">CURTIME<\/td>\n<td width=\"80\">Heure   courante<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"58\">\n<td width=\"80\" height=\"58\">DATABASE<\/td>\n<td width=\"80\">Nom   de la bases de donn\u00e9es courante<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"44\">\n<td width=\"80\" height=\"44\">GETDATE<\/td>\n<td width=\"80\">Heure   et date courante<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"44\">\n<td width=\"80\" height=\"44\">NOW<\/td>\n<td width=\"80\">Heure   et date courante<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">SESSION_USER<\/td>\n<td width=\"80\">Utilisateur   autoris\u00e9<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\"><\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"44\">\n<td width=\"80\" height=\"44\">SYSDATE<\/td>\n<td width=\"80\">Date   et\/ou heure courante<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">SYSTEM_USER<\/td>\n<td width=\"80\">Utilisateur   syst\u00e8me<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\"><\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"20\">\n<td width=\"80\" height=\"20\">TODAY<\/td>\n<td width=\"80\">Date   du jour<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">N<\/td>\n<\/tr>\n<tr height=\"30\">\n<td width=\"80\" height=\"30\">USER<\/td>\n<td width=\"80\">Utilisateur   courant<\/td>\n<td width=\"80\">N<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<td width=\"80\">O<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Les ajouts se ferons au fur et \u00e0 mesure, n&rsquo;h\u00e9sitez pas \u00e0 faire des suggestions. \ud83d\ude42<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_104\" class=\"pvc_stats all  \" data-element-id=\"104\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/nestasoft.fr\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Bonjour et bienvenue sur ce nouveau tour d&rsquo;horizon. Je vais vous pr\u00e9senter quelques fonctions permettant de manipuler les SGBRs (Syst\u00e8me de Gestion de Base de Donn\u00e9es Relationnalles).<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_104\" class=\"pvc_stats all  \" data-element-id=\"104\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/nestasoft.fr\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-104","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/nestasoft.fr\/index.php?rest_route=\/wp\/v2\/posts\/104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nestasoft.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nestasoft.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nestasoft.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nestasoft.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=104"}],"version-history":[{"count":21,"href":"https:\/\/nestasoft.fr\/index.php?rest_route=\/wp\/v2\/posts\/104\/revisions"}],"predecessor-version":[{"id":303,"href":"https:\/\/nestasoft.fr\/index.php?rest_route=\/wp\/v2\/posts\/104\/revisions\/303"}],"wp:attachment":[{"href":"https:\/\/nestasoft.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nestasoft.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nestasoft.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}