As a Master Chief in US Navy submarines, one of my favorite sayings was “Good judgment comes from experience, and experience comes from poor judgment.” I’ve always had difficulty solidly learning new programming techniques in a traditional class…
Tag: Oracle
Who is Alfred?
Tell me something about Alfred, male or female? age? height and weight?
Oracle database (version 9 and below) had a well known default demo account SCOTT with a password, TIGER (and TIGER was the name of the real person Bruce Scott ’s cat, see) and in this account, there are some tables named DEPT, EMP, […]
SAS, Oracle Weblogic, VMWare – Do not want to play nicely!
We have been looking to upgrade a client to SAS 9.2 and at the same time move to the clients corporate IT standard of virtualising the environments. The client has standardised on vSphere and I thought great SAS 9.2 supports vSphere (as much as the following SAS support page say’s SAS supports virtualisation) SAS® Product Support for […]
SQL tip – Inner join shorthand with USING
We write a LOT of SQL here and although SQL is a powerful database language, it can be tedious. So here is one tip for shortening all that typing. Typical join sytax: select some_columns from one_table join another_table on one_table.column_1 = another_table.column_1 and one_table.column_2=another_table.column_2 where some_column > someother_column ; Not too bad, right? In order for […]
Pivot tables and Cheezy Graphs? No more…
As any good analyst knows, working with data is not the problem. Good analysts have the skill necessary to combine, split, merge, slice, aggregate, or summarize data any way you can imagine. However, is that enough? Probably not.. What good does data do if you can’t communicate its meaning in a logical way. The day […]
Work With Oracle: A Quick Sheet for SAS Programmers
(Note: All the followings are tested on Windows XP environment.)
0. Install Oracle Database 10g Express Edition
Fast (and free) to download, easy to deploy and simple to admin–for learning and testing purpose, Oracle Database 10g Express Edition (Oracle Database XE, a mini version of Oracle Database 10g Release 2) are strongly recommended:
0.1 Download it at […]