Hi all
I've been reading a few articles on arbori and how it helps formatting code in SQL Developer. From what I understood, SQL Dev is written in Java, so it probably uses some kind of arbori library.
Without talking too much about the use case: would it be possible to format the code after saving the object (view, package, ...) directly within Oracle?
Like:
Type
CREATE VIEW v#my_test AS (SELECT 1 AS a, 2 AS b, 3 AS c FROM dual)
Run it
Open the declaration and find something like this:
CREATE VIEW v#my_test
AS
(SELECT 1 AS a
,2 AS b
,3 AS c
FROM DUAL);
Would this be possible? We have schema triggers that alter packages and views, so that part is covered. But is there a way to get arbori into Oracle?
Thanks in advance - I will gladly accept a no, but please don't just say what a stupid idea
Cheers
André