How to select oracle sequence from different schema ANS: a. SCHEMANAME.

How to select oracle sequence from different schema and

How to select oracle sequence from different Databases.

Explain with example

Question Posted / harikanth

1 Answers
5211 Views
Polaris, I also Faced
E-Mail Answers

Answer Posted / harikanth

How to select oracle sequence from different schema

ANS:
a. SCHEMANAME.SEQUENCENAME.CURRVAL.
b. SCHEMANAME.SEQUENCENAME.NEXTVAL

How to select oracle sequence from different Databases

ANS:

a. SCHEMANAME.SEQUENCENAME.CURRVAL@DBLINK
b. SCHEMANAME.SEQUENCENAME.NEXTVAL@DBLINIK

Thanks,
Hari

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are group functions in oracle?

965

How to create a new table in oracle?

1064

What is catalog in Oracle?

1263

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1870

Can we create trigger on materialized view in oracle?

937

Explain the features of oracle?

987

what is the dual table in oracle?

931

What is private procedure oracle?

952

What is bulk collect in oracle?

953

What are the set operators union, union all, minus & intersect meant to do?

935

Explain oracle’s server parameter file.

946

How do I uninstall oracle 11g?

1037

How to load data through external tables?

1068

What is an oracle tablespace?

981

What is using clause and give example?

996