This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH commadata AS ( | |
| SELECT '1,1.050,1.050.050,1.050.100,1.050.150,1.050.200,1.100,1.100.050,1.100.050.050,1.100.050.100,1.100.050.150' columnid1, 'word4,word5,word6' columnid2 FROM dual | |
| ) | |
| SELECT regexp_substr(columnid1, '[^,]+', 1, level) as parsed_value, | |
| regexp_substr( columnid2, '[^,]+',1, level) as parsed_value | |
| FROM commadata | |
| CONNECT BY LEVEL <= REGEXP_COUNT( columnid1 , '[,]' )+1 | |
| ORDER BY 1; | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.3.15/angular.min.js"></script> | |
| <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js"></script> | |
| <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.23/jquery-ui.min.js"></script> | |
| <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> | |
| <!-- Latest compiled and minified CSS --> | |
| <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"> | |
| <!-- Optional theme --> | |
| <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap-theme.min.css"> | |
| <!-- Latest compiled and minified JavaScript --> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| idMap<Long, Object> | |
| for(Long excelid : idMap.keySet()){} | |
| for(Map.Entry<String, MenuItem> entry : map.entrySet()){ | |
| entry.getKey(); | |
| entry.getValue(); | |
| } |
NewerOlder