Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

split string withou token

muttleychessJan 13 2020 — edited Feb 13 2020

Hi

  

   I have a string like  '987612345'  and would like show each number  in different rows

9

8

7

6

1

2

3

4

5

I tried code below

select substr('987612345', level,1) column01  from DUAL
   connect by level <10

Is there any better way to do this?
 



This post has been answered by Frank Kulash on Jan 13 2020
Jump to Answer



  

    
    

      
Comments

      

    

    

  

  

  



        

  

    
    

      
Post Details

      

    

    

  

  


  
    
    
    
      
Added on Jan 13 2020
      
      
      
    
  
  
    
    
    
      
                           7 comments
      
      
      
    
  
  
    
    
    
      
                         304 views