By Rupert
Oracle Spatial Tutorial Screencasts
This is the first time I ever did a screencast and it was a lot of fun! Please do forgive me as my voice was horrible. I used iShowU and keyCaster. Google it!
I hope you guys enjoyed it..as much as I did..
| Print article | This entry was posted by rupert on November 11, 2008 at 10:01 pm, and is filed under Uncategorized. Follow any responses to this post through RSS 2.0. You can skip to the end and leave a response. Pinging is currently not allowed. |
No comments yet.
iPhone Note #8: Exporting Oracle to SQLite3
about 11 months ago - No comments
Since I’ve been working most of my time with iPhone Dev for the last couple of months, I thought it will be worthwile to post how to import files to SQLite3. In a nutshell, use MesaSQLite’s IMPORT function. It will save you a lot of time. Now it is up to you how to export
Two Oracle Homes in one Machine
about 1 year ago - No comments
I’ve been toggling back and forth two different oracle homes by editing the environment variables from the Control Panel in Windows which is a pain in the ***. What I did was, to create two different command prompt shells with different oracle home environments. I got this idea after a glimpse from FWTools. 1. Create
Rails Note #13: RubyonRails + Oracle on Linux (i386 / x64)
about 1 year ago - No comments
In summary, install Oracle Instant Client and try to run sqlplus. If sqlplus connects to the oracle sid then go ahead and install the rails adapters for oracle. What is important to note here, is to install the oracle-instantclient for the architecture of your machine.. I have tested this on Debian Lenny (i386) and CentOS5
Rails Note #12: Oracle on Intel Mac
about 1 year ago - 1 comment
1. Read http://www.foliosus.com/2008/05/05/connecting-ruby-on-rails-to-oracle-on-an-intel-mac-in-leopard-take-2/ 2. Install Oracle Instant Client on Mac. a. Instant Client Package – Basic: All files required to run OCI, OCCI, and JDBC-OCI applications – instantclient-basic-macosx-10.2.0.4.0.zip (34,020,719 bytes) b. *Instant Client Package – SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client instantclient-sdk-macosx-10.2.0.4.0.zip (603,493 bytes) OR download
How to make Oracle start on boot
about 1 year ago - No comments
1. Login as root and edit /etc/oratab to reflect “Y” orcl:/opt/oracle/product/11.1.0/db_1:Y 2. oracle startup script: #!/bin/bash # # oracle Init file for starting and stopping # Oracle Database. Script is valid for 10g and 11g versions. # # chkconfig: 35 80 30 # description: Oracle Database startup script # Source function library. .
Oracle Tuning Tools
about 1 year ago - No comments
EXPLAIN PLAN 1. Create the PLAN_TABLE SQL> $ORACLE_HOME/rdbms/admin/utlxplan.sql 2. Run EXPLAIN PLAN for an SQL SQL> EXPLAIN PLAN 2 SET STATEMENT_ID = ‘example’ FOR 3 SELECT ename,dname 4 FROM emp inner join dept 5 ON ( emp.deptno = dept.deptno ) 6 / Explained. 3. DISPLAY Results SQL> $ORACLE_HOME/rdbms/admin/utlxpls.sql AUTOTRACE is a SQL*Plus facility that may
Tutorials Updated for Oracle
about 1 year ago - No comments
It was a gruesome day.. I have an oracle10g on my MacBookPro running on VMWare (WindowsXPSP3, let’s call this orawin). I have another setup box (CentOS5 + oracle11g = oralin) just this morning. I imported the tables from my orawin10g to my oralin11g, created the indexes for the tables in oralin11g. I ran my spatial
Oracle SQL CheatSheet
about 1 year ago - 1 comment
References: Comparison of different SQL implementations Oracle DataTypes Part 1: Oracle Misc Information *Oracle Services Running on Windows? * How to create a user? CREATE USER "APPDEV" PROFILE "DEFAULT" IDENTIFIED BY "*******" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" ACCOUNT UNLOCK GRANT UNLIMITED TABLESPACE TO "APPDEV"; GRANT "CONNECT" TO "APPDEV"; GRANT "RESOURCE" TO "APPDEV"; * How
Using SDO_WITHIN_GEOM
about 1 year ago - No comments
Experiment 1: Two POIs SELECT p1.poi_id, p1.en_name, p1.py_fullpoiadd, p1.py_rdname, p2.poi_id, p2.en_name, p2.py_fullpoiadd, p2.py_rdname, SDO_GEOM.SDO_DISTANCE(p1.geom, p2.geom, 0.5) AS dist FROM poi_test p1, poi_test p2 WHERE Upper(p1.en_name) LIKE ‘%PARKSON%’ AND Upper(p2.en_name) LIKE ‘%KFC%’ AND SDO_WITHIN_DISTANCE(p1.geom, p2.geom, ‘DISTANCE=500 UNIT=METER’ )=’TRUE’ ORDER BY dist Experiment 2: Road + Two POIs SELECT p1.poi_id, p1.en_name, p1.py_fullpoiadd, p1.py_rdname, p2.poi_id, p2.en_name, p2.py_fullpoiadd, p2.py_rdname,
Oracle Text Notes
about 1 year ago - No comments
Just a couple of notes from studying Oracle Text… 1. What is the default index? Its CONTEXT. The text column can be of type CLOB, BLOB, BFILE, VARCHAR2, or CHAR. CREATE INDEX idx_ft_meta_en_name ON poi_app(ft_meta_en_name) INDEXTYPE IS CTXSYS.CONTEXT; 2. When you perform inserts or updates on the base table, you must explicitly synchronize the index