Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How Check table exist ?

Status
Not open for further replies.

athom

ISP
Joined
Apr 4, 2001
Messages
20
Location
CA
hi,

i want to check if a sequence exist, there is a PL/SQl instruction for that ??

Thanks and scuse my english.
 
select * from all_sequences
where sequence_owner = 'OWNER_NAME'
and sequence_name = 'SEQUENCE_NAME';
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top