After installing the LAMP stack on Fedora, you need to open port 80 in the Firewall to access the PHP programs on the Fedora instance from external servers. You can open a firewall port by launching the firewall-config application as the
root user with the following syntax:
The firewall-config utility opens the following dialog message:
Click on the Ports tab, and you’ll see the following:
Click on Add button to add a port (more...)
My students wanted an extra credit assignment, so I thought a LAMP configuration and test would be appropriate. The only problem was I hadn’t added it to their course VMware instance. So, here are the instructions to install Apache2, PHP, and MySQLi for a complete LAMP stack.
The post builds on my Fedora Install of MySQL and MySQL Workbench on Fedora posts from last year. It also presumes that you’ve installed a studentdb database but (more...)
This is why I can't do webinars
from my current home.
The upload speed is no doubt way too slow to cater for voice and screencast. Unfortunately I also seem to be in quite the dead spot for 4G wireless connection.
Download speed might
be enough to support the streaming services recently launched in Australia, but I know ABC's iView
does stutter occasionally so I think I'll still have to wait (more...)
This is the second post in my mini-series on leveraging SQL Developer Reports for DBA tasks, today with visualizing Average Active Sessions (AAS). In this article I’ll cover What AAS is and how to interpret it How to build a basic line graph in SQL Developer How to extend the graph with detailed child reports (Time […]
A student posed the question about why table names are case sensitive. That’s because case insensitive table names are the default installation, as qualified in the MySQL documentation. You can verify that with the following query:
WHEN @@lower_case_table_names = 1 THEN
'Case insensitive tables'
'Case sensitive tables.'
END AS "Table Name Status";
The default value returned is:
| Table Name Status |
| Case sensitive tables. |
Since some time I have been adding
WHERE 1=1 to all my queries.
I get queries like this:
FROM emp e
AND e.ename LIKE 'A%'
AND e.deptno = 20
Lots of people ask me what’s the use of this
You know I like to type as little as possible but here I am typing a lot of extra characters. And yet, it makes my development life a (more...)
A recent question on the OTN SQL forum
asked how best to join two tables related by ID and date range, in order to insert one row per date into a data warehouse. One solution was to expand the data from each table, creating one row per date, then join on date. I think it's more efficient to join on date range, then expand.
Maybe a day or so late (for St Patrick’s Day) but a bunch of my Oracle pals (#ACEs and #ACEDs) are all over in Dublin at an Oracle User Group event (#oug_ire on Twitter) so this seemed appropriate. Looks like they are having a good event (based on the tweets), with a fun evening to […]
Have you discovered the OTech Magazine
This magazine is a brainchild of Douwe Pieter van den Bos
and is now five quarterly issues young. The "Winter 2014" is a bumper issue this time, plenty of reading during various downtime that's typically afoot. The season in particular deserves quotes, since outside my home it's currently 39C.
I hope to publish something again next issue, should I find the time between a couple of other projects. (more...)
There was movement at the station, for the word had passed aroundThat the APEX version 5 will become available.
I've jumped the gun
before, but this message is taken direct from the apex.oracle.com site:
No doubt you've heard the news already, but I had to chuckle a little today as I did about an hour's work on a 3.2 environment. After playing with APEX 5 EA3, it was like jumping (more...)
I shouldn’t be using an old version of SQL Developer like v3 (3.2.10.09) anyway but… cut a long story short … I am.
I’ve also got v4 which doesn’t display the same problem
Just pointing out an oddity whilst investigating something for someone:
with x as
(select to_date('28-MAR-2015 01:30','DD-MON-YYYY HH24:MI') dt1
, to_date('29-MAR-2015 01:30','DD-MON-YYYY HH24:MI') dt2
, dt2 "date"
, cast(dt2 as timestamp) "timestamp"
, to_Char(cast(dt2 as timestamp),'DD-MON-YYYY (more...)
Trying to be as productive as possible during my infrequent down time, I just published another Kindle book with some of my best tips for Oracle Data Modeler. it is called Better Data Modeling: Tips for Enhancing Your Use of Oracle SQL Developer Data Modeler. If you are one of the 3.5 million users (or […]
PostgreSQL like Oracle supports record data types but unlike Oracle, PostgreSQL doesn’t support collections of record data types. Here’s an example of how to define a PostgreSQL composite data type, and how to use it as a column’s data type.
CREATE TYPE address_type AS
( street_address VARCHAR
, city VARCHAR
, state VARCHAR
, zip_code VARCHAR );
Then, you define an ADDRESS table, like:
CREATE TABLE address
( address_id SERIAL
, address_struct ADDRESS_TYPE ) (more...)
PostgreSQL’s approach to automatic numbering, is simpler than Oracle, MySQL, and Microsoft SQL Server. For example, you have a two-step process with Oracle, MySQL, and Microsoft SQL Server. First, you create an Oracle table with the
GENERATED AS IDENTITY clause, a MySQL table with the
AUTO_INCREMENT clause, and a Microsoft SQL Server table with the
IDENTITY(1,1) clause. Then, you need to write an
INSERT statement like:
INSERT statement excludes the auto-incrementing column from the (more...)
If you run Oracle Standard Edition or haven’t licenced Diagnostics Pack for Enterprise Edition, then you don’t have AWR and ASH Data available. This is when Statspack, the predecessor of AWR, comes in handy to keep a history of database performance metrics. But although Oracle still deliver Statspack with their recent DB releases (yes, even in […]