I would like see append schema name for all the db objects at the press of a button for the whole screen.
ex: for table per_all_people_f, when I click the append schema button, it should add the real schema name, i.e, hr.per_all_people_f.
Also, the click button should have capability to overwrite all schema name to apps (this is the one developer should be able to define). If the db object does not have synonym created in apps schema, then it should retain the original schema name. Can this be done?
ex: for table per_all_people_f, when I click the append schema button, it should add the real schema name, i.e, hr.per_all_people_f.
Also, the click button should have capability to overwrite all schema name to apps (this is the one developer should be able to define). If the db object does not have synonym created in apps schema, then it should retain the original schema name. Can this be done?
