Posts by alexjosesilva • 3,119 points
279 posts
-
0
votes3
answers127
viewsA: Select dates less than a given year
I got it with this piece of code: select * from tfuncionario F where F.ANOADMISSAO <= ('01/01/00');
-
0
votes3
answers127
viewsQ: Select dates less than a given year
How can I create select to show only employees of a company who have been admitted to it before a certain year ? The type anoAdmissao is date ie: dd-mm-AA…
-
0
votes1
answer1287
viewsA: How to view SQL History in SQL Developer?
On the screens below just click on the history tab to view the changes made the file.…
-
0
votes1
answer38
viewsA: Error recreating new ssh key: gitconfig: Permission denied
I could not fix the folder permission. I then chose to reinstall everything again: Soon after everything started working again: Generate the key . ssh (it is necessary to create an SSH folder within…
-
0
votes1
answer1039
viewsA: Error while creating . ssh folder in windows
Able to generate the . ssh key in windows. After manually creating the SSH folder in the /GNU directory (this folder is created after the default installation in windows) After that I executed the…
-
-1
votes1
answer571
viewsA: Folder . ssh is not created when generating the ssh-keygen -t rsa -C command "[email protected]"
Able to generate the . ssh key in windows. After manually creating the SSH folder in the /GNU directory (this folder is created after the default installation in windows) After that I executed the…
-
1
votes1
answer1039
viewsQ: Error while creating . ssh folder in windows
When I execute the command $ ssh-keygen -t rsa -C "[email protected]" get the error message: Generating public/private rsa key pair. Enter file in which to save the key (/c/Program Files…
-
0
votes1
answer38
viewsQ: Error recreating new ssh key: gitconfig: Permission denied
On the computer I work, there was another user. However I have to create a new ssh key and a new user. But when I execute the commands: $ git config --global user.name "alex Jose silva" I get the…
-
0
votes3
answers1756
viewsA: How to declare a cursor variable in PL-SQL?
Great answers. I managed to run the functionality with this code: DECLARE --Declaracao do curso Cursor c_fun is Select nome From TFUNCIONARIO; --Declaraão da variavel nfun c_fun%rowtype; BEGIN --…
-
2
votes3
answers1756
viewsQ: How to declare a cursor variable in PL-SQL?
I have a course: Cursor Pessoa is Select nomeFuncionario From empresa; -- Variaveis para uso da rotina variavel How would the variable ?
-
1
votes1
answer1287
viewsQ: How to view SQL History in SQL Developer?
I need to view all changes in a trial. The SQL Developer tool has a toolbar that stores a history of changes. How can I enable/view ? Image of the fuctionality…
-
2
votes1
answer2546
viewsQ: How do I know if a column exists in an Oracle table?
I’m trying to add a new column to an Oracle table, and I want to know if it already exists or not. I’ve tried something like this: IF EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE…
-
0
votes1
answer268
viewsA: How to display two tables in Sqldeveloper at the same time?
Be able to view only my tables by following these steps: Right-clicking on the connection In the menu that opens, choose Apply Filter... Fill according to the image: Upshot:…
-
0
votes1
answer268
viewsQ: How to display two tables in Sqldeveloper at the same time?
I am unable to filter two tables at the same time in SQL Developer at the same time. When I insert two tables into the same filter sqldeveloper shows nothing!…
-
0
votes0
answers684
viewsQ: Oracle error ora-06550 pls-00103:
I have this PL-SQL code: /*1. Criar um bloco PL/SQL anônimo para imprimir a tabuada abaixo:*/ DECLARE VN CONSTANT NUMBER(2) := 5; BEGIN FOR i IN 1..1O LOOP DBMS_OUTPUT.PUT_(VN || ' X ' || i ||'='||…
-
0
votes0
answers294
viewsQ: Error while displaying message in PL-SQL
Code DECLARE BEGIN FOR I IN (SELECT * FROM PRODUTOS_TESTE2) LOOP DBMS_OUTPUT.PUT_LINE(I.codigo|| ' - ' || I.categoria || ' - ' || I.VALOR); END LOOP; END; Error message: Relatório de erros -…
-
1
votes1
answer111
viewsQ: Error using Case and Select in PL-SQL
I have this code: DECLARE BEGIN SELECT p.categoria( CASE WHEN p.categoria = 'A' THEN DBMS_OUTPUT.PUT_LINE('A') ELSE 2000 END ) FROM PRODUTO_TESTE2 p; END; Error message: Bug report - ORA-06550: line…
-
0
votes1
answer551
viewsQ: In PL-SQL how to partially add a value?
I have to add the value partially the values of a category (goes the code below) DECLARE --VARAVEIS CURSOR CPRODUTO IS SELECT * FROM PRODUTO_TESTE2; VPRODUTO PRODUTO_TESTE2%ROWTYPE; Vsoma real;…
-
0
votes1
answer616
viewsQ: In pl-sql can I assign the SUM value to a variable?
In the system has a variable vsoma which shall receive the total sum of the column Values. How can I assign the sum value SELECT sum(valor) from PRODUTOS2?…
-
0
votes1
answer1960
viewsQ: How to call another Procedure or Function within the same Packge in oracle?
I have rods procedures and functions within the same package. How can I reference some within my PL-SQL code? PACKAGE: CAIXA1 PROCEDURE: CLOSE BOX, SUM TOTAL FUNCTION: TOTALGRADES How can I…
-
0
votes1
answer214
viewsA: How to run PROCEDURE and FUNCTION at the same time?
I’ll use the anonymity code to answer my question: DECLARE /*Testar se o codigo é valido*/ FUNCTION TESTE(cod number) RETURN BOOLEAN IS begin if(cod>0)then return true; end if; return false;…
-
0
votes1
answer214
viewsQ: How to run PROCEDURE and FUNCTION at the same time?
I have this plsql code and I must run at the same time: /*Testar se o codigo é valido*/ CREATE OR REPLACE FUNCTION TESTE1(cod number) RETURN BOOLEAN IS begin if(cod>0)then return true; end if;…
-
0
votes1
answer138
viewsQ: Error After Running Error: No output displayed
Code CREATE OR REPLACE PROCEDURE buscaturma(cod NUMBER) AS nomeT varchar2(20); BEGIN IF (cod=0)then dbms_output.put_line('ZERO'); ELSE SELECT DS_TURMA into nomeT FROM TURMA WHERE CD_TURMA = cod;…
-
1
votes1
answer1277
viewsQ: Error running Procedure on oracle
I got this trial: CREATE OR REPLACE PROCEDURE buscaturma(cod in INTEGER) AS nomeT varchar2(20); BEGIN dbms_output.put_line('inicio'); IF (cod=0)then dbms_output.put_line('ZERO'); ELSE SELECT…
-
1
votes1
answer72
viewsQ: Error running Function in PL/SQL
Code CREATE OR REPLACE FUNCTION BuscaNome RETURN t_name IS t_name VARCHAR(20); BEGIN SELECT T.DS_TURMA INTO t_name FROM TURMA T WHERE T.CD_TURMA = 13; RETURN t_name; END; Error: Error: PL/SQL:…
-
1
votes1
answer378
viewsQ: Error creating file in oracle
When declaring the name of a trial in sqldevelope get that message Erro: ORA-00972: identifier is too long Example of nomenclature: PRC_IMVW_TISS_VERIFICA_ELEGIBILIDADE CREATE OR REPLACE PROCEDURE…
-
0
votes1
answer275
viewsQ: How to compare two fields of identical values to different sizes?
I have a database in which have fields with the same name but with different size I need to pick the field with the larger VARCHAR. How can I do that ?…
-
0
votes2
answers321
viewsA: Error installing jdbc oracle in eclipse
Can solve using two steps: Running the command: mvn install:install-file -Dfile=C: Users alex.jose.silva Dow nloads ojdbc7.jar -Dgroupid=com.oracle -Dartifactid=ojdbc7 -Dversion=12.1.0…
-
-1
votes2
answers321
viewsQ: Error installing jdbc oracle in eclipse
I am finding impediments in the installation of oracle jdbc. Canvas Error message: Error Reading file C: Users alex.jose.silva.m2 Repository with oracle ojdbc14 10.2.0.3.0 ojdbc14-10.2.0.3.0.jar C:…
-
0
votes1
answer111
viewsQ: Error in persistence.xml when connecting oracle database
I have this file to perform oracle database persistence. However do not connect! <?xml version="1.0" encoding="UTF-8"?> <persistence xmlns="http://java.sun.com/xml/ns/persistence"…
-
0
votes1
answer67
viewsA: Error Request Resource is not avaliable
Corrected: I was giving the wrong package name: <context:component-scan base-package="br.com.tutorialweb.controller"/> To: <context:component-scan base-package="br.com.controller"/>…
-
0
votes1
answer67
viewsQ: Error Request Resource is not avaliable
I have this class in JAVA package br.com.controller; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import…
-
1
votes1
answer212
viewsQ: Java @Path and @Produces error
Error in the use of @Path in Java. package resource; import java.util.ArrayList; import java.util.List; import java.nio.file.Path; import java.nio.file.Paths; import domain.Album; import…
-
1
votes1
answer103
viewsQ: Error inserting date in sprint in jira
When I try to start my sprint this error appears in jira…
-
-1
votes1
answer7646
viewsQ: Route.get() requires a callback Function but got a [Object Undefined]
In an application nodejs I get this error message: Version: Date of publication: 8.9.2 npm: 5.5.1 express: 4.15.5 Error image: Code from the app.js /** * Module dependencies. */ var http =…
-
0
votes1
answer132
viewsQ: Error: Most Middleware in app nodejs
Running application nodejs. got this error: I ran my application with the command Node app.js Versions: Date of publication: 8.9.2 npm: 5.5.1 express: 4.15.5 Code app.js: /** * Module dependencies.…
-
0
votes0
answers26
viewsQ: Is there an environment for Nodejs cloud development?
Study at a college that has not yet homologous nodejs in the equipment. However, where can I find a cloud environment to develop my nodejs and Expression applications ?
-
1
votes1
answer27
viewsQ: Windows Powershell Azure Login Error
Data: sdk from Azure downloaded Windows: 10 Error logging into Azure by powershell: How to correct this error ?…
-
0
votes0
answers51
viewsQ: How to test daylight saving time in PHP?
There is an app developed in PHP which returns the time of delivery of an order. However, as we are in daylight time the date is coming wrong. How can I fix this in php ?
-
8
votes1
answer8579
viewsQ: Is there a Timezone for Brasilia?
I am developing an app in PHP. And I need to set Timezone for Brasilia. However in the php documentation I have: $timezones = array( 'AC' => 'America/Rio_branco', 'AL' => 'America/Maceio',…
-
0
votes2
answers2956
viewsQ: Error inserting Data into Mysql
I have this query to insert a data into the database: INSERT INTO `bancoTeste`.`TabelaTeste` (`t_id`,`t_label`, `t_parametro`, `t_valor`, `t_descricao`, `t_valores_padrao`, `t_tipo`) VALUES…
-
0
votes1
answer141
viewsQ: Error on date output in full: decimal number goes up to 5
when entering the numeric values to be converted to Spellnumber, there is a lack of letters value | output 25.25 | Twenty here five royal and twenty here five cents. - missing letter 'and' 225.25 |…
-
-1
votes2
answers132
viewsQ: How to insert a letter between two words in a php string?
I have to insert a monosyllable between two words inside a PHP string, as in the examples below: // entrada string=> vinte cinco // saída string=> vinte e cinco // entrada string=> vinte…
phpasked alexjosesilva 3,119 -
4
votes2
answers1420
viewsQ: How to prevent the user from making changes to the input?
I have a input in a form, however it should not have its value changed: <input type="text" name="pais" value=""> How can I stop the value from being changed? <!DOCTYPE html> <html>…
-
0
votes1
answer640
viewsQ: To assign value to the input field after selecting item in Select
I have a select field with a list of names, after selecting one of them I have to assign a value in the database to an input field.…
-
5
votes2
answers290
viewsQ: How to debug Nodejs code?
In my initial studies in web development with NODEJS I have the following question: a tool to debug NODEJS codes in a Web system ?
-
2
votes0
answers888
viewsQ: What are the main project standards in NODEJS for Web Development?
I am starting my studies in Nodejs and need to know what the main project standards for Web Development in Nodejs.
-
15
votes4
answers15459
viewsQ: What is the difference between LIKE, IN and BETWEEN in Mysql?
I’m having doubts about the difference and use of tags LIKE, IN and BETWEEN in Mysql. When to use tags and example?
-
2
votes1
answer967
viewsQ: PHP: How to convert a number into a string?
I have an application that generates a PDF receipt. But in the bank the values have to be converted into words BD | PHP 10 | TEN 15 | FIFTEEN 7 | SEVEN there is some function that returns the string…
-
1
votes1
answer82
viewsA: SQL: Avoid repeating line and adding values
I was able to get the result with a command line: SUM( receipts.original_amount) Full answer: select DISTINCT (clients.name) as nomeempresa, SUM (payments.amount_paid) as pagamento, SUM…