Archive for August 2009

4 SQR Resolutions

It’s not New Year’s Eve, but I have some resolutions to use more of the rich features of SQR to write programs that are richly featured themselves.
Continue reading ‘4 SQR Resolutions’ »

Table Driven SQR

Table-Driven programming is a technique that can make a program more easy to write or less easy to write, more clear or less clear, more maintainable or less maintainable.  It can improve a program when we use it appropriately.
Continue reading ‘Table Driven SQR’ »

SQL Copy Function In SQR, Part 2

I wish SQL had a simple copy command. It would insert a new row into a table with almost all the values of an existing row of that table. Last week, we saw how to obtain data dictionary information from an Oracle database. This week our program will help us specify our needs and write SQL for us.

Continue reading ‘SQL Copy Function In SQR, Part 2’ »

SQL Copy Function In SQR, Part 1

I wish SQL had a simple copy command.  It would insert a new row into a table with almost all the values of an existing row of that table.
Continue reading ‘SQL Copy Function In SQR, Part 1’ »

Hooray For Arrays.Part(2)

Of course we can use arrays like tables.  What else can we do? Continue reading ‘Hooray For Arrays.Part(2)’ »