APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamically Updating Tables

881862Aug 11 2011 — edited Aug 12 2011

So what I'm trying to do is have either an external script or an APEX function:
1) Find information on all of the current tables in database (schema, table, columns) which isn't hard, at the moment I have a script .

More importantly I need a way to (preferably automatically, maybe once a day, but manually is fine too)
2) update a table with that information

Is there a way to do this with PL/SQL? That would be ideal, but running an external script works. Looking around, the REST API might work? But I wasn't sure how or if it works for this.

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 9 2011

Added on Aug 11 2011

#apex, #apex-discussions, #oracle, #pl-sql, #plsql, #query

5 comments

454 views