{"id":2832,"date":"2022-05-24T15:36:14","date_gmt":"2022-05-24T13:36:14","guid":{"rendered":"https:\/\/devbloomppm.wpengine.com\/?p=2832"},"modified":"2022-05-31T17:34:33","modified_gmt":"2022-05-31T15:34:33","slug":"requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb","status":"publish","type":"post","link":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/","title":{"rendered":"Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2832\" class=\"elementor elementor-2832\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-725e085 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"725e085\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-78dadd8\" data-id=\"78dadd8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-7a06bdb\" data-id=\"7a06bdb\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b6c83ad elementor-widget elementor-widget-heading\" data-id=\"b6c83ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-22f5647 elementor-section-stretched elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"22f5647\" data-element_type=\"section\" data-e-type=\"section\" data-settings=\"{&quot;stretch_section&quot;:&quot;section-stretched&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-33 elementor-top-column elementor-element elementor-element-4706b90\" data-id=\"4706b90\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d8a3fd1 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"d8a3fd1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c858b96 elementor-widget elementor-widget-heading\" data-id=\"c858b96\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h5 class=\"elementor-heading-title elementor-size-default\">Sommaire<\/h5>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c52820 elementor-align-start elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"7c52820\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"#title1\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Description<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"#title2\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Requ\u00eate SQL<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"#title3\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-chevron-right\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Utilisation<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-66 elementor-top-column elementor-element elementor-element-e69c542\" data-id=\"e69c542\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fb764c9 elementor-widget elementor-widget-heading\" data-id=\"fb764c9\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title1\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Description<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c1997c elementor-widget elementor-widget-text-editor\" data-id=\"7c1997c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Il est parfois utile de g\u00e9n\u00e9rer la liste des tables de la base de donn\u00e9es Planisware contenant une colonne ONB. De plus, la liste de ces tables n\u2019est pas fixe car elle va d\u00e9pendre de la version du noyau Planisware, de la version de Processes et du param\u00e9trage sp\u00e9cifique impl\u00e9ment\u00e9.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b0956d7 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"b0956d7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-74cdd93 elementor-widget elementor-widget-heading\" data-id=\"74cdd93\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title2\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Requ\u00eate SQL<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c78c4d9 elementor-widget elementor-widget-text-editor\" data-id=\"c78c4d9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Voici une requ\u00eate SQL \u00e0 ex\u00e9cuter en \u00e9tant connect\u00e9 au sch\u00e9ma de la BDD et renvoyant la liste des tables Planisware :<\/p><p><span style=\"color: #993366;\">select table_name, column_name<\/span><br \/><span style=\"color: #993366;\">from USER_TAB_COLUMNS<\/span><br \/><span style=\"color: #993366;\">where column_name like \u2019ONB\u2019<\/span><br \/><span style=\"color: #993366;\">order by column_name, table_name;<\/span><br \/><br \/>Note : les r\u00e9sultats du type \u00ab BIN$************ \u00bb sont \u00e0 enlever.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7845c04 elementor-widget-divider--view-line_text elementor-widget-divider--element-align-center elementor-widget elementor-widget-divider\" data-id=\"7845c04\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e8e3de elementor-widget elementor-widget-heading\" data-id=\"7e8e3de\" data-element_type=\"widget\" data-e-type=\"widget\" id=\"title3\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Utilisation<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e82b3da elementor-widget elementor-widget-text-editor\" data-id=\"e82b3da\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>La liste des tables contenant une colonne ONB est utile notamment pour g\u00e9n\u00e9rer facilement depuis Excel des requ\u00eates SQL de s\u00e9lection ou de mise \u00e0 jour de donn\u00e9es en base.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb Sommaire Description Requ\u00eate SQL Utilisation Description Il est parfois utile de g\u00e9n\u00e9rer la liste des tables de la base de donn\u00e9es Planisware contenant une colonne ONB. De plus, la liste de ces tables n\u2019est pas fixe car elle va&hellip;&nbsp;<a href=\"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/\" rel=\"bookmark\">Lire la suite &raquo;<span class=\"screen-reader-text\">Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb<\/span><\/a><\/p>\n","protected":false},"author":5,"featured_media":1100,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"left","neve_meta_author_avatar":"","neve_post_elements_order":"[\"meta\",\"thumbnail\",\"content\",\"tags\",\"comments\"]","neve_meta_disable_header":"off","neve_meta_disable_footer":"","neve_meta_disable_title":"","_themeisle_gutenberg_block_has_review":false,"cybocfi_hide_featured_image":"yes","footnotes":""},"categories":[9],"tags":[],"class_list":["post-2832","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-non-classifiee"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.9 (Yoast SEO v27.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb - BLOOM PPM<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/\"},\"author\":{\"name\":\"Antoine Hirschenhahn\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/person\\\/beb0bf75e386466a086d6a396e9112b7\"},\"headline\":\"Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb\",\"datePublished\":\"2022-05-24T13:36:14+00:00\",\"dateModified\":\"2022-05-31T15:34:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/\"},\"wordCount\":189,\"publisher\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/planisware-logo.png\",\"articleSection\":[\"Non classifi\u00e9(e)\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/\",\"name\":\"Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb - BLOOM PPM\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/planisware-logo.png\",\"datePublished\":\"2022-05-24T13:36:14+00:00\",\"dateModified\":\"2022-05-31T15:34:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#website\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\",\"name\":\"BLOOM PPM\",\"description\":\"We make your projects grow\",\"publisher\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#organization\",\"name\":\"Bloom PPM\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Blue_without_background.png\",\"contentUrl\":\"https:\\\/\\\/bloomppm.com\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Blue_without_background.png\",\"width\":602,\"height\":204,\"caption\":\"Bloom PPM\"},\"image\":{\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/bloomppm\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/#\\\/schema\\\/person\\\/beb0bf75e386466a086d6a396e9112b7\",\"name\":\"Antoine Hirschenhahn\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g\",\"caption\":\"Antoine Hirschenhahn\"},\"url\":\"https:\\\/\\\/bloomppm.com\\\/fr\\\/author\\\/antoine-hirschenhahnbloomppm-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb - BLOOM PPM","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/#article","isPartOf":{"@id":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/"},"author":{"name":"Antoine Hirschenhahn","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/person\/beb0bf75e386466a086d6a396e9112b7"},"headline":"Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb","datePublished":"2022-05-24T13:36:14+00:00","dateModified":"2022-05-31T15:34:33+00:00","mainEntityOfPage":{"@id":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/"},"wordCount":189,"publisher":{"@id":"https:\/\/bloomppm.com\/fr\/#organization"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/#primaryimage"},"thumbnailUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/planisware-logo.png","articleSection":["Non classifi\u00e9(e)"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/","url":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/","name":"Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb - BLOOM PPM","isPartOf":{"@id":"https:\/\/bloomppm.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/#primaryimage"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/#primaryimage"},"thumbnailUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/planisware-logo.png","datePublished":"2022-05-24T13:36:14+00:00","dateModified":"2022-05-31T15:34:33+00:00","breadcrumb":{"@id":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/bloomppm.com\/fr\/requete-sql-pour-recuperer-toutes-les-tables-de-la-bdd-possedant-un-champ-onb\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bloomppm.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Requ\u00eate SQL pour r\u00e9cup\u00e9rer toutes les tables de la BDD poss\u00e9dant un champ \u00ab ONB \u00bb"}]},{"@type":"WebSite","@id":"https:\/\/bloomppm.com\/fr\/#website","url":"https:\/\/bloomppm.com\/fr\/","name":"BLOOM PPM","description":"We make your projects grow","publisher":{"@id":"https:\/\/bloomppm.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bloomppm.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/bloomppm.com\/fr\/#organization","name":"Bloom PPM","url":"https:\/\/bloomppm.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/Blue_without_background.png","contentUrl":"https:\/\/bloomppm.com\/wp-content\/uploads\/2020\/10\/Blue_without_background.png","width":602,"height":204,"caption":"Bloom PPM"},"image":{"@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/bloomppm\/"]},{"@type":"Person","@id":"https:\/\/bloomppm.com\/fr\/#\/schema\/person\/beb0bf75e386466a086d6a396e9112b7","name":"Antoine Hirschenhahn","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/secure.gravatar.com\/avatar\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e6ee81cbc975109949822918ee666922009c32622b2da432a1a3904c52375d60?s=96&d=mm&r=g","caption":"Antoine Hirschenhahn"},"url":"https:\/\/bloomppm.com\/fr\/author\/antoine-hirschenhahnbloomppm-com\/"}]}},"_links":{"self":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts\/2832","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/comments?post=2832"}],"version-history":[{"count":0,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/posts\/2832\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/media\/1100"}],"wp:attachment":[{"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/media?parent=2832"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/categories?post=2832"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bloomppm.com\/fr\/wp-json\/wp\/v2\/tags?post=2832"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}