Tagged: Oracle

Tutoriais e dicas sobre o banco de dados Oracle.

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="" decoding="async" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?w=1080&ssl=1 1080w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?resize=300%2C300&ssl=1 300w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?resize=1024%2C1024&ssl=1 1024w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?resize=768%2C768&ssl=1 768w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?resize=200%2C200&ssl=1 200w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?resize=740%2C740&ssl=1 740w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?resize=50%2C50&ssl=1 50w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="105403" data-permalink="https://terminaldeinformacao.com/2024/01/18/como-buscar-registros-que-tenham-somente-caracteres-maiusculos-no-sql/10-6/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?fit=1080%2C1080&ssl=1" data-orig-size="1080,1080" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="10" data-image-description="" data-image-caption="<p>Caixa alta no SQL</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?fit=300%2C300&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2023/02/10.png?fit=720%2C720&ssl=1" />

Como buscar registros que tenham somente caracteres maiúsculos no SQL

No artigo de hoje, iremos demonstrar em como identificar registros que estejam com seu conteúdo tudo em maiúsculo (ou pesquisar os que não estão)...

18 de janeiro de 2024

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/08/aquisicoes_00.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="" decoding="async" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/08/aquisicoes_00.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/08/aquisicoes_00.png?resize=200%2C200&ssl=1 200w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/08/aquisicoes_00.png?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/08/aquisicoes_00.png?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/08/aquisicoes_00.png?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="101625" data-permalink="https://terminaldeinformacao.com/2020/09/08/5-melhores-aquisicoes-empresariais-do-mundo-da-tecnologia/aquisicoes_00/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/08/aquisicoes_00.png?fit=1280%2C720&ssl=1" data-orig-size="1280,720" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="aquisicoes_00" data-image-description="" data-image-caption="<p>Lista Aquisições</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/08/aquisicoes_00.png?fit=300%2C169&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/08/aquisicoes_00.png?fit=720%2C405&ssl=1" />

5 melhores aquisições empresariais do mundo da tecnologia

Hoje vamos listar 5 aquisições que mexeram com o mundo da tecnologia.

8 de setembro de 2020

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/oracle_advpl.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="" decoding="async" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/oracle_advpl.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/oracle_advpl.png?resize=200%2C200&ssl=1 200w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/oracle_advpl.png?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/oracle_advpl.png?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/oracle_advpl.png?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="100431" data-permalink="https://terminaldeinformacao.com/2020/03/20/dica-sobre-controle-de-transacoes-em-advpl-com-oracle/oracle_advpl/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/oracle_advpl.png?fit=1280%2C720&ssl=1" data-orig-size="1280,720" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="oracle_advpl" data-image-description="" data-image-caption="<p>Oracle e AdvPL</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/oracle_advpl.png?fit=300%2C169&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2020/03/oracle_advpl.png?fit=720%2C405&ssl=1" />

Dica sobre controle de transações em AdvPL com Oracle

Hoje trago uma dica útil que foi compartilhada recentemente conosco.

20 de março de 2020

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2013/03/java-1.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="Linguagem Java" decoding="async" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2013/03/java-1.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2013/03/java-1.png?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2013/03/java-1.png?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2013/03/java-1.png?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2013/03/java-1.png?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="4921" data-permalink="https://terminaldeinformacao.com/2013/03/09/exemplos-de-funcoes-em-java/java-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2013/03/java-1.png?fit=2560%2C2048&ssl=1" data-orig-size="2560,2048" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="java" data-image-description="<p>Linguagem Java</p> " data-image-caption="<p>Linguagem Java</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2013/03/java-1.png?fit=300%2C240&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2013/03/java-1.png?fit=720%2C576&ssl=1" />

Linguagem Java

Desenvolvimento

Java será pago?

Salve salve pessoal… É verdade que as novas versões do Java serão pagas? Isso irá impactar os usuários comuns?

31 de maio de 2018

<img width="200" height="200" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/05/recuperar_senha.png?resize=200%2C200&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="Recuperando a senha em Oracle" decoding="async" srcset="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/05/recuperar_senha.png?resize=150%2C150&ssl=1 150w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/05/recuperar_senha.png?resize=144%2C144&ssl=1 144w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/05/recuperar_senha.png?resize=50%2C50&ssl=1 50w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/05/recuperar_senha.png?zoom=2&resize=200%2C200&ssl=1 400w, https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/05/recuperar_senha.png?zoom=3&resize=200%2C200&ssl=1 600w" sizes="(max-width: 200px) 100vw, 200px" data-attachment-id="5462" data-permalink="https://terminaldeinformacao.com/2014/05/07/recuperar-senha-de-usuario-no-oracle/recuperar_senha/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/05/recuperar_senha.png?fit=1137%2C546&ssl=1" data-orig-size="1137,546" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="recuperar_senha" data-image-description="<p>Recuperando a senha em Oracle</p> " data-image-caption="<p>Recuperando a senha em Oracle</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/05/recuperar_senha.png?fit=300%2C144&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/05/recuperar_senha.png?fit=720%2C346&ssl=1" />

Recuperando a senha em Oracle

Recuperar senha de usuário no Oracle

Olá pessoal… Hoje irei mostrar como recuperar a senha de um usuário em banco de dados Oracle. Recentemente tinha perdido a senha do usuário...

7 de maio de 2014

<img width="200" height="54" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/04/trigger_1.png?resize=200%2C54&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="Resultado" decoding="async" data-attachment-id="5454" data-permalink="https://terminaldeinformacao.com/2014/04/01/criando-triggers-no-oracle/trigger_1/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/04/trigger_1.png?fit=421%2C54&ssl=1" data-orig-size="421,54" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="trigger_1" data-image-description="<p>Resultado</p> " data-image-caption="<p>Resultado</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/04/trigger_1.png?fit=300%2C38&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2014/04/trigger_1.png?fit=421%2C54&ssl=1" />

Criando Triggers no Oracle

Olá pessoal… Hoje irei falar um pouco sobre Triggers (Gatilhos) em Oracle, qual a sua funcionalidade e como criar.

1 de abril de 2014