dsin

Just another dsin geeky weblog

Main menu

Skip to primary content
Skip to secondary content
  • Home
  • About

Monthly Archives: May 2013

[ subclipse ]svn:ignore files in the directory

Posted on May 28, 2013 by dsin
Reply

1. Click at the folder, Team > Show Properties

2. After that add the property svn:ignore i.e. ignore all the excel files in the directory

รูปภาพ

Posted in Uncategorized | Tagged directory, eclipse, files, folder, howto, ignore, subclipse, subversion, svn, svnignore | Leave a reply

oracle autoincrement

Posted on May 7, 2013 by dsin
Reply

1. create sequence

CREATE SEQUENCE test_sequence

START WITH 1
INCREMENT BY 1;

2. create trigger

รูปภาพ

CREATE OR REPLACE TRIGGER (trigger_name)
BEFORE INSERT ON (table_name)
REFERENCING NEW AS N
FOR EACH ROW
BEGIN
SELECT (sequence_name).nextval INTO :N.(column_name) FROM dual;
END;

 

Posted in Uncategorized | Tagged autoincrement, oracle | Leave a reply

Latest Post

  • [ python ] old style class v.s. new style class and super() error `must be type not classobj`
  • [ github ] security
  • [ DHT11 ] Humidity Unit
  • [ google sheets ] range last row
  • [ ardunio ] tm time reference
  • [ bash ] check contentType
  • [ bash ] compare 2 files and check if it is changed
  • [ bash ] delete file that is older than X day
  • [ docker ] ssh into container
  • [ ardunio ] create CACert for client.setCACert_P()
  • [ yarn ] installation on ubuntu
  • SonarCloud / SonarCube
  • [ yarn ] Error: Git must be installed and in your PATH!
  • [ psql ] copy postgres result to file
  • [ jenkins ] login with AD
  • [ chrome 75 ] lazy load
  • [ ReactJS ] optimization
  • [ font ] preload v.s. prefetch
  • [ db ] backup
  • [ MySQL ] Percona server

Archives

  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • November 2014
  • October 2014
  • September 2014
  • August 2014
  • July 2014
  • June 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
  • January 2014
  • December 2013
  • November 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • October 2011
  • April 2011
  • March 2011
  • December 2010
  • November 2010
  • October 2010
  • July 2010
  • August 2009
  • July 2009
  • April 2009
  • February 2009
  • December 2008
  • November 2008
  • October 2008
  • May 2008
  • April 2008
  • June 2007
  • December 2006
  • July 2006
  • February 2006
  • January 2006
  • December 2005
  • August 2005
  • July 2005
  • June 2005

Tag Cloud

  • 101
  • 2012
  • Agile
  • ajax
  • appengine
  • ax
  • ax32.exe
  • Ax2012
  • AxHLink.exe
  • bi
  • C#
  • client
  • column
  • comet
  • csharp
  • cube
  • database
  • dynamics
  • dynamics ax
  • dynamics protocol
  • eclipse
  • ERP
  • error
  • example
  • excel
  • export
  • folder
  • format
  • function
  • gae
  • google app engine
  • googleappengine
  • howto
  • ip
  • java
  • javadoc
  • javascript
  • list
  • load balance
  • load balancing
  • microsoft
  • ms
  • mssql
  • MVC
  • net
  • olap
  • oracle
  • package
  • path
  • postgres
  • programming
  • rails
  • rdp
  • RemoteApp
  • report
  • server
  • shooting_star
  • sql
  • sql developer
  • sqldeveloper
  • SSRS
  • subversion
  • svn
  • table
  • telnet
  • tips
  • tomcat
  • tutorial
  • ubuntu
  • VB
  • web
  • windows
  • windows7
  • wordpress
  • workflow notification
Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy