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).
A bit more highbrow this time, can you guess the book titles from the SQL clues below?
-- it's just for fun:
SQL> alter system set "_scalar_type_lob_storage_threshold"=32000;
SQL> create table t_varchar32000(v varchar2(32000 byte));
SQL> insert into t_varchar32000
2 select rpad(rownum,31999) || `x' str from dual connect by level<=1000;
1000 rows created.
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:
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
If you work with clients with in different timezones, be wary of the CURRENT_DATE/CURRENT_TIMESTAMP functions:
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.
Can you guess the film titles suggested by these SQL clues? As always, put your answers in the comments!
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…
set sqlterminator ?
set sqlterminator !
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! ;)
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.