techxplore blog

Archive for the 'database' Category

15 Nov

Companies, Industries, Executives Information Database Services

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 […]

13 Nov

PL/SQL Code To Hide Oracle Form Button

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 […]

13 Nov

Oracle RAC Training Cruise 2009 Exciting Learning Experience

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 […]

16 Oct

Creating Online Family Genealogy Tracing Back Family Roots

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 […]

23 Aug

MSSQL Database Selecting Data From One Schema To Another With System User

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 […]

21 Aug

IP Address And Geographic Location Database Determines Website Visitor Information

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 […]

16 Aug

Drizzle A Lightweight MySQL Database

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 […]

10 Aug

Microsoft SQL Server 2008 Web Edition

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 […]

10 Aug

Download Free Microsoft SQL Server 2008 Enterprise Edition

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 […]

07 Aug

Nascar Merchandise And PC Games

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 […]

24 Jul

Hide And Unhide Oracle Forms 6i Button

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 […]

21 Jul

Foxpro 2.6 Database “Table Is Not Ordered” Error

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 […]

05 Jul

Job Task For IT Career As Systems Analyst Programmer

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 […]

28 Jun

Las Vegas IBM System z Expo 2008

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 […]

19 Jun

Removing Additional Back Slashes Saved On Oracle Text Data Column

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 […]

14 Jun

Oracle OpenWorld 2008 San Francisco

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 […]

14 Jun

Reading Books For Keeping Updated With Information Technology

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 […]

11 Jun

Oracle HCM Users Group 2008 Global Conference

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 […]

30 May

Automatic Update MSSQL 7.0 Field With Trigger

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 […]

21 May

Melbourne Oracle 10g BPA Suite 10.1.3 Workshop

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 […]

11 May

Oracle Software Configuration Manager Seminar

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 […]

09 May

Installing Zend Core For Oracle On Red Hat Linux 7.3 - Part I

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 […]

03 May

Oracle Technology Day Seminar Invitation

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 […]

29 Apr

Setting Up Windows XP Loopback Adapter For Oracle Enterprise Database On Laptop

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 […]

29 Mar

Oracle Training While On Cruise

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. […]

26 Mar

Installing Apex Application Builder Plugin

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 […]

18 Mar

Oracle Application Express 3.1 With Oracle XE

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 […]

14 Mar

Publishing Oracle Application Express Applications On The Internet

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 […]

13 Mar

CentOS A Red Hat Enterprise Linux Alternative For Oracle Database Server

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 […]

11 Mar

Application Express 3.1 Upgrade Missing Image And Javascript Error Solution

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 […]