Posts by Ari • 356 points
11 posts
-
3
votes1
answer2582
viewsA: How to find the foreign from one table to another by Oracle?
With this select you can see the parent and daughter tables select f.table_name, t.table_name, t.column_name, f.constraint_name, t.owner from all_cons_columns t, all_constraints f where f.r_owner =…
-
2
votes4
answers3830
viewsA: Compare number within a numerical range
the simplest would be: private bool VerificaIntervalo(int numero) { if(numero >= 1 && numero <= 25) return true; else return false; }
-
2
votes1
answer368
viewsA: How to implement product returns?
I believe that the modeling of returns should be thought about the products, also because the customer can return a product from a kit today and after a few days return another product from the same…
-
2
votes1
answer76
viewsA: Help to know what is wrong
You can make the following comparison: if (System.Text.RegularExpressions.Regex.IsMatch(e.Key.ToString(),"[0-9]|.")) { e.Handled = false; } else { else e.Handled = true; }…
-
3
votes2
answers64
viewsA: SELECT returning data not seen by a particular user
This way you’ll get select v.* from videos v where v.video_id not in (select t.video_id video_visualizacoes t where t.conta_id=v.conta_id) and v.conta_id= id
-
1
votes2
answers481
viewsA: Doubt of C++ loop do-while
I advise you to use the getchar(). To work with the scanf you should clean the buffer with flush(stdin) because the enter \n stays in the stdin.…
-
0
votes1
answer63
viewsA: remove sql zeros
You can do this through REGEX: select REGEXP_REPLACE(campo,'EUW.1.','EUW1') from tabela Thus the previous and subsequent '0' to 1 will be discarded.
-
1
votes2
answers253
viewsA: Regex - Regular Expression
I also didn’t quite understand your question, but the following Regex meets your password rule: ((?=.*[A-Z])(?=.*[@#$!%!]).{8,30}) In the stretch (?=.*[@#$!%!]) You must place between brackets the…
-
4
votes2
answers71
viewsA: Passing value of a VARCHAR variable in the WHERE IN command
Probably your error is in the call, try it this way: EXEC sp_listaFuncionarios @nome_dept = 'Marketing' You will have problems passing the parameter with these quotes. Perhaps it is better to filter…
-
2
votes1
answer89
viewsA: Sql query bringing the products that are with zero balance
You didn’t specify very well, but I believe this example will help you: select p.id_Prod, prod.Descricao from Produto_Departamento p inner join Produto prod on prod.Id_Prod=p.Id_Prod having…
-
1
votes2
answers1532
viewsA: Capture text between two known characters
The expression: ([a-z0-9])+(?=\})