{"id":9946,"date":"2026-09-29T18:54:17","date_gmt":"2026-09-29T18:54:17","guid":{"rendered":"https:\/\/fpw.com.br\/m\/?p=9946"},"modified":"2026-09-29T19:42:52","modified_gmt":"2026-09-29T19:42:52","slug":"dados-sql-como-funciona-e-por-que-ele-e-tao-importante-para-quem-trabalha-com-dados","status":"publish","type":"post","link":"https:\/\/fpw.com.br\/m\/dados-sql-como-funciona-e-por-que-ele-e-tao-importante-para-quem-trabalha-com-dados\/","title":{"rendered":"Dados | SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"9946\" class=\"elementor elementor-9946\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-38f3eda e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"38f3eda\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2b1c0f0 elementor-widget elementor-widget-heading\" data-id=\"2b1c0f0\" 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\">- DADOS \u2022 DICAS PR\u00c1TICAS -<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-40b0655 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"40b0655\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3c6add9 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"3c6add9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-b5dfdbc e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"b5dfdbc\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8e34436 elementor-search-form--skin-classic elementor-search-form--button-type-icon elementor-search-form--icon-search elementor-widget elementor-widget-search-form\" data-id=\"8e34436\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;skin&quot;:&quot;classic&quot;}\" data-widget_type=\"search-form.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<search role=\"search\">\n\t\t\t<form class=\"elementor-search-form\" action=\"https:\/\/fpw.com.br\/m\" method=\"get\">\n\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-search-form__container\">\n\t\t\t\t\t<label class=\"elementor-screen-only\" for=\"elementor-search-form-8e34436\">Search<\/label>\n\n\t\t\t\t\t\n\t\t\t\t\t<input id=\"elementor-search-form-8e34436\" placeholder=\"Search...\" class=\"elementor-search-form__input\" type=\"search\" name=\"s\" value=\"\">\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t<button class=\"elementor-search-form__submit\" type=\"submit\" aria-label=\"Search\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"e-font-icon-svg-container\"><svg class=\"fa fa-search e-font-icon-svg e-fas-search\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M505 442.7L405.3 343c-4.5-4.5-10.6-7-17-7H372c27.6-35.3 44-79.7 44-128C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c48.3 0 92.7-16.4 128-44v16.3c0 6.4 2.5 12.5 7 17l99.7 99.7c9.4 9.4 24.6 9.4 33.9 0l28.3-28.3c9.4-9.4 9.4-24.6.1-34zM208 336c-70.7 0-128-57.2-128-128 0-70.7 57.2-128 128-128 70.7 0 128 57.2 128 128 0 70.7-57.2 128-128 128z\"><\/path><\/svg><\/div>\t\t\t\t\t\t\t\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/form>\n\t\t<\/search>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1997c83 elementor-widget elementor-widget-heading\" data-id=\"1997c83\" 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\">SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8248600 elementor-widget elementor-widget-text-editor\" data-id=\"8248600\" 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>Voc\u00ea n\u00e3o precisa apenas saber onde os dados est\u00e3o. Precisa saber como consultar, cruzar, alterar e validar essas informa\u00e7\u00f5es. \u00c9 a\u00ed que entra o SQL.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-17bdced e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"17bdced\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-f267e16 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"f267e16\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-09581f9 elementor-widget elementor-widget-text-editor\" data-id=\"09581f9\" 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<h2><span style=\"color: #ffffff;\">1. O que \u00e9 SQL e como ele funciona?<\/span><\/h2>\n<p><span style=\"color: #ffffff;\"><strong>SQL (Structured Query Language)<\/strong> \u00e9 uma linguagem usada para trabalhar com dados em bancos relacionais. Com ela, podemos consultar, inserir, alterar e excluir dados, al\u00e9m de criar e modificar estruturas do banco.<\/span><\/p>\n<div class=\"destaque\"><span style=\"color: #ffffff;\"><strong>\ud83d\udca1 Pense no SQL como uma conversa com o banco de dados.<\/strong><\/span><br \/><span style=\"color: #ffffff;\">Voc\u00ea faz uma solicita\u00e7\u00e3o estruturada e o banco interpreta a instru\u00e7\u00e3o para retornar ou modificar informa\u00e7\u00f5es conforme as regras e permiss\u00f5es da sess\u00e3o.<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-552a658 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"552a658\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2865274 elementor-widget elementor-widget-text-editor\" data-id=\"2865274\" 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 style=\"text-align: center;\"><strong><span class=\"kw\">SELECT<\/span> nome, cargo <span class=\"kw\">FROM<\/span> funcionarios <span class=\"kw\">WHERE<\/span> departamento = <span class=\"kw\">&#8216;TI&#8217;<\/span>;<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-38d8243 elementor-widget elementor-widget-text-editor\" data-id=\"38d8243\" 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<h4><span style=\"color: #ffffff;\">Essa consulta pede nome e cargo dos funcion\u00e1rios cujo departamento seja TI.<\/span><\/h4>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-08ebe6c wpr-grid-columns-3 wpr-grid-columns--tablet2 wpr-grid-columns--mobile1 wpr-item-styles-inner elementor-widget elementor-widget-wpr-grid\" data-id=\"08ebe6c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-grid.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<ul class=\"wpr-grid-filters elementor-clearfix wpr-grid-filters-sep-right\"><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span  data-filter=\"*\" class=\"wpr-grid-filters-item wpr-active-filter \">All Posts<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"blog\"]  data-filter=\".category-blog\">Blog<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"certificados\"]  data-filter=\".category-certificados\">Certificados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"dados\"]  data-filter=\".category-dados\">Dados<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"dashboard\"]  data-filter=\".category-dashboard\">Dashboard<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"diversos\"]  data-filter=\".category-diversos\">Diversos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"excel\"]  data-filter=\".category-excel\">Excel<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"fpw\"]  data-filter=\".category-fpw\">FPw<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"membros\"]  data-filter=\".category-membros\">Membros<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"noticias\"]  data-filter=\".category-noticias\">Not\u00c3\u00adcias<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"planilhas\"]  data-filter=\".category-planilhas\">Planilhas<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"produtos\"]  data-filter=\".category-produtos\">Produtos<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"sql\"]  data-filter=\".category-sql\">SQL<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"tecnologia\"]  data-filter=\".category-tecnologia\">Tecnologia<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><li class=\" wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-none\"><span   data-ajax-filter=[\"category\",\"wordpress\"]  data-filter=\".category-wordpress\">WordPress<\/span><em class=\"wpr-grid-filters-sep\"><\/em><\/li><\/ul><section class=\"wpr-grid elementor-clearfix\" data-settings=\"{&quot;layout&quot;:&quot;fitRows&quot;,&quot;stick_last_element_to_bottom&quot;:&quot;&quot;,&quot;columns_desktop&quot;:3,&quot;gutter_hr&quot;:15,&quot;gutter_hr_mobile&quot;:15,&quot;gutter_hr_mobile_extra&quot;:15,&quot;gutter_hr_tablet&quot;:15,&quot;gutter_hr_tablet_extra&quot;:15,&quot;gutter_hr_laptop&quot;:15,&quot;gutter_hr_widescreen&quot;:15,&quot;gutter_vr&quot;:15,&quot;gutter_vr_mobile&quot;:15,&quot;gutter_vr_mobile_extra&quot;:15,&quot;gutter_vr_tablet&quot;:15,&quot;gutter_vr_tablet_extra&quot;:15,&quot;gutter_vr_laptop&quot;:15,&quot;gutter_vr_widescreen&quot;:15,&quot;animation&quot;:&quot;default&quot;,&quot;animation_duration&quot;:0.3,&quot;animation_delay&quot;:0.1,&quot;deeplinking&quot;:&quot;&quot;,&quot;filters_linkable&quot;:&quot;no&quot;,&quot;filters_default_filter&quot;:&quot;&quot;,&quot;filters_count&quot;:&quot;&quot;,&quot;filters_hide_empty&quot;:&quot;no&quot;,&quot;filters_animation&quot;:&quot;default&quot;,&quot;filters_animation_duration&quot;:0.3,&quot;filters_animation_delay&quot;:0.1,&quot;pagination_type&quot;:&quot;load-more&quot;,&quot;pagination_max_pages&quot;:115,&quot;lightbox&quot;:{&quot;selector&quot;:&quot;.wpr-grid-image-wrap&quot;,&quot;iframeMaxWidth&quot;:&quot;60%&quot;,&quot;hash&quot;:false,&quot;autoplay&quot;:&quot;true&quot;,&quot;pause&quot;:5000,&quot;progressBar&quot;:&quot;true&quot;,&quot;counter&quot;:&quot;true&quot;,&quot;controls&quot;:&quot;true&quot;,&quot;getCaptionFromTitleOrAlt&quot;:&quot;true&quot;,&quot;thumbnail&quot;:&quot;&quot;,&quot;showThumbByDefault&quot;:&quot;&quot;,&quot;share&quot;:&quot;&quot;,&quot;zoom&quot;:&quot;true&quot;,&quot;fullScreen&quot;:&quot;true&quot;,&quot;download&quot;:&quot;true&quot;}}\" data-advanced-filters=\"no\"><article class=\"wpr-grid-item elementor-clearfix post-9946 post type-post status-publish format-standard has-post-thumbnail hentry category-dados tag-dados tag-sql\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL.jpg\" alt=\"SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados?\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/dados-sql-como-funciona-e-por-que-ele-e-tao-importante-para-quem-trabalha-com-dados\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/dados-sql-como-funciona-e-por-que-ele-e-tao-importante-para-quem-trabalha-com-dados\/\">Dados | SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados?<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/dados-sql-como-funciona-e-por-que-ele-e-tao-importante-para-quem-trabalha-com-dados\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9933 post type-post status-publish format-standard has-post-thumbnail hentry category-excel\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Preenchimento-relampago.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Preenchimento-relampago.jpg\" alt=\"Preenchimento Rel\u00e2mpago no Excel: o recurso que pode economizar horas de trabalho\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/excel-preenchimento-relampago-no-excel-o-recurso-que-pode-economizar-horas-de-trabalho\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-preenchimento-relampago-no-excel-o-recurso-que-pode-economizar-horas-de-trabalho\/\">Excel | Preenchimento Rel\u00e2mpago no Excel: o recurso que pode economizar horas de trabalho<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/excel-preenchimento-relampago-no-excel-o-recurso-que-pode-economizar-horas-de-trabalho\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><article class=\"wpr-grid-item elementor-clearfix post-9823 post type-post status-publish format-standard has-post-thumbnail hentry category-fpw tag-curso-fpw tag-fpw tag-fpw-nuvem tag-fpw-on-prime tag-o-que-e-fpw-on-prime tag-o-que-significa-fpw tag-porque-o-fpw-trocou-de-nome tag-sistema-fpw-da-lg-sistemas-uma-visao-abrangente\"><div class=\"wpr-grid-item-inner\"><div class=\"wpr-grid-media-wrap wpr-effect-size-medium \" data-overlay-link=\"yes\"><div class=\"wpr-grid-image-wrap\" data-src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/quer-aprender-mais-sobre-FPw.jpg\" data-img-on-hover=\"\"  data-src-secondary=\"\"><img decoding=\"async\" data-no-lazy=\"1\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/quer-aprender-mais-sobre-FPw.jpg\" alt=\"Onde encontrar cursos de FPw e LG Nuvem?\" class=\"wpr-anim-timing-ease-default\"><\/div><div class=\"wpr-grid-media-hover wpr-animation-wrap\"><div class=\"wpr-grid-media-hover-bg  wpr-overlay-fade-in wpr-anim-size-large wpr-anim-timing-ease-default wpr-anim-transparency\" data-url=\"https:\/\/fpw.com.br\/m\/fpw-onde-encontrar-cursos-de-fpw-e-lg-nuvem\/\"><\/div><\/div><\/div><div class=\"wpr-grid-item-below-content elementor-clearfix\"><h2 class=\"wpr-grid-item-title elementor-repeater-item-3d363d3 wpr-grid-item-display-block wpr-grid-item-align-left wpr-pointer-none wpr-pointer-line-fx wpr-pointer-fx-fade\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-onde-encontrar-cursos-de-fpw-e-lg-nuvem\/\">FPw | Onde encontrar cursos de FPw e LG Nuvem?<\/a><\/div><\/h2><div class=\"wpr-grid-item-read-more elementor-repeater-item-8d27e5b wpr-grid-item-display-block wpr-grid-item-align-left\"><div class=\"inner-block\"><a target=\"_self\" href=\"https:\/\/fpw.com.br\/m\/fpw-onde-encontrar-cursos-de-fpw-e-lg-nuvem\/\" class=\"wpr-button-effect wpr-button-none\"><span>Leia mais<\/span><\/a><\/div><\/div><\/div><\/div><\/article><\/section>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d12ef65 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"d12ef65\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-8bf3ce6 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"8bf3ce6\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9cc1164 elementor-widget elementor-widget-text-editor\" data-id=\"9cc1164\" 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<h2><span style=\"color: #ffffff;\">2. O que acontece quando voc\u00ea executa um comando?<\/span><\/h2>\n<div class=\"passo\">\n<div class=\"num\"><span style=\"color: #ffffff;\">1<\/span><\/div>\n<div><span style=\"color: #ffffff;\"><strong>Voc\u00ea escreve o SQL<\/strong><\/span><br \/><span style=\"color: #ffffff;\">Por exemplo, uma consulta SELECT no editor do Toad.<\/span><\/div>\n<\/div>\n<div class=\"passo\">\n<div class=\"num\"><span style=\"color: #ffffff;\">2<\/span><\/div>\n<div><span style=\"color: #ffffff;\"><strong>O Toad envia a instru\u00e7\u00e3o<\/strong><\/span><br \/><span style=\"color: #ffffff;\">O comando \u00e9 enviado para a conex\u00e3o Oracle selecionada.<\/span><\/div>\n<\/div>\n<div class=\"passo\">\n<div class=\"num\"><span style=\"color: #ffffff;\">3<\/span><\/div>\n<div><span style=\"color: #ffffff;\"><strong>O Oracle processa a instru\u00e7\u00e3o<\/strong><\/span><br \/><span style=\"color: #ffffff;\">O banco verifica sintaxe, objetos, permiss\u00f5es e executa a opera\u00e7\u00e3o.<\/span><\/div>\n<\/div>\n<div class=\"passo\">\n<div class=\"num\"><span style=\"color: #ffffff;\">4<\/span><\/div>\n<div><span style=\"color: #ffffff;\"><strong>Voc\u00ea recebe o resultado<\/strong><\/span><br \/><span style=\"color: #ffffff;\">Em um SELECT, os registros aparecem no grid; em altera\u00e7\u00f5es, voc\u00ea recebe o resultado da opera\u00e7\u00e3o.<\/span><\/div>\n<\/div>\n<div class=\"info\"><span style=\"color: #ffffff;\"><strong>\ud83d\udccc Importante:<\/strong> SQL n\u00e3o \u00e9 apenas \u201cbuscar dados\u201d. UPDATE e DELETE podem alterar dados e exigem aten\u00e7\u00e3o especial.<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86403a5 elementor-widget elementor-widget-video\" data-id=\"86403a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/www.youtube.com\\\/watch?v=RGEGDPiJml4&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e581455 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"e581455\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-14e2969 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"14e2969\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-dd1ab15 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"dd1ab15\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fd66b32 elementor-widget elementor-widget-text-editor\" data-id=\"fd66b32\" 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<h2><span style=\"color: #00ff00;\">\ud83d\udd04 Seis comandos que todo profissional de dados deveria conhecer<\/span><\/h2>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0a1950f e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"0a1950f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-b7f503e e-grid e-con-full wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"b7f503e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7ed7189 elementor-widget elementor-widget-icon-box\" data-id=\"7ed7189\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<a href=\"#\" >\n\t\t\t\t\t\t\t1 \u2022 CONSULTA \t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tSELECT * FROM funcionarios;\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\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-7984ebb elementor-widget elementor-widget-icon-box\" data-id=\"7984ebb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<a href=\"#\" >\n\t\t\t\t\t\t\t2 \u2022 INSER\u00c7\u00c3O\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tINSERT INTO funcionarios (nome,cargo) VALUES ('Ana','Analista');\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\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-ecc1729 elementor-widget elementor-widget-icon-box\" data-id=\"ecc1729\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<a href=\"#\" >\n\t\t\t\t\t\t\t3 \u2022 ALTERA\u00c7\u00c3O\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tUPDATE funcionarios SET cargo='Analista S\u00eanior' WHERE id=10;\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\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-d0e34d2 elementor-widget elementor-widget-icon-box\" data-id=\"d0e34d2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<a href=\"#\" >\n\t\t\t\t\t\t\t4 \u2022 EXCLUS\u00c3O\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tDELETE FROM funcionarios WHERE id=10;\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\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-36c0c1b elementor-widget elementor-widget-icon-box\" data-id=\"36c0c1b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<a href=\"#\" >\n\t\t\t\t\t\t\t5 \u2022 ESTRUTURA\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tCREATE TABLE departamentos (id NUMBER,nome VARCHAR2(100));\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\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-6ccec9e elementor-widget elementor-widget-icon-box\" data-id=\"6ccec9e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<a href=\"#\" >\n\t\t\t\t\t\t\t6 \u2022 RELACIONAMENTO\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tSELECT f.nome,d.nome FROM funcionarios f JOIN departamentos d ON d.id=f.departamento_id;\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8fb29af e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"8fb29af\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-46fc137 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"46fc137\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-061f6a4 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"061f6a4\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0e2e68d elementor-widget elementor-widget-text-editor\" data-id=\"0e2e68d\" 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<h2><span style=\"color: #00ff00;\"><strong>\u26a0\ufe0f Regra de seguran\u00e7a:<\/strong> antes de UPDATE ou DELETE, confira cuidadosamente o WHERE. Sem filtro adequado, voc\u00ea pode atingir muitos ou todos os registros.<\/span><\/h2>\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-e9dd717 elementor-widget elementor-widget-text-editor\" data-id=\"e9dd717\" 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<section class=\"bloco\">\n<table>\n<tbody>\n<tr>\n<th><span style=\"color: #33cccc;\">Comando<\/span><\/th>\n<th><span style=\"color: #33cccc;\">Finalidade<\/span><\/th>\n<th><span style=\"color: #33cccc;\">Exemplo<\/span><\/th>\n<\/tr>\n<tr>\n<td><span style=\"color: #ffffff;\">SELECT<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Consultar<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Localizar registros<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #ffffff;\">INSERT<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Inserir<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Cadastrar registro<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #ffffff;\">UPDATE<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Alterar<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Atualizar informa\u00e7\u00f5es<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #ffffff;\">DELETE<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Excluir<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Remover registro<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #ffffff;\">CREATE TABLE<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Criar estrutura<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Criar tabela<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"color: #ffffff;\">JOIN<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Cruzar tabelas<\/span><\/td>\n<td><span style=\"color: #ffffff;\">Relacionar dados<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/section>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-46a157f e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"46a157f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-651ab8f e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"651ab8f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-98da8b3 elementor-widget elementor-widget-text-editor\" data-id=\"98da8b3\" 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<h2><span style=\"color: #00ff00;\">4. Como executar um comando SQL no Toad?<\/span><\/h2>\n<p><span style=\"color: #ffffff;\">Vamos executar uma consulta no <strong><span style=\"color: #00ff00;\">Toad<\/span> for Oracle<\/strong>.<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-06507d2 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"06507d2\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t<div class=\"elementor-element elementor-element-d3a33bc e-grid e-con-full wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"d3a33bc\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5d7d8bf elementor-widget elementor-widget-icon-box\" data-id=\"5d7d8bf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<h3 class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<a href=\"#\" >\n\t\t\t\t\t\t\tSELECT f.nome, f.cargo, d.nome AS departamento FROM funcionarios f JOIN departamentos d ON d.id=f.departamento_id WHERE d.nome='TI';\t\t\t\t\t\t<\/a>\n\t\t\t\t\t<\/h3>\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\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-3450bd5 elementor-widget elementor-widget-text-editor\" data-id=\"3450bd5\" 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><span style=\"color: #ffffff;\"><strong>1.<\/strong> Abra o Editor e confirme a conex\u00e3o com o banco correto.<\/span><\/p>\n<p><span style=\"color: #ffffff;\"><strong>2.<\/strong> Digite ou cole o SQL.<\/span><\/p>\n<p><span style=\"color: #ffffff;\"><strong>3.<\/strong> Coloque o cursor dentro da instru\u00e7\u00e3o.<\/span><\/p>\n<p><span style=\"color: #ffffff;\"><strong>4.<\/strong> Pressione <strong>F9<\/strong> para executar a instru\u00e7\u00e3o atual.<\/span><\/p>\n<p><span style=\"color: #ffffff;\"><strong>5.<\/strong> Confira o grid de resultados.<\/span><\/p>\n<div class=\"info\"><span style=\"color: #ffffff;\"><strong>F9 x F5:<\/strong> no Toad for Oracle, F9 executa uma instru\u00e7\u00e3o; F5 \u00e9 usado para executar como script. O comportamento de obten\u00e7\u00e3o dos resultados tamb\u00e9m \u00e9 diferente.<\/span><\/div>\n<p><span style=\"color: #ffffff;\">Para uma instru\u00e7\u00e3o simples, F9 \u00e9 apropriado. Scripts com v\u00e1rias instru\u00e7\u00f5es ou comandos espec\u00edficos do SQL*Plus podem exigir Execute as Script (F5).<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-80158a3 elementor-widget elementor-widget-heading\" data-id=\"80158a3\" 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\">Gostaria de aprimorar seu conhecimento em Excel,  aproveite nossos Cursos.<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-751a92c e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"751a92c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-3036435 e-grid e-con-full wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"3036435\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0890fe8 elementor-widget elementor-widget-image\" data-id=\"0890fe8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/v2\/checkout\/Gpu64bs6\/X3bvx1v8\" target=\"_blank\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-SQL.png\" class=\"attachment-large size-large wp-image-9802\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-SQL.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-SQL-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-SQL-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-424d762 elementor-widget elementor-widget-image\" data-id=\"424d762\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/6c607ccd-4032-41cf-a684-24e4155a6e2c\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal.png\" class=\"attachment-large size-large wp-image-9224\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-Dashboard-Toal-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-7817e12 elementor-widget elementor-widget-image\" data-id=\"7817e12\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/shop.maisfy.com.br\/v2\/checkout\/Suz1cn45\/Xg3q6ug3\" target=\"_blank\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-TOAD.png\" class=\"attachment-large size-large wp-image-9803\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-TOAD.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-TOAD-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-TOAD-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-0ef5353 elementor-widget elementor-widget-image\" data-id=\"0ef5353\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/3e5e88be-0c1f-4584-9e87-e79faadf4e16\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq.png\" class=\"attachment-large size-large wp-image-8381\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2025\/07\/m-pq-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-42d10e5 elementor-widget elementor-widget-image\" data-id=\"42d10e5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/93c20c84-4cf9-4b01-bde9-346688b1d1fb\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard.png\" class=\"attachment-large size-large wp-image-9223\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/curso-mestre-do-dashboard-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\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-e845607 elementor-widget elementor-widget-image\" data-id=\"e845607\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/maisfy.com.br\/store\/st\/produto\/d64a7982-1d4d-4e14-94cb-36dc13f393c3\/?utm_source=www.fpw.com.br%2F%3Futm_source%3DDireto&#038;utm_medium=Organico&#038;utm_campaign=Direto&#038;utm_content=Home&#038;utm_term=\" target=\"_blank\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel.png\" class=\"attachment-large size-large wp-image-9227\" alt=\"\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel.png 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel-150x150.png 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/Curso-mini-curso-excel-230x230.png 230w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6e3a743 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"6e3a743\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-d4eec47 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"d4eec47\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-9da4ba6 elementor-widget elementor-widget-text-editor\" data-id=\"9da4ba6\" 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<h2><span style=\"color: #ffffff;\">5.<\/span> <span style=\"color: #00ff00;\">Os erros mais comuns n\u00e3o est\u00e3o apenas no SQL<\/span><\/h2>\n<h3><span style=\"color: #ffffff;\">\ud83d\udd0e Tabela ou coluna incorreta<\/span><\/h3>\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-8f5128f elementor-widget elementor-widget-text-editor\" data-id=\"8f5128f\" 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><span style=\"color: #33cccc;\"><strong><span class=\"kw\">SELECT<\/span> nome_cliente <span class=\"kw\">FROM<\/span> clientes;<\/strong><\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7f0f6b4 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"7f0f6b4\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8ff6cb2 elementor-widget elementor-widget-text-editor\" data-id=\"8ff6cb2\" 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><span style=\"color: #ffffff;\">Se o objeto ou a coluna n\u00e3o existir naquele contexto, o Oracle poder\u00e1 retornar erro. Verifique schema, tabela e nomes das colunas.<\/span><\/p>\n<h3><span style=\"color: #ffffff;\">\ud83d\udd0e JOIN incorreto<\/span><\/h3>\n<p><span style=\"color: #ffffff;\">Um JOIN com relacionamento inadequado pode duplicar registros ou deixar informa\u00e7\u00f5es de fora. Entender a estrutura das tabelas \u00e9 t\u00e3o importante quanto conhecer a sintaxe.<\/span><\/p>\n<h3><span style=\"color: #ffffff;\">\ud83d\udd0e UPDATE ou DELETE sem filtro<\/span><\/h3>\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-4eb36b7 elementor-widget elementor-widget-text-editor\" data-id=\"4eb36b7\" 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><span style=\"color: #ffffff;\">Esse comando n\u00e3o possui WHERE. Em um ambiente real, isso pode alterar todos os registros da tabela.<\/span><\/p>\n<div class=\"destaque\"><span style=\"color: #ffffff;\"><strong>\ud83c\udfaf<span style=\"color: #00ff00;\"> A grande li\u00e7\u00e3o:<\/span><\/strong><\/span><br \/><span style=\"color: #ffffff;\">Saber SQL n\u00e3o \u00e9 apenas decorar comandos. \u00c9 entender os dados, os relacionamentos, o impacto da consulta e o resultado esperado.<\/span><\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-62d720f elementor-widget elementor-widget-text-editor\" data-id=\"62d720f\" 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<h1 style=\"text-align: left;\"><span style=\"color: #ffffff;\">\ud83d\udcac Agora quero saber de voc\u00ea:<\/span><\/h1>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-faa7603 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"faa7603\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-4663543 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"4663543\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;gradient&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b03e972 elementor-widget elementor-widget-text-editor\" data-id=\"b03e972\" 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<h2>Agora quero saber da sua experi\u00eancia! \ud83d\udc47<\/h2>\n<p>Voc\u00ea j\u00e1 executou um SQL e recebeu um erro que parecia imposs\u00edvel de entender?<\/p>\n<p>J\u00e1 teve problema com <strong>SELECT, JOIN, UPDATE, DELETE<\/strong> ou com a pr\u00f3pria execu\u00e7\u00e3o no Toad?<\/p>\n<p><strong>Conte nos coment\u00e1rios qual foi o erro de SQL mais dif\u00edcil que voc\u00ea j\u00e1 enfrentou.<\/strong><\/p>\n<p>Seu problema pode ser exatamente a d\u00favida de outro profissional que trabalha com dados todos os dias.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9c38f54 e-con-full e-grid wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"9c38f54\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-fe30315 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"fe30315\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-879d58f elementor-widget elementor-widget-text-editor\" data-id=\"879d58f\" 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<h2 class=\"isSelectedEnd\" style=\"text-align: center;\"><strong>Comente sua experi\u00eancia.<\/strong><\/h2><p class=\"isSelectedEnd\" style=\"text-align: center;\">Talvez o seu problema seja exatamente o mesmo que milhares de profissionais enfrentam todos os dias.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2b4987b elementor-widget elementor-widget-image\" data-id=\"2b4987b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL-1024x576.jpg\" class=\"attachment-large size-large wp-image-9947\" alt=\"SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados?\" srcset=\"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL-1024x576.jpg 1024w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL-300x169.jpg 300w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL-768x432.jpg 768w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL-150x85.jpg 150w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL-600x338.jpg 600w, https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL.jpg 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9c4aeff e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-child\" data-id=\"9c4aeff\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fa735d7 elementor-widget elementor-widget-text-editor\" data-id=\"fa735d7\" 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<h2>\ud83d\udcda <span style=\"color: #33cccc;\">Fontes utilizadas<\/span><\/h2>\n<p><span style=\"color: #ffffff;\"><strong>Oracle \u2014 SQL Commands<\/strong><\/span><br \/><a href=\"https:\/\/docs.oracle.com\/html\/A90108_01\/sqcmd.htm\" target=\"_blank\" rel=\"noopener\">Documenta\u00e7\u00e3o Oracle<\/a><\/p>\n<p><span style=\"color: #ffffff;\"><strong>Quest \u2014 Toad for Oracle 2026 R2<\/strong><\/span><br \/><a href=\"https:\/\/support.quest.com\/technical-documents\/toad-for-oracle\/2026%20r2\/getting-started-guide\/34\" target=\"_blank\" rel=\"noopener\">Getting Started Guide<\/a><\/p>\n<p><span style=\"color: #ffffff;\"><strong>Quest \u2014 Execu\u00e7\u00e3o de statements e scripts<\/strong><\/span><br \/><a href=\"https:\/\/support.quest.com\/technical-documents\/toad-for-oracle\/2026%20r1\/getting-started-guide\/30\" target=\"_blank\" rel=\"noopener\">Guia de execu\u00e7\u00e3o<\/a><\/p>\n<p><span style=\"color: #ffffff;\"><strong>Quest \u2014 Diferen\u00e7as entre F5 e F9<\/strong><\/span><br \/><a href=\"https:\/\/support.quest.com\/toad-for-oracle\/kb\/4234016\/what-are-the-differences-between-how-f5-and-f9-works-in-running-or-executing-scripts-statements\" target=\"_blank\" rel=\"noopener\">F5 x F9<\/a><\/p>\n<p><span style=\"color: #ffffff;\"><strong>Chinarelli TI Consultoria \u2014 Tecnologia, Dados e Automa\u00e7\u00e3o<\/strong><\/span><br \/><a href=\"https:\/\/www.fpw.com.br\/\" target=\"_blank\" rel=\"noopener\">www.fpw.com.br<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f6809c1 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no wpr-column-slider-no wpr-equal-height-no e-con e-parent\" data-id=\"f6809c1\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8d3b722 wpr-comment-reply-separate wpr-comment-reply-align-right elementor-widget elementor-widget-wpr-post-comments\" data-id=\"8d3b722\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"wpr-post-comments.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"wpr-comments-wrap\" id=\"comments\"><h3> 4 Comments<\/h3><ul class=\"wpr-comments-list\"><li id=\"comment-171573\" class=\"pingback even thread-even depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/dados-sql-como-funciona-e-por-que-ele-e-tao-importante-para-quem-trabalha-com-dados\/\">Dados | SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados? &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>29 de setembro de 2026 at 19:00<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Onde encontrar cursos de FPw e LG Nuvem? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-onde-encontrar-cursos-de-fpw-e-lg-nuvem\/?replytocom=171573#respond\" data-commentid=\"171573\" data-postid=\"9823\" data-belowelement=\"comment-171573\" data-respondelement=\"respond\" data-replyto=\"Responder para Dados | SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados? &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para Dados | SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados? &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<li id=\"comment-171570\" class=\"pingback odd alt thread-odd thread-alt depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/excel-os-indicadores-de-rh-no-excel-que-estao-transformando-empresas-em-2026\/\">Excel | Os Indicadores de RH no Excel que Est\u00e3o Transformando Empresas em 2026 &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>26 de setembro de 2026 at 15:16<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Onde encontrar cursos de FPw e LG Nuvem? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-onde-encontrar-cursos-de-fpw-e-lg-nuvem\/?replytocom=171570#respond\" data-commentid=\"171570\" data-postid=\"9823\" data-belowelement=\"comment-171570\" data-respondelement=\"respond\" data-replyto=\"Responder para Excel | Os Indicadores de RH no Excel que Est\u00e3o Transformando Empresas em 2026 &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para Excel | Os Indicadores de RH no Excel que Est\u00e3o Transformando Empresas em 2026 &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<li id=\"comment-171566\" class=\"pingback even thread-even depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/fpw-o-que-o-fpw-tem-de-melhor-que-os-outros-sistemas-de-folha-de-pagamento\/\">FPw | O que o FPw t\u00eam de melhor que os outros sistemas de folha de pagamento &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>25 de setembro de 2026 at 20:08<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Onde encontrar cursos de FPw e LG Nuvem? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-onde-encontrar-cursos-de-fpw-e-lg-nuvem\/?replytocom=171566#respond\" data-commentid=\"171566\" data-postid=\"9823\" data-belowelement=\"comment-171566\" data-respondelement=\"respond\" data-replyto=\"Responder para FPw | O que o FPw t\u00eam de melhor que os outros sistemas de folha de pagamento &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para FPw | O que o FPw t\u00eam de melhor que os outros sistemas de folha de pagamento &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<li id=\"comment-171565\" class=\"pingback odd alt thread-odd thread-alt depth-1\"><article class=\"wpr-post-comment elementor-clearfix\"><div class=\"wpr-comment-avatar\"><\/div><div class=\"wpr-comment-meta\"><div class=\"wpr-comment-author\"><a href=\"https:\/\/fpw.com.br\/m\/excel-erros-do-excel-qual-a-diferenca-entre-n-d-ref-e-os-outros-erros\/\">Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria<\/a><\/div><div class=\"wpr-comment-metadata elementor-clearfix\"><span>25 de setembro de 2026 at 19:08<\/span><\/div><\/div><div class=\"wpr-comment-content\"><p>[&#8230;] FPw | Onde encontrar cursos de FPw e LG Nuvem? [&#8230;]<\/p>\n<\/div><div class=\"wpr-comment-reply\"><a rel=\"nofollow\" class=\"comment-reply-link\" href=\"https:\/\/fpw.com.br\/m\/fpw-onde-encontrar-cursos-de-fpw-e-lg-nuvem\/?replytocom=171565#respond\" data-commentid=\"171565\" data-postid=\"9823\" data-belowelement=\"comment-171565\" data-respondelement=\"respond\" data-replyto=\"Responder para Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria\" aria-label=\"Responder para Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria\">Responder<\/a><\/div><\/article><\/li><\/li><!-- #comment-## -->\n<\/ul>\t<div id=\"respond\" class=\"comment-respond\">\n\t\t<h3 id=\"wpr-reply-title\" class=\"wpr-comment-reply-title\">Leave a Reply <small><a rel=\"nofollow\" id=\"cancel-comment-reply-link\" href=\"\/m\/wp-json\/wp\/v2\/posts\/9946#respond\" style=\"display:none;\">Cancelar resposta<\/a><\/small><\/h3><form action=\"https:\/\/fpw.com.br\/m\/wp-comments-post.php\" method=\"post\" id=\"wpr-comment-form\" class=\"wpr-comment-form wpr-cf-style-5\"><p class=\"comment-notes\"><span id=\"email-notes\">O seu endere\u00e7o de e-mail n\u00e3o ser\u00e1 publicado.<\/span> <span class=\"required-field-message\">Campos obrigat\u00f3rios s\u00e3o marcados com <span class=\"required\">*<\/span><\/span><\/p><div class=\"wpr-comment-form-text\"><label>Message<span>*<\/span><\/label><textarea autocomplete=\"new-password\"   name=\"ea4449d22c\"  placeholder=\"\" cols=\"45\" rows=\"8\" maxlength=\"65525\"><\/textarea><textarea id=\"comment\" aria-label=\"hp-comment\" aria-hidden=\"true\" name=\"comment\" autocomplete=\"new-password\" style=\"padding:0 !important;clip:rect(1px, 1px, 1px, 1px) !important;position:absolute !important;white-space:nowrap !important;height:1px !important;width:1px !important;overflow:hidden !important;\" tabindex=\"-1\"><\/textarea><\/div><p class=\"comment-form-author\"><input id=\"author\" class=\"comment-form__field\" name=\"author\" type=\"text\" placeholder=\"Nome *\" value=\"\" size=\"30\" aria-required='true' required='required' \/><\/p>\n<p class=\"comment-form-email\"><input id=\"email\" class=\"comment-form__field\" name=\"email\" type=\"text\" placeholder=\"E-mail *\" value=\"\" size=\"30\" aria-describedby=\"email-notes\" aria-required='true' required='required' \/><\/p>\n<p class=\"comment-form-url\"><input id=\"url\" class=\"comment-form__field\" name=\"url\" type=\"text\" placeholder=\"Site\" value=\"\" size=\"30\" \/><\/p>\n<p class=\"form-submit\"><input name=\"submit\" type=\"submit\" id=\"wpr-submit-comment\" class=\"wpr-submit-comment\" value=\"Submit\" \/> <input type='hidden' name='comment_post_ID' value='9823' id='comment_post_ID' \/>\n<input type='hidden' name='comment_parent' id='comment_parent' value='0' \/>\n<\/p><\/form>\t<\/div><!-- #respond -->\n\t<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>&#8211; DADOS \u2022 DICAS PR\u00c1TICAS &#8211; SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados? Voc\u00ea n\u00e3o precisa apenas saber onde os dados est\u00e3o. Precisa saber como consultar, cruzar, alterar e validar essas informa\u00e7\u00f5es. \u00c9 a\u00ed que entra o SQL. 1. O que \u00e9 SQL e como ele funciona? SQL (Structured Query Language) \u00e9 uma linguagem usada para trabalhar com dados em bancos relacionais. Com ela, podemos consultar, inserir, alterar e excluir dados, al\u00e9m de criar e modificar estruturas do banco. \ud83d\udca1 Pense no SQL como uma conversa com o banco de dados.Voc\u00ea faz uma solicita\u00e7\u00e3o estruturada e o banco interpreta a instru\u00e7\u00e3o para retornar ou modificar informa\u00e7\u00f5es conforme as regras e permiss\u00f5es da sess\u00e3o. SELECT nome, cargo FROM funcionarios WHERE departamento = &#8216;TI&#8217;; Essa consulta pede nome e cargo dos funcion\u00e1rios cujo departamento seja TI. All Posts Blog Certificados Dados Dashboard Diversos Excel FPw Membros Not\u00c3\u00adcias Planilhas Produtos SQL Tecnologia WordPress Dados | SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados? Leia mais Excel | Preenchimento Rel\u00e2mpago no Excel: o recurso que pode economizar horas de trabalho Leia mais FPw | Onde encontrar cursos de FPw e LG Nuvem? Leia mais 2. O que acontece quando voc\u00ea executa um comando? 1 Voc\u00ea escreve o SQLPor exemplo, uma consulta SELECT no editor do Toad. 2 O Toad envia a instru\u00e7\u00e3oO comando \u00e9 enviado para a conex\u00e3o Oracle selecionada. 3 O Oracle processa a instru\u00e7\u00e3oO banco verifica sintaxe, objetos, permiss\u00f5es e executa a opera\u00e7\u00e3o. 4 Voc\u00ea recebe o resultadoEm um SELECT, os registros aparecem no grid; em altera\u00e7\u00f5es, voc\u00ea recebe o resultado da opera\u00e7\u00e3o. \ud83d\udccc Importante: SQL n\u00e3o \u00e9 apenas \u201cbuscar dados\u201d. UPDATE e DELETE podem alterar dados e exigem aten\u00e7\u00e3o especial.https:\/\/www.youtube.com\/watch?v=RGEGDPiJml4 \ud83d\udd04 Seis comandos que todo profissional de dados deveria conhecer 1 \u2022 CONSULTA SELECT * FROM funcionarios; 2 \u2022 INSER\u00c7\u00c3O INSERT INTO funcionarios (nome,cargo) VALUES (&#8216;Ana&#8217;,&#8217;Analista&#8217;); 3 \u2022 ALTERA\u00c7\u00c3O UPDATE funcionarios SET cargo=&#8217;Analista S\u00eanior&#8217; WHERE id=10; 4 \u2022 EXCLUS\u00c3O DELETE FROM funcionarios WHERE id=10; 5 \u2022 ESTRUTURA CREATE TABLE departamentos (id NUMBER,nome VARCHAR2(100)); 6 \u2022 RELACIONAMENTO SELECT f.nome,d.nome FROM funcionarios f JOIN departamentos d ON d.id=f.departamento_id; \u26a0\ufe0f Regra de seguran\u00e7a: antes de UPDATE ou DELETE, confira cuidadosamente o WHERE. Sem filtro adequado, voc\u00ea pode atingir muitos ou todos os registros. Comando Finalidade Exemplo SELECT Consultar Localizar registros INSERT Inserir Cadastrar registro UPDATE Alterar Atualizar informa\u00e7\u00f5es DELETE Excluir Remover registro CREATE TABLE Criar estrutura Criar tabela JOIN Cruzar tabelas Relacionar dados 4. Como executar um comando SQL no Toad? Vamos executar uma consulta no Toad for Oracle. SELECT f.nome, f.cargo, d.nome AS departamento FROM funcionarios f JOIN departamentos d ON d.id=f.departamento_id WHERE d.nome=&#8217;TI&#8217;; 1. Abra o Editor e confirme a conex\u00e3o com o banco correto. 2. Digite ou cole o SQL. 3. Coloque o cursor dentro da instru\u00e7\u00e3o. 4. Pressione F9 para executar a instru\u00e7\u00e3o atual. 5. Confira o grid de resultados. F9 x F5: no Toad for Oracle, F9 executa uma instru\u00e7\u00e3o; F5 \u00e9 usado para executar como script. O comportamento de obten\u00e7\u00e3o dos resultados tamb\u00e9m \u00e9 diferente. Para uma instru\u00e7\u00e3o simples, F9 \u00e9 apropriado. Scripts com v\u00e1rias instru\u00e7\u00f5es ou comandos espec\u00edficos do SQL*Plus podem exigir Execute as Script (F5). Gostaria de aprimorar seu conhecimento em Excel, aproveite nossos Cursos. 5. Os erros mais comuns n\u00e3o est\u00e3o apenas no SQL \ud83d\udd0e Tabela ou coluna incorreta SELECT nome_cliente FROM clientes; Se o objeto ou a coluna n\u00e3o existir naquele contexto, o Oracle poder\u00e1 retornar erro. Verifique schema, tabela e nomes das colunas. \ud83d\udd0e JOIN incorreto Um JOIN com relacionamento inadequado pode duplicar registros ou deixar informa\u00e7\u00f5es de fora. Entender a estrutura das tabelas \u00e9 t\u00e3o importante quanto conhecer a sintaxe. \ud83d\udd0e UPDATE ou DELETE sem filtro Esse comando n\u00e3o possui WHERE. Em um ambiente real, isso pode alterar todos os registros da tabela. \ud83c\udfaf A grande li\u00e7\u00e3o:Saber SQL n\u00e3o \u00e9 apenas decorar comandos. \u00c9 entender os dados, os relacionamentos, o impacto da consulta e o resultado esperado. \ud83d\udcac Agora quero saber de voc\u00ea: Agora quero saber da sua experi\u00eancia! \ud83d\udc47 Voc\u00ea j\u00e1 executou um SQL e recebeu um erro que parecia imposs\u00edvel de entender? J\u00e1 teve problema com SELECT, JOIN, UPDATE, DELETE ou com a pr\u00f3pria execu\u00e7\u00e3o no Toad? Conte nos coment\u00e1rios qual foi o erro de SQL mais dif\u00edcil que voc\u00ea j\u00e1 enfrentou. Seu problema pode ser exatamente a d\u00favida de outro profissional que trabalha com dados todos os dias. Comente sua experi\u00eancia. Talvez o seu problema seja exatamente o mesmo que milhares de profissionais enfrentam todos os dias. \ud83d\udcda Fontes utilizadas Oracle \u2014 SQL CommandsDocumenta\u00e7\u00e3o Oracle Quest \u2014 Toad for Oracle 2026 R2Getting Started Guide Quest \u2014 Execu\u00e7\u00e3o de statements e scriptsGuia de execu\u00e7\u00e3o Quest \u2014 Diferen\u00e7as entre F5 e F9F5 x F9 Chinarelli TI Consultoria \u2014 Tecnologia, Dados e Automa\u00e7\u00e3owww.fpw.com.br 4 Comments Dados | SQL: como funciona e por que ele \u00e9 t\u00e3o importante para quem trabalha com dados? &#8211; Chinarelli TI Consultoria29 de setembro de 2026 at 19:00 | Edit [&#8230;] FPw | Onde encontrar cursos de FPw e LG Nuvem? [&#8230;] Responder Excel | Os Indicadores de RH no Excel que Est\u00e3o Transformando Empresas em 2026 &#8211; Chinarelli TI Consultoria26 de setembro de 2026 at 15:16 | Edit [&#8230;] FPw | Onde encontrar cursos de FPw e LG Nuvem? [&#8230;] Responder FPw | O que o FPw t\u00eam de melhor que os outros sistemas de folha de pagamento &#8211; Chinarelli TI Consultoria25 de setembro de 2026 at 20:08 | Edit [&#8230;] FPw | Onde encontrar cursos de FPw e LG Nuvem? [&#8230;] Responder Excel | Erros do Excel: qual a diferen\u00e7a entre #N\/D, #REF! e os outros erros? &#8211; Chinarelli TI Consultoria25 de setembro de 2026 at 19:08 | Edit [&#8230;] FPw | Onde encontrar cursos de FPw e LG Nuvem? [&#8230;] Responder Leave a Reply Cancelar resposta Conectado como Marco Chinarelli. Edite seu perfil. Sair? Campos obrigat\u00f3rios s\u00e3o marcados com * Message*<\/p>\n","protected":false},"author":2000,"featured_media":9947,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[277],"tags":[278,62],"class_list":["post-9946","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dados","tag-dados","tag-sql"],"jetpack_sharing_enabled":true,"amp_enabled":false,"jetpack_featured_media_url":"https:\/\/fpw.com.br\/m\/wp-content\/uploads\/2026\/09\/SQL.jpg","_links":{"self":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/9946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/users\/2000"}],"replies":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/comments?post=9946"}],"version-history":[{"count":19,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/9946\/revisions"}],"predecessor-version":[{"id":9969,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/posts\/9946\/revisions\/9969"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media\/9947"}],"wp:attachment":[{"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/media?parent=9946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/categories?post=9946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fpw.com.br\/m\/wp-json\/wp\/v2\/tags?post=9946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}