To end this year in glory, I tried to replace a row-level trigger (LSC_TR1) into a statement level trigger (LSC_TR2) SQL> create global temporary table lsc_t1(x number primary key) 2 on commit delete rows; Table created. SQL> create table lsc_t2(x number primary key); Table created. SQL> create table lsc_t3(x number primary key); Table created. SQL> […]
Month: December 2008
old-fashion listagg
Yesterday I had my first session about XML, today I have one about SQL Model Ok, it was the first time I spoke about XML so I did not really now where to focus. XML is so big, you have XQUERY, XPATH, dozens of XML functions in the database. One of the XML function is […]
HOT
CREATE TABLE T(X NUMBER PRIMARY KEY) ORGANIZATION HEAP; I have read the SQL reference more than once -believe me- but I did not notice this syntax until today… an HOT table is a simple table and this clause is optional. An IOT, or INDEX ORGANIZED TABLE, is a table where you mostly select thru an […]