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;
hidden message ...
- dr_gori
- 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
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
-
- 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
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 ...
I'll give you some demands of me here ...
- dr_gori
- 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
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
but it was worth it, I got several colleagues with this SQL! haoahahaho
-
- 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 ...
here does not have oracle ...
-
- Rank: Analista Júnior
- Posts: 82
- Joined: Tue, 28 Dec 2010 7:41 pm
- Location: São Paulo - SP
att. Fabio Ishii
http://ishii.profissionaloracle.com.br
http://ishii.profissionaloracle.com.br
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:
: -O
PS: Yes, I tb tested
: Evil:
- dr_gori
- 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
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"
I sent an email so to the trap galera:
"See this SQL attachment, impressive the result"
-
- Moderador
- Posts: 1177
- Joined: Thu, 15 Oct 2009 10:28 am
- Location: Recife
I rode here I found an Oracle,
Main Cot ..
Uiahauihua
Main Cot ..
Uiahauihua
-
- Information
-
Who is online
Users browsing this forum: No registered users and 12 guests