Home » SQL & PL/SQL » SQL & PL/SQL » Runtime data stored in tables
Runtime data stored in tables [message #675954] Wed, 01 May 2019 14:53 Go to next message
Messages: 1
Registered: May 2019
Junior Member

I am a complete newbie to oracle. so any help is appreciated.

The problem at hand is i am supposed to find the table name and column name where a particular string(s) are stored.
Whatever code i found online is not working as needed. (user
Could you pls help me with a code snippet ( procedure would be better) where i can enter a string and it needs to search all tables (user tables) in a database.

Also these columns are updated at run time.
If there is any way to find out all the columns in a database that are updated at runtime. pls advice. I am using TOAD for oracle not sql plus.
Thanks for your help.
Re: Runtime data stored in tables [message #675959 is a reply to message #675954] Wed, 01 May 2019 18:19 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member

Welcome to this forum

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read

How do you differentiate between runtime data & non-runtime data?
Previous Topic: Converting returned rows into columns
Next Topic: ORA-00933: SQL command not properly ended
Goto Forum:

Current Time: Sat May 18 20:39:30 CDT 2024