{"id":576,"date":"2021-10-26T22:39:41","date_gmt":"2021-10-27T02:39:41","guid":{"rendered":"https:\/\/tecgesco.com\/blog\/?p=576"},"modified":"2023-05-30T08:58:35","modified_gmt":"2023-05-30T12:58:35","slug":"procedure-primeira-letra-maiuscula","status":"publish","type":"post","link":"https:\/\/tecgesco.com\/blog\/procedure-primeira-letra-maiuscula\/","title":{"rendered":"Procedure : Primeira letra ma\u00eduscula"},"content":{"rendered":"\n<p>A baixo segue c\u00f3digo fonte da procedure que recebe um texto de at\u00e9 100 caracteres e retorna o mesmo por\u00e9m com a primeira letra mai\u00fascula e as demais min\u00fasculas.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code>CREATE PROCEDURE PRIMEIRALETRAMAISCULA (PSTRING VARCHAR(100))\nRETURNS (RESULTADO VARCHAR(100))\nAS BEGIN\n\t\n\t with recursive r as (\n  select\n    substring(a.nome from 1 for 1) letra,\n    substring(a.nome from 2) restante,\n    iif(substring(a.nome from 1 for 1) = &#39; &#39;,&#39;S&#39;,&#39;N&#39;) ToUpper\n  from (\n    select\n      lower(&#39; &#39;||cast(:PSTRING as varchar(100))) nome\n    from rdb$database) a\n\n  union all\n\n  select\n    iif(r.toUpper = &#39;S&#39;,upper(substring(r.restante from 1 for 1)),substring(r.restante from 1 for 1)),\n    substring(r.restante from 2),\n    iif(substring(r.restante from 1 for 1) = &#39; &#39;,&#39;S&#39;,&#39;N&#39;) ToUpper\n  from r\n  where r.restante &lt;&gt; &#39;&#39;) select trim(list(r.letra, &#39;&#39;)) from r INTO RESULTADO;\n \n SUSPEND;\n\t \n END<\/code><\/pre><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Como chamar essa procedure ?<\/h3>\n\n\n\n<p>Para chamar essa procedure, use o seguinte c\u00f3digo:<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-sql\" data-lang=\"SQL\"><code> SELECT * FROM PRIMEIRALETRAMAISCULA(&#39;TEXTO TESTE&#39;);<\/code><\/pre><\/div>\n\n\n\n<p>Observe como fica o resultado ap\u00f3s execu\u00e7\u00e3o.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"474\" height=\"154\" src=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2021\/10\/image-3.png\" alt=\"\" class=\"wp-image-579\" srcset=\"https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2021\/10\/image-3.png 474w, https:\/\/tecgesco.com\/blog\/wp-content\/uploads\/2021\/10\/image-3-300x97.png 300w\" sizes=\"auto, (max-width: 474px) 100vw, 474px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>A baixo segue c\u00f3digo fonte da procedure que recebe um texto de at\u00e9 100 caracteres e retorna o mesmo por\u00e9m com a primeira letra mai\u00fascula e as demais min\u00fasculas. Como chamar essa procedure ? Para chamar essa procedure, use o seguinte c\u00f3digo: Observe como fica o resultado ap\u00f3s execu\u00e7\u00e3o.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5],"tags":[99,117,127,126,113,128],"class_list":["post-576","post","type-post","status-publish","format-standard","hentry","category-tecnico","tag-firebird","tag-funcao","tag-primeira-letra-maiscula","tag-procedure","tag-select","tag-uppercase"],"_links":{"self":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/comments?post=576"}],"version-history":[{"count":5,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/576\/revisions"}],"predecessor-version":[{"id":1082,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/posts\/576\/revisions\/1082"}],"wp:attachment":[{"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/media?parent=576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/categories?post=576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tecgesco.com\/blog\/wp-json\/wp\/v2\/tags?post=576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}