Posts by Victor Freidinger • 339 points
16 posts
-
4
votes2
answers51
viewsA: How to check if a character set exists in the table column?
In addition, use the option Upper/Lower for best use. SELECT * FROM usuarios WHERE upper(nome) LIKE upper('%Silva%'). So you guarantee that the result will be 'Silva', no matter how you write it…
-
0
votes1
answer250
viewsA: View much slower than direct mysql query
Hello, It’s a little strange to query, but, I would try to make a Join (left or Inner, depends on your need) instead of using everything in Where. One thing I also noticed is that you have 2 fields…
-
1
votes2
answers67
viewsA: How to calculate the value of two subquery in Oracle SQL
Try to perform a subselect of that information: select dados1+dados2 from (Select (select seuselectdados1) as dados1 , (select seuselectdados2) as dados2 from table ) as tab_temp…
-
0
votes1
answer174
viewsA: add and split results in the same query by taking the result of the first sum
Try using a subselect: Select Sum(Tabela.campoN+retSql.PrimeiraSoma) From (select suatabela.periodo AS PrimeiraSoma , suatabela.classificacao from suatabela ) AS retSql Inner Join Tabela ON…
-
0
votes2
answers70
viewsA: Doubt in an SQL DISTINCT
The DISTINCT function makes you bring different data, grouping the same information into as few lines as possible. If you have different data in the CD_CONTRATO field, it is not possible to bring…
-
0
votes1
answer20
viewsA: Oracle Loader Help - Variable Field
You can create a variable and initialize it as 1. In Insert you add it, after Insert checks and modifies it: if variavel == 1 then variavel := 2 else variavel := 1 endif I hope I’ve helped.…
pl-sqlanswered Victor Freidinger 339 -
1
votes3
answers70
viewsA: SQL with two different information
Try to use UNION: SELECT COUNT( codticket ) , usuario FROM vw_tkt_total INNER JOIN usuarios ON codusuario = id WHERE anofechamento = '$ano' AND STATUS IN ( 3, 13 ) AND ativo = '1' GROUP BY usuario…
-
5
votes2
answers256
viewsA: Concatenate columns and return the relation by SELECT
Select simple: select * from Tabela A inner join Tabela B on A.Col1 = B.Col1 inner join Tabela C on A.Col1 = C.Col1 left join Tabela D on B.Col1 = D.Col2+D.Col3 I used left Join for table D here…
-
4
votes2
answers372
viewsA: Qt - Check if table is empty in the database
Tries to change the select, makes a SELECT COUNT(CAMPO) FROM TABELA (Select Count(id) from va_admins no seu caso). This way you can get a result of how many records you have.…
-
0
votes1
answer328
viewsA: Cannot read Property 'map' of Undefined error in Browse (Angular)
Found the problem: An import was missing: import 'rxjs/add/operator/toPromise'; in category.service.ts I arrived at this result after the return of @Guilherme Nascimento to tell me that . map() was…
angularanswered Victor Freidinger 339 -
-1
votes1
answer328
viewsQ: Cannot read Property 'map' of Undefined error in Browse (Angular)
Hello, When I access my page, error appears in Browse: Typeerror occurred Typeerror: Cannot read Property 'map' of Undefined. My code containing the call . map() is like this: export class…
angularasked Victor Freidinger 339 -
3
votes2
answers106
viewsQ: Infinite Loop when reading Scanner values
My goal is to deposit in several notes (10, 20, 50 and 100). For this, in the method main left so: static Scanner lerInfo = new Scanner(System.in); public static void main(String[] args) { int nOpc…
-
0
votes3
answers4406
viewsA: Error Full Authentication is required to access this Resource
Hello, For anyone who has the same problem as me, I have found the following solution: In building my Header I changed to this: pesquisar() { const httpOptions = { headers: new HttpHeaders({…
-
1
votes3
answers4406
viewsQ: Error Full Authentication is required to access this Resource
Hello, I have a backend made with Spring and I Gero a file . jar and 'raise' it via Vscode to the front made in Angular. When I try to access my page (everything is localhost), I get this return:…
-
0
votes1
answer28
viewsQ: Is it possible to turn validation into form error in Angular?
It’s kind of hard to explain. I have a form that checks a field if it is greater than zero. If so, I show a message to the user. I want to turn this into a form error, because I can only release the…
-
-1
votes1
answer340
viewsQ: Ordering of Dropdown Angular4
Hello, I have a state field (UF) that is as dropdown and would like to sort it (by name). Could you please give me a north? My code is like this today: estados = [ {label: 'Acre', value: 'AC'},…