{"id":835,"date":"2026-05-31T13:00:20","date_gmt":"2026-05-31T16:00:20","guid":{"rendered":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/"},"modified":"2026-05-31T13:00:20","modified_gmt":"2026-05-31T16:00:20","slug":"aula-11-funcoes-de-string-e-numericas-substr-instr-round-no","status":"publish","type":"post","link":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/","title":{"rendered":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle"},"content":{"rendered":"<p>Nesta aula, vamos mergulhar nas <strong>fun\u00e7\u00f5es de string e num\u00e9ricas<\/strong> presentes no Oracle SQL. Voc\u00ea aprender\u00e1 como extrair peda\u00e7os de texto, localizar posi\u00e7\u00f5es espec\u00edficas em strings e realizar opera\u00e7\u00f5es de arredondamento em n\u00fameros. Estas funcionalidades s\u00e3o essenciais para a manipula\u00e7\u00e3o eficaz de dados em bancos de dados, permitindo uma an\u00e1lise mais robusta e respostas mais r\u00e1pidas \u00e0s consultas dos usu\u00e1rios. Entender como e quando usar essas fun\u00e7\u00f5es lhe dar\u00e1 uma vantagem na otimiza\u00e7\u00e3o de consultas e na implementa\u00e7\u00e3o de solu\u00e7\u00f5es eficientes em seus projetos.<\/p>\n<h3>O que voc\u00ea vai aprender nesta aula<\/h3>\n<ul>\n<li>Como utilizar a fun\u00e7\u00e3o <strong>SUBSTR<\/strong> para extrair partes de uma string.<\/li>\n<li>Como aplicar a fun\u00e7\u00e3o <strong>INSTR<\/strong> para localizar caracteres ou sequ\u00eancias em strings.<\/li>\n<li>Como utilizar a fun\u00e7\u00e3o <strong>ROUND<\/strong> para realizar arredondamento num\u00e9rico.<\/li>\n<li>Aplica\u00e7\u00e3o pr\u00e1tica das fun\u00e7\u00f5es de string e num\u00e9ricas com exemplos claros.<\/li>\n<\/ul>\n<h3>Manipulando textos com SUBSTR e INSTR<\/h3>\n<p>No Oracle SQL, as <strong>fun\u00e7\u00f5es de string e<\/strong> como <strong>SUBSTR<\/strong> e <strong>INSTR<\/strong> s\u00e3o amplamente utilizadas para manipula\u00e7\u00e3o de texto. A fun\u00e7\u00e3o <strong>SUBSTR<\/strong> permite que voc\u00ea extraia uma parte de uma string, enquanto a <strong>INSTR<\/strong> ajuda a encontrar a posi\u00e7\u00e3o de uma substring dentro de outra string.<\/p>\n<ul>\n<li><strong>SUBSTR(string, posi\u00e7\u00e3o, comprimento)<\/strong>: Retorna uma substring come\u00e7ando na <em>posi\u00e7\u00e3o<\/em> especificada e com o <em>comprimento<\/em> definido.<\/li>\n<li><strong>INSTR(string, substring, posi\u00e7\u00e3o_inicial, n_ocorr\u00eancia)<\/strong>: Retorna a posi\u00e7\u00e3o de uma <em>substring<\/em> dentro de outra string, come\u00e7ando a partir da <em>posi\u00e7\u00e3o_inicial<\/em>.<\/li>\n<\/ul>\n<h3>Exemplos Pr\u00e1ticos de SUBSTR e INSTR<\/h3>\n<p>Vejamos como podemos usar estas fun\u00e7\u00f5es em consultas reais. Para isso, consideraremos uma tabela chamada <strong>FUNCIONARIOS<\/strong> que cont\u00e9m uma coluna <strong>NOME<\/strong>.<\/p>\n<pre><code>\n-- Usando SUBSTR para extrair o sobrenome\nSELECT SUBSTR(NOME, INSTR(NOME, ' ') + 1) AS SOBRENOME FROM FUNCIONARIOS;\n\n-- Usando INSTR para encontrar a posi\u00e7\u00e3o de um caractere\nSELECT INSTR(NOME, 'a') AS POSICAO_A FROM FUNCIONARIOS;\n<\/code><\/pre>\n<p>No primeiro exemplo, utilizamos <strong>SUBSTR<\/strong> para extrair o sobrenome do funcion\u00e1rio. No segundo, aplicamos <strong>INSTR<\/strong> para determinar a posi\u00e7\u00e3o da primeira ocorr\u00eancia do caractere &#8216;a&#8217; no nome dos funcion\u00e1rios.<\/p>\n<h3>Arredondamento de n\u00fameros com a fun\u00e7\u00e3o ROUND<\/h3>\n<p>Al\u00e9m das <strong>fun\u00e7\u00f5es de string e<\/strong>, tamb\u00e9m \u00e9 crucial entender as fun\u00e7\u00f5es num\u00e9ricas como a <strong>ROUND<\/strong>. Esta fun\u00e7\u00e3o permite que voc\u00ea arredonde valores num\u00e9ricos a um n\u00famero espec\u00edfico de casas decimais, o que \u00e9 particularmente \u00fatil em c\u00e1lculos financeiros e relat\u00f3rios.<\/p>\n<h3>Aplicando a fun\u00e7\u00e3o ROUND em consultas pr\u00e1ticas<\/h3>\n<p>Considere uma tabela <strong>PEDIDOS<\/strong> com uma coluna <strong>VALOR_TOTAL<\/strong>. Podemos usar a fun\u00e7\u00e3o <strong>ROUND<\/strong> para arredondar os valores totais dos pedidos:<\/p>\n<pre><code>\n-- Arredondar o valor total do pedido para duas casas decimais\nSELECT VALOR_TOTAL, ROUND(VALOR_TOTAL, 2) AS VALOR_ARREDONDADO FROM PEDIDOS;\n<\/code><\/pre>\n<p>Aqui, o <strong>ROUND<\/strong> \u00e9 utilizado para ajustar o valor financeiro para apenas duas casas decimais, garantindo maior precis\u00e3o em relat\u00f3rios e an\u00e1lises.<\/p>\n<h3>Resumo da Aula 11<\/h3>\n<p>Nesta aula, exploramos as <strong>fun\u00e7\u00f5es de string e<\/strong> num\u00e9ricas no Oracle SQL, focando nas fun\u00e7\u00f5es <strong>SUBSTR<\/strong>, <strong>INSTR<\/strong> e <strong>ROUND<\/strong>. Aprendemos como essas ferramentas poderosas podem simplificar e otimizar as opera\u00e7\u00f5es de banco de dados, uma pr\u00e1tica comum em nossos projetos na <strong>JRT Technology Solutions<\/strong>, onde nossos especialistas utilizam essas funcionalidades diariamente. Na pr\u00f3xima aula, vamos explorar outras fun\u00e7\u00f5es anal\u00edticas que ir\u00e3o complementar seu conhecimento em Oracle SQL, elevando suas habilidades de an\u00e1lise de dados para o pr\u00f3ximo n\u00edvel.<\/p>\n<div style=\"margin:48px 0 32px;padding:32px 24px;background:#f0fdf4;border:1px solid #bbf7d0;border-radius:16px;text-align:center;\">\n<p style=\"margin:0 0 8px;font-size:17px;color:#111827;font-weight:700;\">Quer aprender na pr\u00e1tica com especialistas?<\/p>\n<p style=\"margin:0 0 24px;font-size:15px;color:#1f2937;font-weight:400;\">A JRT Technology Solutions oferece treinamentos e implementa\u00e7\u00e3o de Oracle SQL para equipes corporativas.<\/p>\n<p>  <a href=\"https:\/\/api.whatsapp.com\/send\/?phone=5521980606699&#038;text=Ol%C3%A1%21+Tenho+interesse+no+treinamento+de+Oracle%20SQL.&#038;type=phone_number&#038;app_absent=0\"\n     target=\"_blank\" rel=\"noopener noreferrer\"\n     style=\"display:inline-flex;align-items:center;gap:12px;background:#25D366;color:#ffffff;font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',sans-serif;font-size:16px;font-weight:600;padding:14px 28px;border-radius:100px;text-decoration:none;box-shadow:0 4px 12px rgba(37,211,102,0.4);letter-spacing:0.01em;\"><br \/>\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"22\" height=\"22\" viewBox=\"0 0 24 24\" fill=\"#ffffff\">\n      <path d=\"M17.472 14.382c-.297-.149-1.758-.867-2.03-.967-.273-.099-.471-.148-.67.15-.197.297-.767.966-.94 1.164-.173.199-.347.223-.644.075-.297-.15-1.255-.463-2.39-1.475-.883-.788-1.48-1.761-1.653-2.059-.173-.297-.018-.458.13-.606.134-.133.298-.347.446-.52.149-.174.198-.298.298-.497.099-.198.05-.371-.025-.52-.075-.149-.669-1.612-.916-2.207-.242-.579-.487-.5-.669-.51-.173-.008-.371-.01-.57-.01-.198 0-.52.074-.792.372-.272.297-1.04 1.016-1.04 2.479 0 1.462 1.065 2.875 1.213 3.074.149.198 2.096 3.2 5.077 4.487.709.306 1.262.489 1.694.625.712.227 1.36.195 1.871.118.571-.085 1.758-.719 2.006-1.413.248-.694.248-1.289.173-1.413-.074-.124-.272-.198-.57-.347m-5.421 7.403h-.004a9.87 9.87 0 01-5.031-1.378l-.361-.214-3.741.982.998-3.648-.235-.374a9.86 9.86 0 01-1.51-5.26c.001-5.45 4.436-9.884 9.888-9.884 2.64 0 5.122 1.03 6.988 2.898a9.825 9.825 0 012.893 6.994c-.003 5.45-4.437 9.884-9.885 9.884m8.413-18.297A11.815 11.815 0 0012.05 0C5.495 0 .16 5.335.157 11.892c0 2.096.547 4.142 1.588 5.945L.057 24l6.305-1.654a11.882 11.882 0 005.683 1.448h.005c6.554 0 11.89-5.335 11.893-11.893a11.821 11.821 0 00-3.48-8.413z\"\/>\n    <\/svg><br \/>\n    Falar no WhatsApp<br \/>\n  <\/a>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Explore as fun\u00e7\u00f5es SUBSTR, INSTR e ROUND no Oracle para manipula\u00e7\u00e3o de strings e n\u00fameros. Aprofunde suas habilidades SQL nesta aula imprescind\u00edvel!<\/p>\n","protected":false},"author":1,"featured_media":833,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"iawp_total_views":0,"footnotes":""},"categories":[75],"tags":[1459,1461,1456,1458,1462,1454],"class_list":["post-835","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops","tag-funcoes-de-string-oracle","tag-funcoes-numericas-oracle","tag-instr-oracle","tag-round-oracle","tag-sql-oracle-funcoes","tag-substr-oracle"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.8 - aioseo.com -->\n\t<meta name=\"description\" content=\"Explore as fun\u00e7\u00f5es SUBSTR, INSTR e ROUND no Oracle para manipula\u00e7\u00e3o de strings e n\u00fameros. Aprofunde suas habilidades SQL nesta aula imprescind\u00edvel!\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Thiago Paes Rodrigues\"\/>\n\t<meta name=\"google-site-verification\" content=\"QKPfpDCzHmzKyfFk5j1KZW3HhROYTPeqwBN5qcJ8qcg\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.8\" \/>\n\t\t<meta property=\"og:locale\" content=\"pt_BR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"BLOG - JRT Technology Solutions - Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle - BLOG - JRT Technology Solutions\" \/>\n\t\t<meta property=\"og:description\" content=\"Explore as fun\u00e7\u00f5es SUBSTR, INSTR e ROUND no Oracle para manipula\u00e7\u00e3o de strings e n\u00fameros. Aprofunde suas habilidades SQL nesta aula imprescind\u00edvel!\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"100\" \/>\n\t\t<meta property=\"og:image:height\" content=\"75\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-05-31T16:00:20+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-05-31T16:00:20+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=61590814880509\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle - BLOG - JRT Technology Solutions\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Explore as fun\u00e7\u00f5es SUBSTR, INSTR e ROUND no Oracle para manipula\u00e7\u00e3o de strings e n\u00fameros. Aprofunde suas habilidades SQL nesta aula imprescind\u00edvel!\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#blogposting\",\"name\":\"Aula 11: Fun\\u00e7\\u00f5es de string e num\\u00e9ricas \\u2014 SUBSTR, INSTR, ROUND no Oracle - BLOG - JRT Technology Solutions\",\"headline\":\"Aula 11: Fun\\u00e7\\u00f5es de string e num\\u00e9ricas \\u2014 SUBSTR, INSTR, ROUND no Oracle\",\"author\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/ai-image-1780243216922.jpg\",\"width\":1024,\"height\":576,\"caption\":\"Aula 11: Fun\\u00e7\\u00f5es de string e num\\u00e9ricas \\u2014 SUBSTR, INSTR, ROUND no Oracle\"},\"datePublished\":\"2026-05-31T13:00:20-03:00\",\"dateModified\":\"2026-05-31T13:00:20-03:00\",\"inLanguage\":\"pt-BR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#webpage\"},\"articleSection\":\"DevOps, fun\\u00e7\\u00f5es de string Oracle, fun\\u00e7\\u00f5es num\\u00e9ricas Oracle, INSTR Oracle, ROUND Oracle, SQL Oracle fun\\u00e7\\u00f5es, SUBSTR Oracle\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jrtx.com.br\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/#listItem\",\"name\":\"DevOps\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/#listItem\",\"position\":2,\"name\":\"DevOps\",\"item\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#listItem\",\"name\":\"Aula 11: Fun\\u00e7\\u00f5es de string e num\\u00e9ricas \\u2014 SUBSTR, INSTR, ROUND no Oracle\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#listItem\",\"position\":3,\"name\":\"Aula 11: Fun\\u00e7\\u00f5es de string e num\\u00e9ricas \\u2014 SUBSTR, INSTR, ROUND no Oracle\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/category\\\/devops\\\/#listItem\",\"name\":\"DevOps\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#organization\",\"name\":\"JRT Technology Solutions | Tecnologia e Inova\\u00e7\\u00e3o para Empresas\",\"description\":\"Um espa\\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\\u00e1tica e atual. Aqui voc\\u00ea encontra novidades, an\\u00e1lises, tutoriais e reflex\\u00f5es sobre inova\\u00e7\\u00e3o, intelig\\u00eancia artificial, gadgets, programa\\u00e7\\u00e3o e tend\\u00eancias digitais. Nosso objetivo \\u00e9 simplificar o complexo, ajudar voc\\u00ea a se manter atualizado e transformar conhecimento em pr\\u00e1tica no seu dia a dia.\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/\",\"telephone\":\"+552138277513\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/cropped-logo-mini.jpg\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#organizationLogo\",\"width\":100,\"height\":75},\"image\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#organizationLogo\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/profile.php?id=61590814880509\",\"https:\\\/\\\/www.instagram.com\\\/jrtx.tech\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/\",\"name\":\"Thiago Paes Rodrigues\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/3cdfdf5f766c59d9c9acab959751c31c3442acd94d4b2927c51d2a0c31b50822?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Thiago Paes Rodrigues\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#webpage\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/\",\"name\":\"Aula 11: Fun\\u00e7\\u00f5es de string e num\\u00e9ricas \\u2014 SUBSTR, INSTR, ROUND no Oracle - BLOG - JRT Technology Solutions\",\"description\":\"Explore as fun\\u00e7\\u00f5es SUBSTR, INSTR e ROUND no Oracle para manipula\\u00e7\\u00e3o de strings e n\\u00fameros. Aprofunde suas habilidades SQL nesta aula imprescind\\u00edvel!\",\"inLanguage\":\"pt-BR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/author\\\/thiago\\\/#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/05\\\/ai-image-1780243216922.jpg\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#mainImage\",\"width\":1024,\"height\":576,\"caption\":\"Aula 11: Fun\\u00e7\\u00f5es de string e num\\u00e9ricas \\u2014 SUBSTR, INSTR, ROUND no Oracle\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/2026\\\/05\\\/31\\\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\\\/#mainImage\"},\"datePublished\":\"2026-05-31T13:00:20-03:00\",\"dateModified\":\"2026-05-31T13:00:20-03:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/\",\"name\":\"JRT Technology Solutions | Tecnologia e Inova\\u00e7\\u00e3o para Empresas\",\"alternateName\":\"JRT Technology Solutions | Tecnologia e Inova\\u00e7\\u00e3o para Empresas\",\"description\":\"Um espa\\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\\u00e1tica e atual. Aqui voc\\u00ea encontra novidades, an\\u00e1lises, tutoriais e reflex\\u00f5es sobre inova\\u00e7\\u00e3o, intelig\\u00eancia artificial, gadgets, programa\\u00e7\\u00e3o e tend\\u00eancias digitais. Nosso objetivo \\u00e9 simplificar o complexo, ajudar voc\\u00ea a se manter atualizado e transformar conhecimento em pr\\u00e1tica no seu dia a dia.\",\"inLanguage\":\"pt-BR\",\"publisher\":{\"@id\":\"https:\\\/\\\/jrtx.com.br\\\/blog\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle - BLOG - JRT Technology Solutions","description":"Explore as fun\u00e7\u00f5es SUBSTR, INSTR e ROUND no Oracle para manipula\u00e7\u00e3o de strings e n\u00fameros. Aprofunde suas habilidades SQL nesta aula imprescind\u00edvel!","canonical_url":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"QKPfpDCzHmzKyfFk5j1KZW3HhROYTPeqwBN5qcJ8qcg","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#blogposting","name":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle - BLOG - JRT Technology Solutions","headline":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle","author":{"@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author"},"publisher":{"@id":"https:\/\/jrtx.com.br\/blog\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/05\/ai-image-1780243216922.jpg","width":1024,"height":576,"caption":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle"},"datePublished":"2026-05-31T13:00:20-03:00","dateModified":"2026-05-31T13:00:20-03:00","inLanguage":"pt-BR","mainEntityOfPage":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#webpage"},"isPartOf":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#webpage"},"articleSection":"DevOps, fun\u00e7\u00f5es de string Oracle, fun\u00e7\u00f5es num\u00e9ricas Oracle, INSTR Oracle, ROUND Oracle, SQL Oracle fun\u00e7\u00f5es, SUBSTR Oracle"},{"@type":"BreadcrumbList","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog#listItem","position":1,"name":"Home","item":"https:\/\/jrtx.com.br\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/category\/devops\/#listItem","name":"DevOps"}},{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/category\/devops\/#listItem","position":2,"name":"DevOps","item":"https:\/\/jrtx.com.br\/blog\/category\/devops\/","nextItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#listItem","name":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle"},"previousItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#listItem","position":3,"name":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle","previousItem":{"@type":"ListItem","@id":"https:\/\/jrtx.com.br\/blog\/category\/devops\/#listItem","name":"DevOps"}}]},{"@type":"Organization","@id":"https:\/\/jrtx.com.br\/blog\/#organization","name":"JRT Technology Solutions | Tecnologia e Inova\u00e7\u00e3o para Empresas","description":"Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.","url":"https:\/\/jrtx.com.br\/blog\/","telephone":"+552138277513","logo":{"@type":"ImageObject","url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#organizationLogo","width":100,"height":75},"image":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#organizationLogo"},"sameAs":["https:\/\/www.facebook.com\/profile.php?id=61590814880509","https:\/\/www.instagram.com\/jrtx.tech\/"]},{"@type":"Person","@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author","url":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/","name":"Thiago Paes Rodrigues","image":{"@type":"ImageObject","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/3cdfdf5f766c59d9c9acab959751c31c3442acd94d4b2927c51d2a0c31b50822?s=96&d=mm&r=g","width":96,"height":96,"caption":"Thiago Paes Rodrigues"}},{"@type":"WebPage","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#webpage","url":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/","name":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle - BLOG - JRT Technology Solutions","description":"Explore as fun\u00e7\u00f5es SUBSTR, INSTR e ROUND no Oracle para manipula\u00e7\u00e3o de strings e n\u00fameros. Aprofunde suas habilidades SQL nesta aula imprescind\u00edvel!","inLanguage":"pt-BR","isPartOf":{"@id":"https:\/\/jrtx.com.br\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#breadcrumblist"},"author":{"@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author"},"creator":{"@id":"https:\/\/jrtx.com.br\/blog\/author\/thiago\/#author"},"image":{"@type":"ImageObject","url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/05\/ai-image-1780243216922.jpg","@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#mainImage","width":1024,"height":576,"caption":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle"},"primaryImageOfPage":{"@id":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/#mainImage"},"datePublished":"2026-05-31T13:00:20-03:00","dateModified":"2026-05-31T13:00:20-03:00"},{"@type":"WebSite","@id":"https:\/\/jrtx.com.br\/blog\/#website","url":"https:\/\/jrtx.com.br\/blog\/","name":"JRT Technology Solutions | Tecnologia e Inova\u00e7\u00e3o para Empresas","alternateName":"JRT Technology Solutions | Tecnologia e Inova\u00e7\u00e3o para Empresas","description":"Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.","inLanguage":"pt-BR","publisher":{"@id":"https:\/\/jrtx.com.br\/blog\/#organization"}}]},"og:locale":"pt_BR","og:site_name":"BLOG - JRT Technology Solutions - Um espa\u00e7o dedicado a explorar o universo da tecnologia de forma clara, pr\u00e1tica e atual. Aqui voc\u00ea encontra novidades, an\u00e1lises, tutoriais e reflex\u00f5es sobre inova\u00e7\u00e3o, intelig\u00eancia artificial, gadgets, programa\u00e7\u00e3o e tend\u00eancias digitais. Nosso objetivo \u00e9 simplificar o complexo, ajudar voc\u00ea a se manter atualizado e transformar conhecimento em pr\u00e1tica no seu dia a dia.","og:type":"article","og:title":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle - BLOG - JRT Technology Solutions","og:description":"Explore as fun\u00e7\u00f5es SUBSTR, INSTR e ROUND no Oracle para manipula\u00e7\u00e3o de strings e n\u00fameros. Aprofunde suas habilidades SQL nesta aula imprescind\u00edvel!","og:url":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/","og:image":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","og:image:secure_url":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg","og:image:width":100,"og:image:height":75,"article:published_time":"2026-05-31T16:00:20+00:00","article:modified_time":"2026-05-31T16:00:20+00:00","article:publisher":"https:\/\/www.facebook.com\/profile.php?id=61590814880509","twitter:card":"summary_large_image","twitter:title":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle - BLOG - JRT Technology Solutions","twitter:description":"Explore as fun\u00e7\u00f5es SUBSTR, INSTR e ROUND no Oracle para manipula\u00e7\u00e3o de strings e n\u00fameros. Aprofunde suas habilidades SQL nesta aula imprescind\u00edvel!","twitter:image":"https:\/\/jrtx.com.br\/blog\/wp-content\/uploads\/2026\/03\/cropped-logo-mini.jpg"},"aioseo_meta_data":{"post_id":"835","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"limit_modified_date":false,"ai":null,"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-06-22 19:08:51","updated":"2026-06-22 19:08:51"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/jrtx.com.br\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/jrtx.com.br\/blog\/category\/devops\/\" title=\"DevOps\">DevOps<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">&raquo;<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tAula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/jrtx.com.br\/blog"},{"label":"DevOps","link":"https:\/\/jrtx.com.br\/blog\/category\/devops\/"},{"label":"Aula 11: Fun\u00e7\u00f5es de string e num\u00e9ricas \u2014 SUBSTR, INSTR, ROUND no Oracle","link":"https:\/\/jrtx.com.br\/blog\/2026\/05\/31\/aula-11-funcoes-de-string-e-numericas-substr-instr-round-no\/"}],"_links":{"self":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts\/835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/comments?post=835"}],"version-history":[{"count":0,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/posts\/835\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/media\/833"}],"wp:attachment":[{"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/media?parent=835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/categories?post=835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jrtx.com.br\/blog\/wp-json\/wp\/v2\/tags?post=835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}