Grassroots Oracle

Pages

▼
Showing posts with label Views. Show all posts
Showing posts with label Views. Show all posts
Wednesday, 29 January 2020

Unpivoting Oracle APEX meta-data

›
There are APEX dictionary views for most of the data that represents the 'source' that is your APEX application meta-data. Note:  ...
4 comments:
Wednesday, 18 April 2012

Finding stuff in ALL_VIEWS using XML

›
Quite some time ago when I first started blogging I wrote a post regarding limitations on searching the ALL_VIEWS dictionary view. Simpl...
Wednesday, 4 April 2012

Updating key-preserved inline views

›
I learnt something today - there is a scenario where you need update privileges on a table you aren't updating. Here is my example - I...
2 comments:
Thursday, 10 September 2009

A LONG view ahead

›
Every time a new version is release I feel compelled to have a little peak at the definition of ALL_VIEWS , to see if columns such as ALL_VI...
2 comments:
›
Home
View web version
Powered by Blogger.