Posts by igor • 84 points
5 posts
-
2
votes1
answer116
viewsA: Possible Plugin to see if it is Responsive or not
The plugin Responsive Web Design Tester seems to be what you seek.…
responsive-layoutanswered igor 84 -
2
votes4
answers5376
viewsA: SELECT within the UPDATE
I’m sorry I hadn’t read your question properly. I believe in your case just change the = for in UPDATE tb_telefones SET nr_ddd='" + dddNovo + "', nr_telefone='" + telNovo+ "' WHERE cd_phone in (…
-
2
votes4
answers5376
viewsA: SELECT within the UPDATE
I usually use a loop in this situation: for dd in( (SELECT cd_phone FROM tb_telefones WHERE nr_ddd = '" + dddAntigo + "' AND nr_telefone = '" + telAntigo + "')loop UPDATE tb_phones SET nr_ddd = '" +…
-
0
votes4
answers2220
viewsA: How to select "1" or "2" depending on the column value, in PL/SQL?
select c.cpf_cnpj, case when length(c.cpf_cnpj) > 11 then 2 else 1 end case from ( select '12345655551' cpf_cnpj from dual union select…
-
1
votes2
answers3093
viewsA: PLSQL know the amount of records within a "for cursor"
I don’t know if that’s the idea. But it can be done that way. declare vtabela tabela%rowtype; Begin select t.* into vtabela from tabela; For r in 1..vtabela.count loop Loop ..... ; End loop; End;…