hi, Refer to object-relational-developers-guide/Nested Table Locators ‘For large child sets, the parent row and a locator to the child set can be returned so that the child rows can be accessed on demand; the child sets also can be filtered. Using nested table locators enables yo...

Hi folks, I wrote a procedure that downloads spatial information for power lines via WFS from a web site and merges this into an existing table in my ADB. I wrote it in a way that it should use the parallel mode (pipelined table function, no triggers, jala jala...). This works gr...

How can you make an oracle table, index or partition 'lose' its storage definition and revert to tablespace defaults... I have a 'legacy' table in production that was built with storage parameters inherited from the 'consolidate storage' option on the old export utility (exp). It...

Hello i just wanted to ask you the (CASE WHEN THEN END;) is the ternary operator in oracle sql - pl/sql? thanks. I provided some example code above of java and pl/sql thanks!. /*plsql code*/ DECLARE myage NUMBER := 28; statusage VARCHAR(200) := NULL; BEGIN statusage := CASE WHEN ...

This query: with T1 as ( select 'A4' from dual union select 'A3' from dual union select 'A100' from dual union select 'A20' from dual ) select * from t1; produces the normal sort: A100 A20 A3 A4 In recent Oracle versions ( 19 and later ) is there a