view counter


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

Tree with Checkboxes: Save the Data - JS Array to PL/SQL

In two previous blogposts I described a method to transform a regular APEX Tree component to a Tree component with checkboxes. The second blogpost described a way to retrieve the data from the database using JSON and AJAX and check the appropriate checkboxes. In this last part of the series on Tree with Checkboxes I will describe a method to save the checked values to the database.
In this blogpost I will assume that you created the APEX tree as described in the other two blogposts (the links to these blogpost are at the bottom).

SQL Brainteasers: Guess the Book Title

A bit more highbrow this time, can you guess the book titles from the SQL clues below?

Little example of index creation on extended varchars

-- it's just for fun:
SQL> alter system set "_scalar_type_lob_storage_threshold"=32000;

System altered.
SQL> create table t_varchar32000(v varchar2(32000 byte));

Table created.

SQL> insert into t_varchar32000
2 select rpad(rownum,31999) || `x' str from dual connect by level<=1000;

1000 rows created.

SQL> commit;

Commit complete.

SQL> create index ix_t_varchar32000 on t_varchar32000(v) tablespace users;
create index ix_t_varchar32000 on t_varchar32000(v) tablespace users
ERROR at line 1:
ORA-01450: maxi

Results from the Q3 2013 PL/SQL Championship now available!

You will find below the rankings for the 2013-3 championship; the number next to the player's name is the number of times that player has participated in a championship.

Congratulations first and foremost to our top-ranked players:

1st Place: Michal Cvan of Slovakia

2nd Place: mentzel.iudith of Israel

More Date Mysteries: When Is Current SYS?

If you work with clients with in different timezones, be wary of the CURRENT_DATE/CURRENT_TIMESTAMP functions:

First-ever Tree Rescue Day - November 16

I invite all my friends and concerned strangers (though not for long, if you show up!) to participate in my first-ever Tree Rescue Day, on Saturday, November 16, from 10 AM to 12 PM, in Rogers Park, Chicago.

Trees - towering above us, living far beyond our small lives - shouldn't need our help, but they do. We humans, in our relentless quest for convenience and comfort, carelessly transfer species (plants, insects, animals, bacteria) around the world, disrupting the ecological balance established through millions of years of evolution.

SQL Brainteasers: Guess the Film Part 7

Can you guess the film titles suggested by these SQL clues? As always, put your answers in the comments!

Reflections on Starting the Database Design Quiz

select my_thoughts
from starting_the_db_design_quiz;

As regular readers will know, last month saw the start of the Database Design Quiz on the PL/SQL Challenge. I thought I’d share some of the background on how this came about and my thoughts and feelings on how it’s going, so here goes…

SQLTerminator: Not as Cool as the Real Terminator

set sqlterminator ?

select queries
from your_database?

Become questions

set sqlterminator !

select queries
from the_database!

Become exclamations!

You need to run in SQL*Plus to use this. I can’t think of a particularly good use – other than playing tricks on your colleagues! ;)

Oracle Database 12c PRAGMA UDF and WITH clause enhancements

Here are two interesting enhancements in Oracle database 12c PL/SQL. PL/SQL subprogram defined using WITH clause of a subquery – Oracle database 12c allows PL/SQL declaration section in the WITH clause. One can define PL/SQL function or procedure into a WITH clause.

view counter