You are currently browsing the archives for the Uncategorized category.
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Mar | ||||||
| 1 | 2 | 3 | 4 | 5 | ||
| 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 |
| 27 | 28 | 29 | 30 | 31 | ||
4. March 2008 by admin.
I was just thinking of whether it would be possible to run various programs on laptop using OracleXE with Sigma tables that could be automaticly linked to be downloaded/updated only when necessary. The advantage would be that we would only need to hook-up with VPN to update/download tables. All work could be done on laptop without any network hookup.
Posted in Uncategorized | No Comments »
4. March 2008 by admin.
Today I installer jdeveloper. So far so good. I now got jdeveloper installed and have setup my AUD_TEST database on jdeveloper. wow! I can see the tables i created in XE. OK… Now I got Oracle XE with the new APEX 301, Sqldeveloper, and now jdeveloper.
Posted in Uncategorized | No Comments »
4. March 2008 by admin.
Last week I created tables in OracleXE/APEX from my excel Mineral spreadsheet. I’m not sure what columns (I have a hard time not calling them fields) I am going to need. What are going to be the variables, how to write the script, etc.? I imported cvs text files to create the tables. I also pulled data and tables from Sigma for PARCEL table using sqlplus spool over the VPN.
Posted in Uncategorized | No Comments »
15. February 2008 by admin.
This is a good summary of APEX -
What is Application Express? http://www.oracle.com/technology/products/database/application_express/html/what_is_apex.html
With Oracle XE and APEX301 working, the last two days I’m been using the Oracle Database 2 Day + Application Express Developer’s Guide and setting up the sample hr database and APEX application. I learned a lot, but got lost a lot also. I need to decide what workspace and Schema I need to set up for development. How much I use APEX to setup or PLSQL or sqldeveloper.I will return to developing thinking how to convert my excel spreadsheets and logic to use Oracle databases. When I have the databases setup I can begin some APEX. I guess I will begin with a single year and worry about the line adjustment values last, because these need last year’s past values. I’m not sure what I’ll do about past values, query databases or re-cal or store values.
Posted in Uncategorized | No Comments »