shaik2many’s gists

shaik2many / oracle-year-sysdate;

Created January 10, 2013 14:58

SELECT to_char(sysdate, 'YYYY') FROM dual;

shaik2many / oracle-insert-as-select.sql

Created January 9, 2013 15:52

+INSERT INTO table1(column1, column2, ...)
+SELECT column3, column4, ...
+FROM table2
+--Read more: http://www.1keydata.com/sql/sql-insert-into-select.html#ixzz2HUbbJ4vR
+INSERT INTO table1
+SELECT * FROM table1@dev; --if the column order match

shaik2many / javascript-toggle-imagebackground.html

Created December 31, 2012 22:18

	<head>
	<script src="http://code.jquery.com/jquery-1.8.3.js"></script>
	<script>
	$(function(){
	$('.toggle').click(function(){
	//$('#my_content').toggle();
	$(this).toggleClass('toggled');
	});
	})
	</script>

shaik2many / oracle-connectby.sql

Last active April 28, 2019 14:17

All about Oracle connect by

	/*
	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,

shaik2many / oracle-grant.sql

Created December 24, 2012 14:42

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

shaik2many / oracle-synonym.sql

Last active December 10, 2015 02:39

create public synonym MVDIR_DETAILS for dirdba01.MVDIR_DETAILS;

shaik2many / javascript-replaceall.js

Created October 14, 2012 19:47

javascript-replaceall.js

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

shaik2many / mvn-install-file

Created October 12, 2012 19:08

mvn-install-file

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 / oracle-virtual column

Created September 22, 2012 15:06

oracle-virtual column

	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 / todo-oracle-opti

Created September 7, 2012 16:46

todo-oracle-opti

	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