[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

How can you tell if a table has a sequence associated?

Posted on 2009-07-13
3
Medium Priority
?
238 Views
Last Modified: 2012-05-07
I have numerous tables that I created sequences for and now want to ensure the sequences are in place...how do you check for this?

Thx
0
Comment
Question by:Glen_D
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 24844553
you cannot. there is no dictionary indication in oracle for this.
you could check if there is a trigger on the table using a sequence, or some stored procedure doing the inserts while using the sequence, but it could be as well the client application itself.
0
 

Author Closing Comment

by:Glen_D
ID: 31603048
very surprized that you can't review all code within a db...thx
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 24844725
you can "look" at all the code of the views, triggers, procedures etc:
select * from dba_code

however, to "analyse" it to find out if there is a insert/update using a given sequence on a given table is VERY far from trivial. peanuts for the human reader, but using some "code" to "understand" the code ...
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses
Course of the Month9 days, 5 hours left to enroll

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question