[b}UPDATING UNKNOWN TABLE OR COLUMN [/b]

[teknikalbody]

Hi,

People I need some of assistance...

I have been asked to find all tables that may have the data = 'DATA' and then to update this with some new 'DATA'.

As you may appreciate there are thousands of tables on the system and the column may be called anything.

I have read some of the previuos "Dynamic" cursors threads but I don't understand as I have never used them before.

Thankyou for reading this and any suggestions are much appreciataed.

Bye

 

[SantaMufasa]

TB,

An example is worth 1000 words. Can you provide either 1000 words of explanation of what you want to do or post a good example?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 17:12 (21Feb05) UTC (aka "GMT" and "Zulu"),
@ 10:12 (21Feb05) Mountain Time

Do you use Oracle and live or work in Utah, USA? Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[teknikalbody]

Mufasa,

I don't have an example as such, but if I explain the process I currently have to do then it may clarify what
it is I am trying to achieve.

So here goes...

I am searching for a programme code = 'XXX' that was populated by an automated process.
I don't have access to the source code for this process so cannot tell exactly which table or columns were
populated.

So as a starting point recently I searched for all tables containing the word "PROGRAMME" producing around 20
tables e.g.

PROGRAMME_OF_STUDY
STUDENT_PROGRAMME
PG_PROGRAMME
..
..


Then for each of these tables I again looked for any column names containing the word "PROGRAMME".

Finally searching for the particular code i.e. "B3EE" in the data of the column.

Once identified I am then able to update the code.

I hope this has made it a little clearer and please ask me any questions if not.

Thank you.

 

[carp]

What is not clear to me is why you cannot ask whomever DOES have access to the code which tables are being updated. As a secondary option, if the code is in the form of a stored procedure, then could you not check the dependencies in the data dictionary to narrow down your search?
The alternative is going to be a long and ugly siege of your database.

 

[teknikalbody]

Carp

Thank you for your interest. Unfortunately the team I am working with is very new and do not have experience of Oracle Forms 3 which is what the procedure has been coded in.

Though I will give your data dictionary idea a whiz.

Thanks

 

[carp]

Ah, forms! Pity - there will be no information in the data dictionary if the code is in a form.
Could you not pull the form into Developer and see the code? You will need the form's file, of course, but if your company has the form that should not be a problem.