Browsed by
Month: June 2015

Oracle: create database link

Oracle: create database link

Database link is a schema object in one database that enables you to access objects on another database. You can create dblink using following syntax:

Example:

Now you can easily copy data from tables from one database to another.

 

Linux: FTP server setup

Linux: FTP server setup

Sometimes we might need to setup an FTP server (for example for our client/co-worker to upload some large files). It is quick and easy. 1. Login as a root (su – root under Debian, sudo su – root under Ubuntu etc. ). Type: apt-get install proftpd  or  yum install proftpd  (under Fedora/CentOS) 2. Edit file /etc/shells (I use nano) and add /bin/false nano /etc/shells 3. Add user ftp.

4. Make home dir for ftp user and set premissions.

5. Optional: create  download & upload dir under…

Read More Read More

My recommended Eclipse Plugins

My recommended Eclipse Plugins

1. Aptana Studio for web development I am personally using Aptana Studio for Ruby/Ruby on Rails applications development but it also aids in authoring of HTML, CSS, JavaScript and  PHP. Website: www.aptana.com Eclipse’s Update Manager URL: http://download.aptana.com/studio3/plugin/install 2. EPIC for Perl scripting. EPIC is an open source Perl IDE with editor & debugger. Website: www.epic-ide.org Eclipse’s Update Manager URL: http://e-p-i-c.sourceforge.net/updates 3. Eclipse SQL Explorer A thin SQL client, perfect for (not only) a small project. Website: eclipsesql.sourceforge.net Eclipse’s Update Manager URL: http://eclipsesql.sourceforge.net/ 4….

Read More Read More