view counter

PL/SQL Feed

Oracle PL/SQL (Procedural Language/Structured Query Language) resources, news, and support articles.

How do you move a table made of cheese?

alter table crumbly_cheese
move tablespace caerphilly;

You can't beat a classic cheese pun in SQL form ;)

select posts from sqlfail

PHP Database Class

PHP namespaces are new to PHP 5.3 (2012), but PHP class files have been around since PHP 5 was introduced. However, a couple students had problems creating working code from the many fragments published else where. Here’s my attempt to qualify it in a single post, running Zend Server Community Edition 6 and Oracle Database 11g.

MySQL Book in Chinese

MySQL_JohnSinOne of my old students and lab assistants stopped by to show his fiancée the BYU-Idaho campus. It was a long trip since he lives in Macao, China.

Zend 6 & Timezones

Just went through all my PHP testing against a fresh instance of Oracle with Zend Server Community Edition 6, and found these warnings, guess that’s pretty clean:

Who Knew That I Knew So Much?

I don't know what I would do without LinkedIn.

Before this amazing website came along, I was pretty sure that my software skills could be described as:

1. Oracle PL/SQL: excellent
2. SQL: just OK
3. Database Design: well, sort of
4. HTML: dangerous
5. XML: really dangerous
6. Java: pitiful
7. Everything else: nothing going on

See, I am probably the most narrowly specialized high-tech "expert". I know PL/SQL and that's really about it.

SQL*Plus tips #6: Colorizing output

If you have seen a colored scripts like a fish from “Session Snapper v.4″ by Tanel Poder or O

Exadata Smart Flash Cache – a note of understanding

I thought of publishing this post to serve as a note of understanding on Smart Flash Cache in an Exadata database system. It outlines the general behavior and working mechanism of flash in co-ordination with storage intelligence.

A Tale of Two Models

select dm.name
from data_models dm
join data_model_values qc
on dm.id = qc.model_id
join data_model_values de
on dm.id = de.model_id
join data_model_values coa
on dm.id = coa.model_id
where qc.attr = 'Query complexity'
and qc.val = 'Hideously mind-boggling'
and de.attr = 'Datatype

Win a Copy of the New Oracle Multimedia Book!

My good friend, Marcelle Kratochvil, is the Oracle ACE Director for (as she put it to me) "all data/any data." She's been working with Oracle since V4 and specializes in Oracle Multimedia. She has been a beta tester for this product since Oracle8i and runs a SIG on multimedia and unstructured data. Check out her blog at: http://eternal-donut.blogspot.com.au.

The things that make life worth living

insert into joyous_memories
select making_vast_improvements
from that_horrible_query
union all
select
designing_data_models
from scalable_applications
union all
select
heart_warming_smile
from your_newborn_child;

While there can be a lot of effort put in before getting these outcomes, the reward is worth it! :)

select posts from sqlfail

view counter