1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

How to select oracle sequence from different schema and

How to select oracle sequence from different Databases.

Explain with example

Question Posted / harikanth

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

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4936

How can we view last record added to a table?

614

How to rollback the current transaction in oracle?

548

What is oracle host variable?

540

What is redo log?

634




Explain about functional dependency and its relation with table design?

560

What do you mean by merge in oracle and how can you merge two tables?

533

What is recovery manager in Oracle?

599

How to use "out" parameter properly?

640

Where do you use decode and case statements?

558

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

620

State the various uses of dbcc command?

555

Calculate difference between 2 date / times in oracle sql?

583

How to best split csv strings in oracle 9i?

604

What is materialized view in Oracle?

640