Richard Aubin

I hope IVORYSQL's with clause supports procedure and function, same as Oracle!

2

### Functions in the WITH Clause The declaration section of the WITH clause can be used to define PL/SQL functions, as shown below. ``` WITH FUNCTION with_function(p_id IN NUMBER) RETURN...

I would like IvorySQL to have oracle Multitable Inserts statement support

3

**Multitable Inserts** Multitable inserts were introduced to allow a single INSERT INTO .. SELECT statement to conditionally, or unconditionally, insert into multiple tables. This statement reduces table scans and PL/SQL...

I would like IvorySQL to have oracle ROWUNM pseudocolumn support

1

ROWNUM Pseudocolumn For each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of...