hidden message ...

Use este forum para coisas que não tem nada a ver com Oracle.
Post Reply
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

Select all

select  
chr(SUBSTR(A.Str||'1'  
, INSTR(A.Str||'1' , '1', 1, Rownum ) +1  
, INSTR(A.Str||'1' , '1', 1, Rownum+1)  
 -INSTR(A.Str||'1' , '1', 1, Rownum ) -1  
)) SUA  
From  
(  
select  
'166173188179178165' Str  
from dual  
)  
A,  
all_objects B  
where  
Rownum< length(A.Str)-length(REPLACE(A.Str,'1'))+1; 
: - D
gfkauer
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 389
Joined: Tue, 27 Jul 2010 1:34 pm
Location: Sapiranga - RS
Contact:
Quem falou que programar era fácil??

Quanto mais dificil for a implementação mais valorizado seu trabalho será!

Acessem: www.gfkauer.com.br

-_-
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

I think yesterday I was with little service :-d ahoahoaha
gfkauer
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 389
Joined: Tue, 27 Jul 2010 1:34 pm
Location: Sapiranga - RS
Contact:
Quem falou que programar era fácil??

Quanto mais dificil for a implementação mais valorizado seu trabalho será!

Acessem: www.gfkauer.com.br

It's not having anything to do in ....

I'll give you some demands of me here ...
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

IH, already finished the "time to create" ...
but it was worth it, I got several colleagues with this SQL! haoahahaho
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

glue the result of the select there, I was curious,

here does not have oracle ...
ishii
Rank: Analista Júnior
Rank: Analista Júnior
Posts: 82
Joined: Tue, 28 Dec 2010 7:41 pm
Location: São Paulo - SP

Dude, grace is exactly in running the result in Oracle ... if someone sticks here, who will try tb?

: -O
PS: Yes, I tb tested
: Evil:
User avatar
dr_gori
Moderador
Moderador
Posts: 5024
Joined: Mon, 03 May 2004 3:08 pm
Location: Portland, OR USA
Contact:
Thomas F. G

Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered

HAHAOOAOHA
I sent an email so to the trap galera:
"See this SQL attachment, impressive the result"

:-)
burga
Rank: DBA Pleno
Rank: DBA Pleno
Posts: 232
Joined: Thu, 26 Nov 2009 1:05 pm
Location: SP
Ricardo H. Tajiri

hehehehehe, people here also have fun with this select ...



very good !!!

: -O
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

I rode here I found an Oracle,

Main Cot ..

Uiahauihua
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 22 guests