Mohammed Nisar Ansari niisar

🎯

Focusing

niisar / exportoracle.sql

Created June 25, 2014 07:03

exportoracle

	SELECT LISTAGG(PCMN_CODE, ',') WITHIN GROUP (ORDER BY PCMN_CODE) OVER
	(PARTITION BY CTYP_CODE ) FROM PKG_CMN_MST WHERE CTYP_CODE = 12;
	---------
	SELECT LISTAGG(''\|\|CHR('39')\|\|''\|\|CHR('39')\|\|''\|\|CHR('39')\|\|'\|\|V_REC.'\|\|COLUMN_NAME , '\|\|'\|\|CHR('39')\|\|''\|\|CHR('39')\|\|''\|\|CHR('39')\|\|',') WITHIN GROUP (ORDER BY COLUMN_ID) OVER
	(PARTITION BY TABLE_NAME ) FROM USER_TAB_COLS WHERE
	TABLE_NAME = 'CHKLST_INF' ORDER BY COLUMN_ID ;



	SELECT LISTAGG(''\|\|COLUMN_NAME, ',') WITHIN GROUP (ORDER BY COLUMN_ID) OVER

niisar / configure_mail.aspx.cs

Created June 27, 2014 20:14

configure_mail

	using System;
	using System.Collections.Generic;
	using System.Linq;
	using System.Web;
	using System.Web.UI;
	using System.Web.UI.WebControls;
	using System.Data;
	using System.Data.SqlClient;
	using System.Configuration;
	public partial class MASTER_configure_mail : System.Web.UI.Page

niisar / configure_mail.aspx

Created June 27, 2014 20:15

configure_mail

	<%@ Page Language="C#" AutoEventWireup="true" CodeFile="configure_mail.aspx.cs" Inherits="MASTER_configure_mail" %>

	<!DOCTYPE html>

	<html xmlns="http://www.w3.org/1999/xhtml">
	<head runat="server">
	<title>KPS : Mail Master</title>
	<link href="css/css/bootstrap.min.css" rel="stylesheet" />
	<style>
	.inline

niisar / del2

Created August 6, 2014 18:14

del2

	first check below code
	-----------------------------
	SELECT T.TRM_CODE AS TRM_CODE_,
	V."CMI_CODE",V."PKG_CODE",V."PKG_NAME",V."CMN_CDTY_MTRL",V."MTRL_NAME",V."CMI_WT_FACTOR",V."CMI_CNTRCT_RATE",V."CMPI_CODE",V."CMPI_PRICE_TYPE",V."TRM_CODE",V."ENTRY_DATE",V."USR_CODE",V."PRESENT_PRICE",V."CMPI_ID_REF",V."CMPI_UPDATE_STS",V."CMPI_EFF_DATE",V."PREVIOUS_PRICE"
	FROM VW_CMD_MATERIAL V PARTITION BY (V.CMI_CODE,v.pkg_code,v.pkg_name,v.cmn_cdty_mtrl,v.mtrl_name,v.cmi_wt_factor,v.cmi_cntrct_rate,v.cmpi_code,v.cmpi_price_type)
	RIGHT OUTER JOIN TRM_MST T
	ON T.TRM_CODE = V.TRM_CODE
	-----------------------------

niisar / rotate object

Created August 20, 2014 07:25

rotate object

	<script src="http://code.jquery.com/jquery-1.8.0.min.js"></script> <br />
	<script src="http://jqueryrotate.googlecode.com/svn/trunk/jQueryRotate.js" type="text/javascript"></script> <br />
	<script>
	$(document).ready(function()
	{
	var angle = 0;
	setInterval(function(){
	angle+=.5;
	$("#image").rotate(angle);
	},1);

niisar / no runat server tag.txt

Last active August 29, 2015 14:05

no runat server tag.txt

	using System;

	public partial class Pkg_Doc_del : System.Web.UI.Page
	{
	protected void Page_Load(object sender, EventArgs e)
	{
	//string n = String.Format("{0}", Request.Form["customerName"]);
	//Response.Write(n);
	}
	protected void btn_Click(object sender, EventArgs e)

niisar / delete run history.txt

Created August 26, 2014 09:07

delete run history.txt

 REG DELETE HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RunMRU

niisar / regex.cs

Last active August 29, 2015 14:05

regex csharp

	using System;
	using System.Text.RegularExpressions;

	namespace regex_
	{
	class Program
	{
	private static void showMatch(string text, string expr)
	{
	Console.WriteLine("The Expression: " + expr);

niisar / wget cmd

Created August 28, 2014 12:36

wget cmd

--limit-rate=20k

niisar / taskkill

Created August 28, 2014 12:43

taskkill

Taskkill /IM win_word.exe /F