No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hello DBAs, Can any one guide me how can i get the last modified date(insert/update/delete) of a table? Regards, B. Mantri |
|
Hello DBAs, Any one familar with the ER diagram generation in TOAD. I am able to generate the diagram for one particular table. I need to generate for the whole schema. Can you please help me to find out a way? Always Thanks, BMantri |
|
Hello, I have created a synonym. But later I have dropped the base table which is referenced by this synonym. I thought that the synonym would be dropped automatically. But later I found it exists in all_synonyms and doesnt exist in user_objects dictionary. When i quried the date from this … |
|
Hello DBA, Can any one help me this? The table TEST contains CNAME CNO EXTRA ------------------------------ ---------- ---------- bijaya 645896 mantri 525896 mantri12 525126 testing for null My requirement is to find the column which contains all the rows null(null column) I have created the following procedure to accomplish this … |
|
Hello DBAs, Do you have any idea about the XML file used in SP. I want to pass it as input parameter. Thanks, BMantri |