shaik2many

idMap<Long, Object>
for(Long excelid : idMap.keySet()){}

for(Map.Entry<String, MenuItem> entry : map.entrySet()){
		entry.getKey();
		entry.getValue();
}

shaik2many

<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

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

select t.*, a.*, b.* from tcom_user t,
(SELECT DISTINCT 'TRUE' is_proj_lib FROM vcom_security_useraction WHERE sso_id = 9005 AND action_group = 'PROJ_LIB') a,
(SELECT DISTINCT 'TRUE' is_proj_edit FROM vcom_security_useraction WHERE sso_id = 9005 AND action_group = 'PROJ_EDIT') b
 where sso_id = 9005

shaik2many

ALTER TABLE tcom_asset DROP COLUMN asset_name
ALTER TABLE Tcom_Project_Bus_Subbus
ADD BUSINESS_DESC VARCHAR2(4000) GENERATED ALWAYS AS (get_business_by_id(sub_business_id)) VIRTUAL;

create or replace function get_business_by_id(p_business_id in varchar2) return varchar2 DETERMINISTIC is
ret varchar2(255);
begin
  select business_desc into ret from MVGLD_BUSINESS where business_code = p_business_id;
  return ret;
  end get_business_by_id; 

shaik2many

mvn install:install-file -Dfile=C:\reyaz\lib\batik-anim.jar -DgroupId=org.apache.batik -Dversion=1.x -DartifactId=batik-anim -Dpackaging=jar -DgeneratePom=true

shaik2many

mystring.replace(/\./g,' ')

shaik2many

create public synonym MVDIR_DETAILS for dirdba01.MVDIR_DETAILS;

shaik2many

grant select,insert,update,delete on dirdba01.tdir_mast to dirusr01;

shaik2many

/*
It builds a hierarchical query. 
There are 2 components to it:
"start with" -- this identifies all LEVEL=1 nodes in the tree
"connect by" -- describes how to walk from the parent nodes above to their children and their childrens children.
*/
select ename, empno, mgr from emp;
select lpad(' ',level*2,' ')||ename ename, 
sys_connect_by_path(business_code, '/') path,
connect_by_isleaf is_leaf,