Skip to content

Instantly share code, notes, and snippets.

@shaik2many
shaik2many / oracle - commatext to table.sql
Created August 29, 2012 21:51
oracle - commatext to table
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;
@shaik2many
shaik2many / cdn
Last active December 15, 2015 04:01
jquery-cdn
<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 -->
@shaik2many
shaik2many / Java - Map loop
Last active October 8, 2015 17:17
Java - Map loop
idMap<Long, Object>
for(Long excelid : idMap.keySet()){}
for(Map.Entry<String, MenuItem> entry : map.entrySet()){
entry.getKey();
entry.getValue();
}