Archive for the 'database' Category
15 Nov
Information age has showed everyone that information is a valuable asset. The one that holds the information have a greater advantage that those that don’t have. Information paves way to better decision making to one’s advantage. In the global market field, information is a key factor in a successful engagement with a business or a […]
Posted in database, technology by: tony
No Comments
13 Nov
There are times when an Oracle Form button needs to be hidden depending on certain criteria. I would like for example to prevent changing of the student status when they are Graduated or Completed from their study. Hiding the CHANGE STATUS button in an Oracle Form when the student is flagged as Graduated or Completed […]
Posted in database, software by: tony
No Comments
13 Nov
Technology is moving fast and trainings are a key in keeping up with the trends. You might be a dinosaur in your field, but you’ll perish if you would not adapt with the changes. Mostly people would say that training classes are somehow dull and tiresome. How about if the training classes are done in […]
Posted in database by: tony
No Comments
16 Oct
Computers have a great instrument in the tracing back family roots. In the past, I rely on the stories of my great grand parents to know the roots of my family. I together with my siblings will listen to the stories long ago on how our great grand parents survived the World War I and […]
Posted in database, technology by: tony
No Comments
23 Aug
MSSQL database is one of the Windows system based back end database that we are using for some of our in-house Visual Basic Applications. I have encountered some situation that requires me to check if some data from the one table (Alumni table) that is missing from another table (Student table). Logged in to the […]
Posted in database, windows by: tony
No Comments
21 Aug
Blog or website have something to offer to their visitors. There are businesses that needs to target certain niche of audience. Giving a value to your website visitors is an important factor in maintaining audience and site popularity. A way of understanding the site visitors would be the first step. Collecting information about a visitor’s […]
Posted in blogging, database, software by: tony
No Comments
16 Aug
MySQL database have been growing with each release and more features are being added. As the database adds new features the database expands correspondingly. Before there was no trigger, views, stored procedures in MySQL database, but now it does have these functions which makes it grow in size.
People that are developing applications on the web […]
Posted in database, open source by: tony
No Comments
10 Aug
Internet is really growing and to catch up with the demands of web hosting; I could observe that hosting companies are sprouting everywhere. A database is a typical basic requirement for modern dynamic websites that are data driven. I could observe the popularity of open source databases like PostgreSQL, MySQL, and others are usually the […]
Posted in database, windows by: tony
No Comments
10 Aug
Microsoft have released their latest database product the SQL Server 2008 Enterprise Edition. If you are looking for a data storage platform which could be used for important applications then MSSQL Server 2008 Enterprise Edition could be an option. This offers reliable, secure, scalable and easy to manage database.
Making a choice in database systems is […]
Posted in database, windows by: tony
8 Comments
07 Aug
National Association for Stock Car Auto Racing or Nascar is one of the most popular auto racing in the US. Avid fans get collectible Nascar Merchandise, but for me, it’s about the driving experience. Drive until you drop; you can only do it in your PC with Nascar auto racing games. Nascar is one of […]
Posted in database, open source, personal, software by: tony
No Comments
24 Jul
There are times when application buttons of Oracle Form Applications should be hidden from the user when certain criteria are met.
For example, changing of student status can only be done when students have not yet graduated or completed. A button called CHANGE STATUS should disappear from the Oracle Forms when student status is graduated and […]
Posted in database, software by: tony
2 Comments
21 Jul
Foxpro 2.6 database are the oldest data storage platform that we have for our in-house built applications. One of the error that so often happen is the “table is not ordered” error. I was approached by a colleague about this and this happened when a database file was copied from a backup. Thus, the database […]
Posted in database, software by: tony
No Comments
05 Jul
Searching for a career path, is one of the concerns of my younger brother in-law. Whether to take up Computer Engineering degree or something else. Those who are interested in employment with IT career are familiar with titles such as Applications Programmer, Computer Programmer, Database Programmer, Systems Programmer, and more.
The work for example that I […]
Posted in database, software, technology by: tony
No Comments
28 Jun
IBM are one of the great manufacturers of computers. Early this month, I have read about IBM’s Roadrunner, judged to be the world’s fastest computer…
which provides more than 1 quadrillion calculations a second for nuclear security and scientific research at the Los Alamos National Laboratory. The supercomputer also was found to be one of the […]
Posted in database, hardware, technology by: tony
No Comments
19 Jun
I was working with a project where PHP is used to accept entry for saving data to an Oracle Database. The saving of the entered data is working fine, but I was puzzled of the additional back slash before an apostrophe mark in the stored text data. I have not even used addslashes() to put […]
Posted in database, software by: tony
No Comments
14 Jun
Oracle OpenWorld is the world’s largest gathering of Oracle customers, partners, developers, and technology enthusiasts. The Oracle OpenWorld 2008 will be held on September 21-25, 2008 at the Moscone Center, San Francisco. This is a conference that will offer opportunities for learning, connecting, collaborating, and exchange views with experts and peers in the industry.
The are […]
Posted in database, technology by: tony
No Comments
14 Jun
There are many new things that comes up with Information Technology every week, every month and every year. Reading is a must to keep ones self abreast of the rapid changes. In times where e-books are easily available; I still prefer reading from printed paper books. This rest my eyes from the computer screen which […]
Posted in database, software, technology by: tony
No Comments
11 Jun
Oracle E-Business Suite and Enterprise clients are gearing up for the great event of the year for OHUG (Oracle Human Capital Management Users Group) 2008 Global Conference. This years conference will be this June 22 - 25, 2008 at one of the prestigious vegas hotels the Mirage Hotel and Casino, Las Vegas, Nevada.
This is an […]
Posted in database, software by: tony
No Comments
30 May
In MSSQL 7.0 manual update of records are sometimes done to initialize data in a table which is normally done in a Query Analyzer window. I’ll take for example a table called StudentHistory which has new field FullName and LastNameFirstName which was added to concatenate values from two other fields FirstName and LastName. Since, the […]
Posted in database, windows by: tony
No Comments
21 May
Melbourne is one of the famous cities in Australia, second only to Sydney. The city boasts great events, food, wine and a scenery of fabulous arts. It’s one of the tourist destinations of Australia known for all year round festivals, renowned dining, major art exhibitions and musical extravaganzas. Melbourne accommodation is not a problem as […]
Posted in database by: tony
No Comments
11 May
Oracle have been sending out invitation for seminars. Last week time I got an invitation to attend this Oracle Technology Day on May 15, 2008 at Pan Pacific Hotel in Bangkok, Thailand through my superiors from the office.
My office mate, told me about an email invitation from Oracle to attend a Software Configuration Manager on […]
Posted in database, software by: tony
No Comments
09 May
In our Information System unit, we are maintaining and developing in house software application. Recent movement of employees left us without a system administrator. Thus, we as system analyst developer need to prepare our own working and deployment environment.
Most of the time we work with pure Oracle products from database to development language like […]
Posted in database, software by: tony
No Comments
03 May
Training and seminar are one of the good things that I like in working. I got an email from my boss informing of an Oracle Technology Day seminar at the Pan Pacific Hotel, Thailand this 15 May 2008. Though this is not a 2 or 3 day training, I would like to go as […]
Posted in database, personal, technology by: tony
No Comments
29 Apr
Installing Oracle database on a test machine is one of the things that I do at the office. I have encountered one error when installing Oracle® Database 10g Release 2 (10.2) on a Microsoft Windows laptop computer offline.
It’s looking for a fixed IP on the computer, but what I have is a DHCP provided IP […]
Posted in database, windows by: tony
1 Comment
29 Mar
Trainings are sometimes boring and lack luster. I have just learned of that one could learn Oracle at sea. Yeah that’s right when the winter time is over, enjoy sailing the Caribbean seas on the Liberty of the Seas, the world’s largest and nicest cruise ship, while learning the latest Oracle technology tips and techniques. […]
Posted in database, personal by: tony
No Comments
26 Mar
I was looking for a development tool that I can use with Oracle’s Application Express (Apex) and have found out about this APEX Builder Plugin. The Plugin which is a JavaScript file and have a different installer script for each FireFox and Internet Explorer.
Currently the APEX Builder Plugin is release 1.9. The Plugin is an […]
Posted in database, personal by: tony
No Comments
18 Mar
I have blogged about trying to find out what was wrong with the Oracle Application Express 3.1 installation. Comments and email have confirmed there was something wrong. Plus, my own experience in the installation of Oracle Application Express 3.1 (Apex) on a fresh install of Oracle Database Express Edition (Oracle XE) Release 10.2.0.1.0.
I followed […]
Posted in database by: tony
3 Comments
14 Mar
An application created using Oracle Application Express can only be run under the local machine (eg. http://localhost:8080/apex/ or http://127.0.0.1:8080/apex/). It would be nice if the applications developed with Oracle Application Express could be accessed by other computers across the Intranet or Internet. So, I was wondering if it is ever possible to publish web applications […]
Posted in database by: tony
No Comments
13 Mar
I am looking for an alternative operating system to Red Hat Enterprise Linux for use as Oracle Database Server running Oracle Application Express 3.1. There are a number of choice which are certified by Oracle to run the Oracle Database 10g Release 2.
Operating systems certified for installation of Oracle Database 10g Release 2:
SLES-9
SLES-10
Red Hat […]
Posted in database by: tony
No Comments
11 Mar
The cause for missing image and JavaScript error as written before regarding Oracle Application Express Missing Images And JavaScript Error was the wrong image prefix.
http://127.0.0.1:8080/apex/TEMPjavascript/apex_ns_3_1.js
http://127.0.0.1:8080/apex/TEMPjavascript/apex_get_3_1.js
http://127.0.0.1:8080/apex/TEMPjavascript/apex_get_3_1.js
http://127.0.0.1:8080/apex/TEMPjavascript/apex_builder.js
http://127.0.0.1:8080/apex/TEMPcss/apex_3_1.css
http://127.0.0.1:8080/apex/TEMPcss/apex_builder_3_1.css
http://127.0.0.1:8080/apex/TEMPhtmldb/apex_logo.gif
The correct installation should have “/i/” instead of “/apex/TEMP”.
http://127.0.0.1:8080/i/javascript/apex_ns_3_1.js
http://127.0.0.1:8080/i/javascript/apex_get_3_1.js
http://127.0.0.1:8080/i/javascript/apex_get_3_1.js
http://127.0.0.1:8080/i/javascript/apex_builder.js
http://127.0.0.1:8080/i/css/apex_3_1.css
http://127.0.0.1:8080/i/css/apex_builder_3_1.css
http://127.0.0.1:8080/i/htmldb/apex_logo.gif
Thus to correct this problem the prefix image should be corrected. It’s good that Oracle Application Express comes with Useful Oracle APEX tools […]
Posted in database by: tony
7 Comments