Sep 11, 2002 #1 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.
hi, i want to check if a sequence exist, there is a PL/SQl instruction for that ?? Thanks and scuse my english.
Sep 11, 2002 #2 karluk MIS Joined Nov 29, 1999 Messages 2,485 Location US select * from all_sequences where sequence_owner = 'OWNER_NAME' and sequence_name = 'SEQUENCE_NAME'; Upvote 0 Downvote
Sep 11, 2002 Thread starter #3 athom ISP Joined Apr 4, 2001 Messages 20 Location CA thanks ! Upvote 0 Downvote