Call sequence without schema prefix

ratheeshknair · #1 (**permalink**) 07-16-09, 00:41

Hi Experts,

I have two schemas having same tables and another schema contain sequences.Is it possible to call the sequences from other two schemas not specifying the sequence schema?

Thanks in Advance

rahul_s80 · #2 (**permalink**) 07-16-09, 01:18

chk SET SCHEMA statement

stolze · #3 (**permalink**) 07-17-09, 10:10

Why wouldn't you want to specify the schema name? Each object in a database is uniquely identified by its fully qualified name, i.e. with the schema name.

Internet Services

Web Development

Digital Marketing

Consumer Tech