Using OGR2OGR to re-project a shape file

OGR2OGR is a great command line tool for GIS format conversions providing support for all the 'mainstream' formats as well as plenty of more obscure ones. It is also useful for changing the projection & coordinate system of a map layer.

Using the & (ampersand) character in Oracle SQL*Plus scripts

It can be very frustrating when using Oracle SQL*PLus (sqlplus) to run a SQL script that contains an ampersand (&) character only to have the script stop mid-way through and ask you for a value :


  • oracle (8)
  • Mac OS (6)
  • Oracle (6)
  • SQL (5)
  • apex (4)
  • mac os (3)
  • iPhone (3)
  • script (2)
  • GIS (2)
  • map (2)